SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

How many triggers are possible per table?

1095

What is the maximum number of index per table?

1071

How to recompile stored procedure at run time?

1068

What are the different types of stored procedures?

1112

What is difference between rollback immediate and with no_wait during alter database?

1088

What is merge statement?

1076

Explain throw statement in sql server 2008?

989

What is nonclustered index on computed columns?

952

Explain some stored procedure creating best practices or guidelines?

931

Explain try...catch with sql server?

1021

What are sp_configure commands and set commands?

1018

What is the ‘fillfactor’?

966

What is read uncmmited?

1053

What is an sql server agent?

1059

What is the difference between for trigger and after trigger?

1101

Un-Answered Questions { SQL Server }

How to count duplicated values in a column in ms sql server?

1083

What is cursors? And what are the different types of cursor?

1142

How do we know if any query is retrieving a large amount of data or very little data?

973

Explain transaction server auto commit?

1038

What are the transaction properties?

1010

What is the fastest way to permanently delete a 1 million row table named customers?

1252

What is Extended user-defined?

957

What is Dependency Injection and provide example?

1113

What is the difference between delete and truncate statements?

1074

How to provide login information for a new odbc dsn?

1050

What is a with(nolock)?

980

What are the differences between left join and inner join in sql server?

1104

Explain what is it unwise to create wide clustered index keys?

975

State the difference between union and union all?

926

List all the types of user-defined functions?

1094

For More Un-Answered { SQL Server } Questions Click Here