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?

1082

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?

1194

Why should you use or avoid select * statements?

1079

When should you use an instead of trigger?

1028

What is an indexed view?

1012

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

1048

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

1128

how you can list all the tables in a database?

1072

What is a mixed extent?

1080

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

1108

What stored procedure would you use to view lock information?

1021

What are information schema views?

1035

What is an entity-relationship diagram (erd)?

1317

What is the difference between for auto and for nested?

1068

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

1018

Un-Answered Questions { SQL Server }

What is the difference in accessing db between sql server vs sql azure?

174

what is a self join? Explain it with an example? : Sql server database administration

1004

What is a natural primary key?

1112

What is sub-query in sql server?

1261

What does nvl stand for?

998

What are basics of policy management?

1155

What are the functions in sql server?

995

Why use update_statistics command in sql server?

1115

How to insert multiple rows with one insert statement in ms sql server?

1182

Can we use where clause in union?

1128

What are the purpose of Normalisation?

1098

What are the new features are introduced in sql server 2012 reporting services?

160

Explain the xml support sql server extends?

1086

How to grant a permission in ms sql server using "grant execute" statements?

1137

What are different types of data sources?

1085

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