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?

1084

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

1150

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

1017

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

1026

What will be the maximum number of indexes per table?

1014

What xml support does the sql server extend?

1053

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

1182

What do you mean by data integrity?

1123

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

1064

What is the cartesian product of the table?

1002

What is a deadlock and what is a live lock?

1040

Explain unique key in sql server?

1047

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

1006

What is the difference between primary key and unique constraints?

1005

Write a sql query to display the current date?

1141

Un-Answered Questions { SQL Server }

How to include date and time values in sql statements?

1137

What is sleeping status in sql server?

1072

What are filegroups in sql server?

1097

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

977

System variable and temporary variables

2296

What are “lock” hints?

1101

How to check status of stored procedure in sql server?

1034

What is a constant or literal in ms sql server?

1096

Explain the difference between functions and stored procedures in sql server?

1018

Why do we use functions?

954

Can two different columns be merged into single column? Show practically?

1117

What is merge statement?

1131

Explain acid?

1138

Can we create clustered index on composite key?

1163

What are system databases in ms sql server?

1117

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