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()?

1184

What is the difference between local and global temporary tables?

1190

What is bcp? When does it use?

986

What is the osql utility?

1033

Explain the steps needed to create a scheduled job?

976

What are the types of joins in sql?

1169

What are orphan records?

980

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

1073

List all the types of user-defined functions?

1177

Why use “nolock” in sql server?

1129

Explain primary key in sql server?

1070

What is the filtered index?

1104

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

949

How will you go about resolving deadlocks?

1029

What is the difference between osql and query analyzer?

1044

Un-Answered Questions { SQL Server }

Create and insert into temp table in sql server?

1077

Which tcp/ip port does the sql server run on? How can it be changed?

1098

How to write a query with a full outer join in ms sql server?

1147

How to enter unicode character string literals in ms sql server?

1112

what is dbcc? : Sql server database administration

1075

What is save transaction and save point?

1252

Do you know hot add cpu in sql server 2008?

1000

Explain security with sql azure?

186

What is acid db?

928

What are the types of normalization?

1071

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

944

Why use identity in sql server?

1163

What do you mean by tablesample?

1123

What is index in an assignment?

992

What is difference between temp table and cte?

1068

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