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?

1078

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

991

Explain what are various ways to enhance the ssrs report?

1042

What is a linked server in sql server?

1073

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

990

Explain what are sparse columns?

988

Explain differentiate between a having clause and a where clause?

906

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

881

How many levels of sp nesting is possible?

1048

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

1023

What are various ways to enhance the ssrs report?

978

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

1024

Tell me can we use custom code in ssrs?

997

Can you explain different types of locks in sql server?

944

What is etl - extraction, transformation, and loading?

916

Un-Answered Questions { SQL Server }

What is SQL Azure Data sync?

121

What do you understand by mirroring?

993

List the different types of joins?

983

What is bit data type?

1034

What is difference between materialized view and view?

907

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1027

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1046

What encryption security is available in sql azure?

101

Define clusters?

1058

How can we solve concurrency problems?

1047

What is the template in sql?

973

How does stuff differ from the replace function?

1008

Do you know concepts and capabilities of sql server?

1056

How to enable/disable indexes?

1062

Do you know what is blocking?

948

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