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?

1018

What is the parse query button used for?

1030

What stored by the model?

1049

When is the use of update_statistics command?

996

Does an index slow down updates on indexed columns?

969

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

1304

What is sql server 2000 work load governor?

1055

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

985

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

1080

What is nolock?

973

What are the recovery models in sql server 2000?

952

What is filestream?

997

Where the sql logs gets stored?

980

What is the syntax to execute the sys.dm_db_missing_index_details?

1021

What is policy management?

990

Un-Answered Questions { SQL Server }

What is a deadlock and what is a live lock?

995

Do you know the capabilities of cursors?

1143

What is the full meaning of dml?

945

What is model database in sql server?

1047

What is onf in normalization form?

1051

what is normalization? : Sql server database administration

1092

How do I uninstall sql server 2014?

927

How to loop through result set objects using odbc_fetch_row()?

972

What is Extended user-defined?

955

What are a database and a data warehouse?

1020

What are sub reports and how to create them?

139

What is the difference between executequery () and executeupdate ()?

1028

Does partitioning improve performance sql server?

974

Explain the properties of a relational table?

1015

How much does sql server 2016 cost?

1057

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