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

Do you know what is sql service broker?

1167

Explain what is the function of sql server agent windows service?

1044

Explain what are various ways to enhance the ssrs report?

1100

What is a linked server in sql server?

1140

Do you know what is a trace frag? Where do we use it?

1046

Explain what are sparse columns?

1071

Explain differentiate between a having clause and a where clause?

956

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

951

How many levels of sp nesting is possible?

1104

Tell me what is de-normalization and what are some of the examples of it?

1100

What are various ways to enhance the ssrs report?

1037

Do you know what are the ways available in sql server to execute sql statements?

1082

Tell me can we use custom code in ssrs?

1059

Can you explain different types of locks in sql server?

999

What is etl - extraction, transformation, and loading?

963

Un-Answered Questions { SQL Server }

What is it unwise to create wide clustered index keys?

1049

Explain timestamp datatype?

1023

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

1036

How to join two tables in a single query in ms sql server?

1062

Can coalesce return null?

1072

What is user-defined scalar function?

1010

What is correlated subquery in sql server?

1127

How to move database physical files in ms sql server?

1100

What is oltp (online transaction processing)?

1061

What is the purpose of object explorer and its features? : sql server management studio

1278

What different steps will a sql server developer take to secure sql server?

1042

Explain what is the main purpose of having conversation group?

994

What do you mean by tablesample?

1127

What is set nocount on and what is set nocount off?

999

What are the advantages of policy management?

1047

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