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.

1094

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?

1106

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?

1098

Un-Answered Questions { SQL Server }

How to create database with physical files specified in ms sql server?

993

What do you understand by hotfixes and patches in sql server?

991

What is a hint?

993

What is the library index called?

1059

How can we get count of the number of records in a table?

954

What is model database in sql server?

1050

How many replicas are maintained for each sql azure db?

124

How does using a separate hard drive for several database objects improves performance right away?

932

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

1892

What does indexation mean?

973

What are the instances when triggers are appropriate?

979

What are parameterized reports?

200

Difference between group by clause and having clause in SQL?

971

what purpose does the model database serve? : Sql server database administration

977

How to retrieve field values using mssql_result()?

1313

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