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?

1025

What is the parse query button used for?

1038

What stored by the model?

1059

When is the use of update_statistics command?

1005

Does an index slow down updates on indexed columns?

972

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

1308

What is sql server 2000 work load governor?

1064

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

995

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

1086

What is nolock?

983

What are the recovery models in sql server 2000?

961

What is filestream?

1001

Where the sql logs gets stored?

986

What is the syntax to execute the sys.dm_db_missing_index_details?

1028

What is policy management?

996

Un-Answered Questions { SQL Server }

What is mean by candidate key?

1011

Explain “@@rowcount” and “@@error” in sql server?

1088

What is a data source or ds? : sql server analysis services, ssas

1006

What are the differences between stored procedure and the dynamic sql?

1092

Is the log file is a part of file group?

1039

How to run sql server 2005 books online on your local system?

961

How to get nth highest salary from employee table.

1163

What are the differences between left join and inner join in sql server?

1107

How to delete a login name in ms sql server?

1073

Is the order of columns in the set clause important in ms sql server?

968

Why we need to use secondry database file? though, we can do same work using primary database file also.

6885

What is nolock hint in sql server 2008

1127

Difference between report and query parameter.

1094

Is it possible to replicate data from sql server to oracle? : sql server replication

1093

List out different types of normalizations in sql server and explain each of them?

929

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