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.

1141

Explain the dirty pages?

1050

What are magic tables in sql server?

1197

List few advantages of stored procedure.

1026

What is the difference between locking and multi-versioning?

1038

Differentiate between a local and a global temporary table?

996

Explain the collation?

1146

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

934

Describe how to use linked server?

1076

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

1011

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

1059

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

1049

What is a trace frag?

1132

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

1003

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

1151

Un-Answered Questions { SQL Server }

What are trace flags?

1084

What is named query? : sql server analysis services, ssas

1001

How global temporary tables are represented and its scope?

1011

What is the difference between locking and multi-versioning?

1038

Explain Capacity planning to create a database? and how to monitor it?

4243

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1048

How do you manipulate data?

949

How do I debug a stored procedure in sql server?

1174

Can a table be moved to different filegroup?

1025

what is a sub-report?

146

What command do we use to rename a db, a table and a column?

978

How can windows applications connect to sql servers via odbc?

1175

Which is faster statement or preparedstatement?

1001

What is a trigger? Why we need it?

1053

What are approximate numeric data types in ms sql server?

1103

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