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

What is the difference between for xml raw and for xml auto?

1076

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1190

Why should you use or avoid select * statements?

1071

When should you use an instead of trigger?

1017

What is an indexed view?

1005

How can you know if the row fetched from cursor is still valid in underlying table?

1043

What is the difference between a primary key and a unique key? Are they the same?

1119

how you can list all the tables in a database?

1067

What is a mixed extent?

1078

After removing a table from database, what other related objects have to be dropped explicitly?

1101

What stored procedure would you use to view lock information?

1016

What are information schema views?

1027

What is an entity-relationship diagram (erd)?

1309

What is the difference between for auto and for nested?

1062

Why it is recommended to avoid referencing a floating point column in the where clause?

1009

Un-Answered Questions { SQL Server }

What is the command to change the recovery model?

1091

How to create new databases with "create database" statements?

1067

How to replace the Query Result 'Null Value' with a text ?

1093

What causes index fragmentation?

1045

What is the default schema of your login session in ms sql server?

1092

What is the default fill factor value?

1127

What are tables in sql server?

1095

How do I find the query plan in sql server?

1015

What is the use of custom fields in report?

1041

How to create view in stored procedure sql server?

1055

what are the different types of replication you can set up in sql server? : Sql server database administration

1061

What is the security model used in sql server 2005?

1066

where can you add custom error messages to sql server? : Sql server administration

1172

which table keeps the locking information? : Sql server administration

1138

What do you mean by an execution plan? Why is it used?

1075

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