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

1027

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

1017

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

1193

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

1152

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

992

what is a live lock? : Sql server database administration

1019

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

1050

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

1052

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

980

what is a join? : Sql server database administration

1325

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

1086

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

1083

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

1021

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

1105

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

998

Un-Answered Questions { SQL Server }

1 01 101 01010

2100

Give the query of getting last two records from the table in SQL SERVER?

1009

Detail about the hardware which is supported by SQL server?

1119

How many servers can we create in a single subscription?

162

Can multiple columns be used in sql group by clause in ms sql server?

1118

Tell me what do we need queues in sql service broker?

1052

What is database black box testing?

1072

What is function of ROLLUP ?

1140

How you can get a list of all the table constraints in a database?

999

How would you choose between a clustered and a non-clustered index?

1019

When to use Inner join & when to use subquery?

1238

What are the steps you will take to improve the performance of a poor performing query?

1019

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1021

How to create a login account in ms sql server to access the database engine using "create login" statements?

1195

Can sql servers linked to other servers?

1097

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