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?

1028

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?

1136

Why should you use or avoid select * statements?

1020

When should you use an instead of trigger?

952

What is an indexed view?

950

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

995

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

1075

how you can list all the tables in a database?

1022

What is a mixed extent?

1008

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

1049

What stored procedure would you use to view lock information?

970

What are information schema views?

975

What is an entity-relationship diagram (erd)?

1205

What is the difference between for auto and for nested?

998

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

957

Un-Answered Questions { SQL Server }

What are secondary xml indexes?

1023

Can we perform backup restore operation on tempdb? : sql server database administration

991

What is 1nf normalization form?

1027

What is nolock?

973

Why do we need normalization?

920

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

996

What is temporal data type?

912

What are the differences between ms sql server & oracle?

1053

What is database dimension? : sql server analysis services, ssas

1074

What are the new data types are introduced in sql 2000?

896

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

1064

Name 3 ways to get an accurate count of the number of records in a table?

1034

What is PROJECTION Operation?

1012

What are the acid properties?

1001

Explain concepts of analysis services?

954

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