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

Difference between drill down and drill through report.

1003

What is openxml in sql server?

1219

What is replace and stuff function in sql server?

1113

What are the rules to use the rowguidcol property to define a globally unique identifier column?

1075

What is scheduled job and how to create it?

1037

Describe in brief sql server monitoring ways.

1098

Differentiate between delete and truncate.

1112

You want to implement the many-to-many relationship while designing tables. How would you do it?

1046

Why do we need different type of parameter?

1108

What do you mean by acid?

1058

What is rank function?

1084

Explain different types of locks in sql server.

1128

What are the benefits of normalization?

1156

What are distributed partitioned views?

1135

Differentiate between a primary key and a unique key.

1116

Un-Answered Questions { SQL Server }

Do you know what is openxml in sql server?

1113

If the job running very slow what is the action you do

1942

How to use column default values in insert statements in ms sql server?

1099

What is Lock table in SQL?

1519

What is sql server management studio? : sql server management studio

1125

What is the exact numeric data type in sql?

1056

How do I make a resultset scrollable?

1012

Explain in brief how sql server enhances scalability of the database system?

1026

What are the different SQL Server Versions you have worked on?

1060

What is the difference in accessing db between sql server vs sql azure?

174

Do you know what is fill factor and pad index?

1045

How to encrypt Strored Procedure in SQL SERVER?

1229

What is trigger and different types of Triggers?

1199

Write a query for primary key constraint with identity key word?

1080

Why do you want to join software field as you have done your BE in Electronics?

2195

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