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

Define master database?

1012

Explain transaction server auto commit?

1000

What are the essential components of sql server service broker?

981

Why do we use non clustered index?

1029

How to use the inserted and deleted pseudo tables?

927

Define full outer join?

905

Explain concepts of analysis services?

904

Explain where clause?

943

What are the advantages of sql stored procedure?

1033

Explain syntax for disabling triggers?

990

Define left outer join?

936

How dts is used to extract, transform and consolidate data?

1038

How to implement service broker?

944

What is fill factor and pad index?

971

What are constraints in microsoft sql server?

1060

Un-Answered Questions { SQL Server }

Relational calculus is what type of language?

983

Can you tell me some of the common replication dmv's and their use? : sql server replication

885

What is the difference between varchar and varchar types?

1020

How do I view a trc file?

910

Explain filtered indexes?

952

Explain log shipping and mention its advantages.

998

What is a rownum?

916

In case you have filters in your report, when filters will be applied in cached report instance?

107

When would you use sql joins?

922

How to change a login name in ms sql server?

1039

Why main is user defined function?

965

What are the requirements to use odbc connections in php scripts?

1082

What is normalization and denormalization in sql server?

963

How do I port a number to sql server?

1000

What is outer join in sql server joins?

1064

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