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?

1076

What is the parse query button used for?

1087

What stored by the model?

1139

When is the use of update_statistics command?

1057

Does an index slow down updates on indexed columns?

1035

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

1358

What is sql server 2000 work load governor?

1160

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

1038

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

1138

What is nolock?

1037

What are the recovery models in sql server 2000?

1001

What is filestream?

1049

Where the sql logs gets stored?

1035

What is the syntax to execute the sys.dm_db_missing_index_details?

1075

What is policy management?

1047

Un-Answered Questions { SQL Server }

Some queries related to SQL

1036

What is cross join in sql server joins?

1202

What is left outer join in sql server joins?

1108

What is the use of for clause?

1166

How to filter out duplications in the returning rows in ms sql server?

1215

What is the difference between a primary key and a unique key? Are they the same?

1125

What is reportserver and reportservertempdb ?

160

What is the function of inner join?

1126

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1170

What is Command line parameters in PLSQL.?

1195

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1192

What factors you will consider calculating the storage requirement for that view?

992

How to enforce security in sql server? : sql server security

1162

List out what other servers you can use with ssrs?

145

What is cached report?

150

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