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 report and query parameter.

1095

Explain the dirty pages?

1005

What are magic tables in sql server?

1133

List few advantages of stored procedure.

981

What is the difference between locking and multi-versioning?

989

Differentiate between a local and a global temporary table?

954

Explain the collation?

1107

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

881

Describe how to use linked server?

1018

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

965

Give a example to search fr a string in all stored procedure in sql server.

986

Explain the etl (extraction, transformation, and loading)?

995

What is a trace frag?

1085

Is it possible for a stored procedure to call itself or recursive stored procedure?

952

What is similarity and difference between truncate and delete in sql?

1101

Un-Answered Questions { SQL Server }

Explain four layers of abstraction microsoft architectured?

147

What are the properties of the transactions?

1119

What is read uncmmited?

1058

Explain different forms of normalization?

945

What is optimization and its types?

978

What is normalization? Explain different forms of normalization?

1160

Explain different types of self contained sub query?

1038

How to remove duplicate rows from table?

1248

What does it mean to manipulate data?

992

What is parameterized reports in ssrs ?

149

What are cursors and when they are useful?

1089

How to receive output values from stored procedures?

1146

What is difference between foreign key and unique key?

1011

Can we call stored procedure in view in sql server?

898

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1058

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