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

954

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

927

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

1014

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

1019

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

907

what is a live lock? : Sql server database administration

910

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

966

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

970

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

882

what is a join? : Sql server database administration

1155

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

1000

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

962

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

915

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

986

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

898

Un-Answered Questions { SQL Server }

Can group by be used without aggregate functions?

869

explain different types of joins? : Sql server database administration

941

What is the difference between update lock and exclusive lock?

929

What is parameterized reports in ssrs ?

144

What are the recovery models in sql server 2000?

931

How to create stored procedures with parameters in ms sql server?

1012

Define full outer join?

902

What does asynchronous call backs means?

1089

What are the pre-defined functions in the sql server?

1055

Why I am getting this error when dropping a database in ms sql server?

1037

What is trace flag in sql server?

989

Why are views required in the sql server or in any other database?

922

How to delete an existing database user?

977

What is a raid and what are different types of raid configurations?

1218

What are the dmvs? : sql server database administration

1019

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