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

982

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

976

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

1094

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

1086

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

1009

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

1250

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

1037

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

1023

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 }

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1041

What are the difference between clustered and a non-clustered index?

1043

Explain foreign key in sql server?

1030

After removing a table from database, what other related objects have to be dropped explicitly?

1055

Can you explain what are commit and rollback in sql?

940

What are the advantages of using third-party tools?

998

what is the difference between openrowset and openquery?

1087

What are different types of join?

1315

Do you know what is a linked server in sql server?

1024

Is sql server free?

917

Can I work with several databases simultaneously? : sql server management studio

988

What is difference between Datepart() and Datename() in SqlServer?

1203

How to rename databases in ms sql server?

1204

Can you please explain the difference between function and stored procedure?

1007

Explain about SQLOS?

1010

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