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.

906

What is openxml in sql server?

1119

What is replace and stuff function in sql server?

1005

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

970

What is scheduled job and how to create it?

929

Describe in brief sql server monitoring ways.

1009

Differentiate between delete and truncate.

1005

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

958

Why do we need different type of parameter?

1003

What do you mean by acid?

946

What is rank function?

989

Explain different types of locks in sql server.

1017

What are the benefits of normalization?

1052

What are distributed partitioned views?

1012

Differentiate between a primary key and a unique key.

1008

Un-Answered Questions { SQL Server }

Do you know what is a with(nolock)?

1006

how many triggers you can have on a table? : Sql server database administration

919

Can we write ddl in trigger?

870

Where to find ntwdblib.dll version 2000.80.194.0?

930

What is scd (slowly changing dimension)? : sql server analysis services, ssas

958

Explain isolation levels that sql server supports?

993

What are different type of Collation Sensitivity?

953

How to count rows with the count(*) function in ms sql server?

960

How to delete all rows with truncate table statement in ms sql server?

940

Tell me what is use of except clause? How it differs from not in clause?

909

What is the difference between row_number and dense_rank?

836

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

920

What are the benefits and tasks of object explorer? : sql server management studio

1123

How to get a list of all tables with "sys.tables" view in ms sql server?

988

in the physical file layout, where should the transaction log be stored in relation to the data file?

948

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