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?

1087

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

1154

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

1018

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

1028

What will be the maximum number of indexes per table?

1016

What xml support does the sql server extend?

1056

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

1188

What do you mean by data integrity?

1126

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

1067

What is the cartesian product of the table?

1003

What is a deadlock and what is a live lock?

1040

Explain unique key in sql server?

1050

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

1010

What is the difference between primary key and unique constraints?

1008

Write a sql query to display the current date?

1142

Un-Answered Questions { SQL Server }

How do I install sql server?

936

Give me any three differences between Truncate and Delete.

1155

Explain the properties of subqueries in sql server?

1138

Can we call stored procedure in trigger?

996

What are ddl (data definition language) statements for tables in ms sql server?

1149

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1132

can any body tell me how to know the password of current user in sql server

2119

What is sql sandbox in sql server?

1292

List the advantages of using stored procedures?

1106

How to integrate the ssrs reports in application?

1039

What are the tools available in market as an alternative to sql server reporting services?

138

How to delete duplicate rows from table except one?

1041

Where in ms sql server is ’100’ equal to ‘0’?

1130

Can sql server be linked with other servers like oracle?

1021

What is join query?

938

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