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?

1144

What is the maximum number of index per table?

1124

How to recompile stored procedure at run time?

1123

What are the different types of stored procedures?

1162

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

1138

What is merge statement?

1139

Explain throw statement in sql server 2008?

1056

What is nonclustered index on computed columns?

1001

Explain some stored procedure creating best practices or guidelines?

1006

Explain try...catch with sql server?

1072

What are sp_configure commands and set commands?

1083

What is the ‘fillfactor’?

1019

What is read uncmmited?

1121

What is an sql server agent?

1118

What is the difference between for trigger and after trigger?

1167

Un-Answered Questions { SQL Server }

Can you explain the disadvantages/limitation of the cursor?

1059

What is the usage of the sign function?

1200

What is tempdb in sql server?

1031

How to create a simple user defined function in ms sql server?

1070

what is denormalization and when would you go for it? : Sql server database administration

1262

How will you know when statistics on a table are obsolete?

1132

What is model database? : SQL Server Architecture

1194

Do you know what is openxml in sql server?

1119

What is index, cluster index and nonclustered index?

1054

Explain about integration services of Microsoft SQL server?

1093

What is query optimization process?

1083

Can we use pragma autonomous_transaction in trigger?

1018

Explain the etl (extraction, transformation, and loading)?

1058

Explain what is “asynchronous” communication in sql server service broker?

963

How many clustered indexes there can be on table ?

1075

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