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.

1145

Explain the dirty pages?

1054

What are magic tables in sql server?

1203

List few advantages of stored procedure.

1027

What is the difference between locking and multi-versioning?

1041

Differentiate between a local and a global temporary table?

1009

Explain the collation?

1149

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

938

Describe how to use linked server?

1082

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

1017

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

1064

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

1057

What is a trace frag?

1136

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

1006

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

1162

Un-Answered Questions { SQL Server }

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1072

How can I tell if sql server is 32 or 64 bit?

1014

What are the different types of sql server replication? : sql server replication

1369

explain different types of cursors? : Sql server database administration

1148

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1117

Explain primary key, foreign key and unique key?

1024

Is sql server is free?

1017

How many non clustered indexes there can be on table ?

963

What is trace flag in sql server?

1081

Explain the difference between delete,drop and truncate in SQL Server?

1164

Is foreign key unique?

1050

How to define the name and server for a new dsn?

1198

How to set a database state to offline in ms sql server?

1107

Explain the use of containers in ssis?

1018

Differentiate between sql temp table vs table variable?

927

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