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?

1098

What is the maximum number of index per table?

1073

How to recompile stored procedure at run time?

1075

What are the different types of stored procedures?

1117

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

1089

What is merge statement?

1080

Explain throw statement in sql server 2008?

991

What is nonclustered index on computed columns?

957

Explain some stored procedure creating best practices or guidelines?

936

Explain try...catch with sql server?

1021

What are sp_configure commands and set commands?

1022

What is the ‘fillfactor’?

968

What is read uncmmited?

1058

What is an sql server agent?

1063

What is the difference between for trigger and after trigger?

1106

Un-Answered Questions { SQL Server }

What is the difference between varchar and varchar types?

1071

What is transaction server explicit transaction?

1029

what is a check constraint?

1116

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1039

What are difference between Cluster index and Non-Cluster index?

1079

how many type of indexing in database?

980

Define Business Edition in SQL Azure?

100

What are horizontal and vertical scaling?

172

How can I get data from a database on another server?

995

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1064

How to concatenate two strings in SQL Server.

1149

What is difference in performance between insert top (n) into table and using top with insert?

1045

How to get a list of columns in a view using the "sp_columns" stored procedure?

1040

List out some of the requirements to set up a sql server failover cluster?

1034

on line cluster can we make if yes tell me the procedure

2023

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