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?

1041

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?

1146

Why should you use or avoid select * statements?

1038

When should you use an instead of trigger?

968

What is an indexed view?

973

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

1005

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

1085

how you can list all the tables in a database?

1036

What is a mixed extent?

1039

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

1068

What stored procedure would you use to view lock information?

984

What are information schema views?

997

What is an entity-relationship diagram (erd)?

1228

What is the difference between for auto and for nested?

1021

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

976

Un-Answered Questions { SQL Server }

How to create a view using data from another view?

957

What is the difference RDBMS and Graph Database?

1059

How to loop through result set objects using mssql_fetch_array()?

1096

Why use “nolock” in sql server?

1067

What are the database objects? : SQL Server Architecture

1061

What stored by the msdb? : sql server database administration

1015

Where are SQL server users names and passwords are stored in sql server?

1280

Do comments need to go in a special place in sql server 2005?

868

How to change the name of a database user?

967

how you can move data or databases between servers and databases in sql server? : Sql server administration

982

How can you ensure that the database and sql server based application perform well?

1089

How to optimize stored procedure optimization?

904

Explain the Ways to improve the performance of a sql azure database?

What is SQL Azure?

107

How to use the inserted and deleted pseudo tables?

975

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