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

What are the steps you can take to avoid “deadlocks”?

978

Explain user defined views?

963

What is catalog views?

1068

What is table-valued sub query?

967

What is the difference between a function and a stored procedure?

1070

What is the difference between update lock and exclusive lock?

976

Does the order of columns in update statements matter?

913

What is use of @@ spid in sql server?

1213

How to delete duplicate rows from table except one?

989

Can we insert data if clustered index is disabled?

939

Explain system rowset functions?

998

How can we solve concurrency problems?

1054

How can I check that whether automatic statistic update is enabled or not?

1042

If any stored procedure is encrypted, then can we see its definition in activity monitor?

987

What are wait types?

1113

Un-Answered Questions { SQL Server }

Explain what is cte (common table expression)?

1131

What stored by the model?

1059

How to read data in a table with "select" statements?

967

What does the on delete cascade option do?

1017

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

155

What is dml command?

965

How to loop through the result set with @@fetch_status?

1346

Explain what are the basic functions for master, msdb, model, tempdb databases?

977

what is a schema in sql server 2005? : Sql server database administration

1027

What do you mean by stored techniques? How would we use it?

1034

What is rtm version in sql server?

1049

How and why use sql server?

1007

Can you tell me some of the common replication dmv's and their use? : sql server replication

926

How to link tables in sql server?

932

explain how to create a new schema in a database? : Sql server database administration

1106

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