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

1132

What is the difference between local and global temporary tables?

1138

What is bcp? When does it use?

943

What is the osql utility?

971

Explain the steps needed to create a scheduled job?

932

What are the types of joins in sql?

1126

What are orphan records?

932

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

1037

List all the types of user-defined functions?

1101

Why use “nolock” in sql server?

1058

Explain primary key in sql server?

1016

What is the filtered index?

1058

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

910

How will you go about resolving deadlocks?

970

What is the difference between osql and query analyzer?

996

Un-Answered Questions { SQL Server }

What is partition in sql server?

1037

How to make a remote connection in a database?

977

When you should use a low fill factor?

993

What is scalar user-defined function?

1101

What do you do in data exploration

993

How will you add a dimension to cube? : sql server analysis services, ssas

1086

What is extended stored procedures?

966

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1947

what is the difference between Tabular and Matrix report?

170

What is difference between rollback immediate and with no_wait during alter database?

1090

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

962

How to view existing indexes on an given table using sys.indexes?

1091

How to execute stored procedure in select statement sql server?

1061

How to list all field names in the result set using mssql_field_name()?

914

What is optimistic concurrency?

1038

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