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 is the difference between coalesce() & isnull()?

1123

What is the difference between local and global temporary tables?

1133

What is bcp? When does it use?

937

What is the osql utility?

950

Explain the steps needed to create a scheduled job?

918

What are the types of joins in sql?

1114

What are orphan records?

927

What have included columns when we talk about sql server indexing?

1029

List all the types of user-defined functions?

1088

Why use “nolock” in sql server?

1050

Explain primary key in sql server?

1013

What is the filtered index?

1046

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

895

How will you go about resolving deadlocks?

966

What is the difference between osql and query analyzer?

984

Un-Answered Questions { SQL Server }

Which table keeps information about stored procedures?

932

What is shared lock?

895

Why and when do stored procedure recompile?

974

How to use user defined functions in expressions?

1079

How do I find sql server instance name?

956

How can sql server instances be hidden? : sql server security

1136

What are the types of containers in ssis?

1161

How optimize sql query with multiple joins in sql server?

891

What is the default fill factor value?

1074

Does the order of columns in update statements matter?

910

Define self join?

1022

How to concatenate two binary strings together?

1114

What is update_statistics command?

1058

Explain optimistic and pessimistic concurrency?

986

What is a synonym for manipulation?

983

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