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?

1161

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

1041

Explain what are various ways to enhance the ssrs report?

1097

What is a linked server in sql server?

1131

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

1040

Explain what are sparse columns?

1066

Explain differentiate between a having clause and a where clause?

949

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

945

How many levels of sp nesting is possible?

1099

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

1098

What are various ways to enhance the ssrs report?

1032

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?

1054

Can you explain different types of locks in sql server?

992

What is etl - extraction, transformation, and loading?

960

Un-Answered Questions { SQL Server }

Write a program using SQL queries to find a unique entry in a table.

1043

when would you go for denormalization? : Sql server database administration

911

What is trigger and different types of Triggers?

1199

What are the differences between lost updates and uncommitted dependencies?

1141

Explain the use of containers in ssis and also their types?

1017

What is an indexing strategy?

1066

What are different types of views?

985

Relational calculus is what type of language?

1091

Why Master database is required?

1185

What is @@rowcount in sql?

1056

What is the difference between stored procedure and user defined functions?

1236

What is a dataset and what are the different types of datasets?

141

What is the difference between implicit and explicit transaction?

1052

What is query parameter in ssrs?

167

You want to implement the one-to-one relationship while designing tables. How would you do it?

1013

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