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

1187

What is the difference between local and global temporary tables?

1193

What is bcp? When does it use?

987

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?

985

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

1074

List all the types of user-defined functions?

1180

Why use “nolock” in sql server?

1133

Explain primary key in sql server?

1072

What is the filtered index?

1107

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

952

How will you go about resolving deadlocks?

1033

What is the difference between osql and query analyzer?

1046

Un-Answered Questions { SQL Server }

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

984

What are the disadvantages of primary key and foreign key in SQL?

1151

How exceptions can be handled in sql server programming?

1070

What do you mean by an execution plan?

1186

How to verify a user name with sqlcmd tool?

1118

Your table has a large character field there are queries that use this field in their search clause what should you do?

923

What is raid and what are different types of raid levels?

1191

Data table as parameter in sql server?

1102

What is the use of toad or sqldbx.?

1201

Write an sql query for deleting duplicate rows?

1036

How to get a list of columns in a view using the "sp_columns" stored procedure?

1086

What are page splits? : SQL Server Architecture

1037

How to create a ddl trigger using "create trigger" statements?

1185

Explain the Ways to improve the performance of a sql azure database?

What is meant by referential integrity?

1046

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