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

how would you troubleshoot blocking? : Sql server database administration

980

how many triggers you can have on a table? : Sql server database administration

976

can we have a nested transaction? : Sql server database administration

1092

how to invoke a trigger on demand? : Sql server database administration

1085

what is a correlated sub-query? : Sql server database administration

941

what is a live lock? : Sql server database administration

955

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1008

explain what is raid and what are different types of raid configurations? : Sql server database administration

1002

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

915

what is a join? : Sql server database administration

1247

how to control the amount of free space in your index pages? : Sql server database administration

1036

when you create a database how is it stored? : Sql server database administration

1022

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

953

what is raid and what are different types of raid configurations? : Sql server database administration

1041

what are database files and filegroups? : Sql server database administration

945

Un-Answered Questions { SQL Server }

What is after dml trigger?

1016

Do you know what is blocking?

959

How to make remote connection in database?

1005

What are the types of database recovery models?

1123

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

Explain primary key and foreign key constraints?

1031

What is repeatable read?

1015

What is master database? : SQL Server Architecture

1019

Can you edit the .rdl code associated with a linked report?

163

Explain what are the different index configurations a table can have?

1109

Explain Capacity planning to create a database? and how to monitor it?

4204

Tell me extended events in sql server 2008?

996

Do you know what is fill factor and pad index?

1004

What is the dbcc command and why is it used?

1052

how to avoid cursors? : Sql server database administration

969

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