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 are pessimistic lock and optimistic lock?

1076

What is table constraint?

992

What is sqlcmd?

1050

Explain activity monitors

1076

What is after dml trigger?

1016

What is dirty read?

1080

What is temporary table in sql server? Why we use temp table?

952

what is spatial nonclustered index

992

Explain system functions or built-in functions? What are different types of system functions?

979

What is standby servers? Explain types of standby servers.

995

What is self contained sub query?

1057

What is a scheduled job or what is a scheduled task?

952

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

969

What is clustered index

1008

Disadvantages of the indexes?

1125

Un-Answered Questions { SQL Server }

What is the recursive stored procedure in sql server?

1021

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1048

When we should use @@error?

966

What is the difference between commit and rollback?

942

Explain about Joins?

990

How to receive output values from stored procedures?

1146

Explain the concept of recursive stored procedure.

958

What is sql server database?

1009

How many databases instances are there in sql server 2000?

1098

What happens if null values are involved in comparison operations?

977

Give a example to search fr a string in all stored procedure in sql server.

986

What's new in sql management studio for sql server? : sql server management studio

1065

Define outer join in sql server joins?

934

What is bcp? When does it used?

976

Explain about local stored procedure?

972

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