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

What do we need queues in sql service broker?

1120

Define self join in sql server joins?

994

What is importing utility?

1037

Define model database?

1032

Define outer join?

1045

Explain the different types of joins?

1043

How except clause is differs from not in clause?

1007

Define outer join in sql server joins?

988

What is sql server english query?

1197

Explain the difference between cross join and full outer join?

1030

Explain different forms of normalization?

1001

Explain the disadvantages/limitation of the cursor?

1006

What are different types of raid levels?

1235

What is hot add cpu in sql server 2008?

982

Define cross join in sql server joins?

1078

Un-Answered Questions { SQL Server }

Can you explain powershell included in sql server 2008?

989

Explain table valued parameters in sql server? Why tvp used?

1066

What is the latest version of microsoft sql server?

1114

What options are available to audit login activity? : sql server security

1196

What is a primary key?

997

What is coalesce in sql server?

1099

What is the sql server 2000 version number?

1145

Explain primary key, foreign key and unique key?

1022

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

999

Can two tables share the same primary key?

981

What is spid in sql server profiler?

1167

How do I delete a sql server database?

1097

Can I run multiple instances of sql server 2000 at the same time on one computer?

1119

What are the disadvantages of indexes?

1152

Explain the dbcc pintable command when would you use it?

966

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