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

Can you explain what is sql server english query?

996

Do you know what is blocking?

960

What is use of except clause? How it differs from not in clause?

1020

What is triggers in ms sql server?

1119

Tell me what is a linked server?

1040

Can you explain what is the use of custom fields in report?

1062

Do you know what is sql injection?

999

What is failover clustering overview?

1090

How ssrs maintain security?

1087

What is buffer cash and log cache in sql server?

1125

Tell me the phases a transaction has to undergo?

963

Tell me what is the stuff and how does it differ from the replace function?

981

Explain what is sql server english query?

1052

Explain acid?

1084

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

976

Un-Answered Questions { SQL Server }

How to loop through the result set with @@fetch_status?

1349

Do you know what is fill factor and pad index?

1004

What are user-defined functions (udfs) in sql server?

990

What is a sql join?

1022

List out different types of normalizations in sql server and explain each of them?

930

Is it possible to replicate data from sql server to oracle? : sql server replication

1096

What are the advantages of policy management?

997

What is attribute relationships, why we need it? : sql server analysis services, ssas

967

How to create “dependant” parameter “make, model, year”

131

What is difference between index and primary key?

1100

Explain timestamp datatype?

974

Explain go command in sql server?

1040

What is mscorsvw.exe - process - microsoft .net framework ngen?

955

what are constraints? : Sql server database administration

1057

Explain transaction server explicit transaction?

933

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