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?

962

How sql server enhances scalability of the database system?

1216

What is partitioned view?

899

Define compound operators?

913

What are the filtered indexes?

1040

Explain transaction server consistency?

973

What is it unwise to create wide clustered index keys?

1007

Explain transaction server implicit?

983

Define inner join? Explain with an example?

996

Explain the difference between function and stored procedure?

942

Explain the architecture of ms sql reporting service?

921

What is lock escalation and what is its purpose?

974

Explain syntax for dropping triggers?

928

Explain datetimeoffset data type in sal server 2008?

907

What is buffer cash in sql server?

1152

Un-Answered Questions { SQL Server }

How can you start sql server in different modes?

970

What is a dataset and what are the different types of datasets?

136

What is the command used to check locks in microsoft sql server?

1044

How to rename an existing column with sql server management studio?

999

Explain powershell included in sql server 2008?

1055

What is the Control Flow in SSIS

1092

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

988

What is the difference between varchar and nvarchar?

941

How to automatically create a log when an exception is being received into SQL Server?

1287

What is SQL Azure?

107

Explain how to use linked server?

991

What is the Difference Between Primary and Foreign Key?

1006

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

923

What is data mart? : sql server analysis services, ssas

1055

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2581

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