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

1023

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

1197

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

1155

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

992

what is a live lock? : Sql server database administration

1021

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

1052

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

1056

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

980

what is a join? : Sql server database administration

1331

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

1087

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

1087

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

1022

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

1107

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

1000

Un-Answered Questions { SQL Server }

Explain Geometry datatype in sql server 2008 with example

1049

explain how to create a new schema in a database? : Sql server database administration

1159

What are system databases into sql server (2005/2008)?

1051

How do you delete duplicate rows in sql server?

1009

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1270

What is user-defined function?

1035

How to store and query spatial data?

1049

on line cluster can we make if yes tell me the procedure

2070

What's the information that can be stored inside a bit column?

1074

Can we write a distributed query and get some data which is located on other server and oracle database?

1282

How to write a query with a left outer join in ms sql server?

1033

How you can change a cross join into an inner join?

1024

tell me the disaster recovery plan

2568

What is a heap?

1086

Does transparent data encryption provide encryption when transmitting data across the network?

1101

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