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 is a not null constraint?

977

What is the use of “join” in sql server?

1020

What are the steps you will take to improve the performance of a poor performing query?

927

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

911

What will be the maximum number of indexes per table?

912

What xml support does the sql server extend?

958

What is a join in sql? What are the types of joins?

1010

What do you mean by data integrity?

998

How can we determine what objects a user-defined function depends upon?

952

What is the cartesian product of the table?

902

What is a deadlock and what is a live lock?

952

Explain unique key in sql server?

955

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

892

What is the difference between primary key and unique constraints?

904

Write a sql query to display the current date?

1030

Un-Answered Questions { SQL Server }

What is the osql utility?

911

Explain transaction server implicit?

925

What is difference between oltp and olap?

984

Explain cdc and sql injection?

913

what is a transaction and what are acid properties? : Sql server database administration

966

What is the primary use of the model database?

1020

How to enable/disable indexes?

1016

Does partitioning improve performance?

920

What is indexed view? How to create it?

932

Distinguish between commit and rollback?

901

Explain ranking functions?

993

What is attribute relationships, why we need it? : sql server analysis services, ssas

911

What is sql collation?

1139

can you instantiate a com object by using t-sql? : Sql server database administration

963

How to get @@error and @@rowcount at the same time?

985

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