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 recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1014

How sql server enhances scalability of the database system?

1315

What is partitioned view?

960

Define compound operators?

964

What are the filtered indexes?

1093

Explain transaction server consistency?

1017

What is it unwise to create wide clustered index keys?

1044

Explain transaction server implicit?

1028

Define inner join? Explain with an example?

1046

Explain the difference between function and stored procedure?

996

Explain the architecture of ms sql reporting service?

970

What is lock escalation and what is its purpose?

1026

Explain syntax for dropping triggers?

967

Explain datetimeoffset data type in sal server 2008?

972

What is buffer cash in sql server?

1204

Un-Answered Questions { SQL Server }

State a few properties of relational databases?

1179

What are scalar functions in sql?

1208

What are subqueries in sql server? Explain its properties.

1067

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1119

What is difference between rownum and rowid?

956

what are the new features introduced in sql server 2000? : Sql server database administration

978

How to recover from sql injection? : sql server security

1065

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1003

What is the difference between writing data to mirrored drives versus raid5 drives

988

how to create a scrollable cursor with the scroll option? : Sql server database administration

1147

how can a database be repaired? : Sql server administration

1016

What is the New in SQL server 2008?

1017

How to enable/disable indexes?

1123

What are the types of database recovery models?

1186

How do you create type- insensitive operator?

1098

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