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.

956

What is openxml in sql server?

1168

What is replace and stuff function in sql server?

1065

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

1021

What is scheduled job and how to create it?

993

Describe in brief sql server monitoring ways.

1052

Differentiate between delete and truncate.

1062

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

997

Why do we need different type of parameter?

1057

What do you mean by acid?

999

What is rank function?

1030

Explain different types of locks in sql server.

1079

What are the benefits of normalization?

1109

What are distributed partitioned views?

1075

Differentiate between a primary key and a unique key.

1070

Un-Answered Questions { SQL Server }

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2076

Can foreign key be duplicate?

1060

What is an index in sql?

1006

What is self contained scalar sub query?

974

What is command parameter in ssrs?

161

Do you know what is replace and stuff function in sql server?

1014

Why would you call update statistics?

1018

Explain raiserror in sql server?

1024

What are various aggregate functions that are available?

981

How to retrieve error messages using mssql_get_last_message()?

1054

What is the default sql server instance name?

1034

Do you know what are different types of replication in sql server?

1099

What is table join?

1115

How to achieve Paging of records in SQL SERVER?

1100

How to connect to a sql server using odbc_connect()?

1154

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