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

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1079

What is the parse query button used for?

1091

What stored by the model?

1141

When is the use of update_statistics command?

1062

Does an index slow down updates on indexed columns?

1040

What command would you use to add a column to a table in sql server?

1361

What is sql server 2000 work load governor?

1163

Are semicolons required at the end of sql statements in sql server 2005?

1039

How do I perform an unattended install of sql server 2000?

1146

What is nolock?

1041

What are the recovery models in sql server 2000?

1004

What is filestream?

1052

Where the sql logs gets stored?

1039

What is the syntax to execute the sys.dm_db_missing_index_details?

1079

What is policy management?

1050

Un-Answered Questions { SQL Server }

What are transactions and its controls?

1109

What is difference between unique and primary key?

972

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

1015

Explain about protocol layer present in SQL server?

1298

How to create sub reports?

252

What is 5nf in normalization form?

1048

Can we insert data into a view?

1196

How to rebuild master databse?

1130

How do you trace the traffic hitting a sql server?

1199

How to add the custom code in Report?

129

How many types of triggers in sql server?

1097

Do you know what is blocking?

998

What is report snapshot?

163

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5979

What are different types of table joins?

1057

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