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?

1020

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

1084

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

970

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

959

What will be the maximum number of indexes per table?

955

What xml support does the sql server extend?

1003

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

1093

What do you mean by data integrity?

1063

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

998

What is the cartesian product of the table?

950

What is a deadlock and what is a live lock?

995

Explain unique key in sql server?

1006

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

952

What is the difference between primary key and unique constraints?

951

Write a sql query to display the current date?

1091

Un-Answered Questions { SQL Server }

What are the pre-defined functions in the sql server?

1099

Mention the differences between having and where clause.

1055

Which is faster statement or preparedstatement?

933

what happens on checkpoint? : Sql server database administration

1090

What is co-related sub query?

1018

Explain about local stored procedure?

964

What is partition in sql server?

1033

How can we rewrite sub-queries into simple select statements or with joins?

974

What is data source view or dsv? : sql server analysis services, ssas

1000

What is shrink log file?

895

what is the difference between count(*) and count(1) ?

1079

What is query optimizer in sql server?

1014

What is a schema in ms sql server 2005?

962

What is exporting utility?

1007

Is sql server a database?

986

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