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

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

HCL,

2 19962

What are cursors? Name four types of cursors and when each one would be applied?

Adea Solutions,

3 20302

How do you use DBCC statements to monitor various aspects of a SQL server installation?

1 7449

How do you load large data to the SQL server database?

2 11680

How do you check the performance of a query and how do you optimize it?

1 7919

Can XML be used to access data?

2 4020

What is referential integrity and how is it achieved?

Adea Solutions,

1 10861

What is indexing?

AOL,

2119

What is normalization and what are the different forms of normalizations?

2 14333

Difference between server.transfer and server.execute method?

2 12023

What is better - 2nd Normal form or 3rd normal form? Why?

TCS, TPK,

2 11716

Can we rewrite subqueries into simple select statements or with joins? Example?

ASD Lab,

2 9287

What is a function? Give some example?

3 10161

What is a stored procedure?

3 6308

Difference between Function and Procedure-in general?

6 14974

Un-Answered Questions { SQL Server }

How to send a ssrs report from ssis?

176

What is primary key, unique key, and foreign key?

976

What are the properties of the transaction?

1006

Explain a join?

1067

How to create a large table with random data for index testing in ms sql server?

1031

What are the aggregate and scalar functions?

1068

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2009

Explain the microsoft sql server delete command? : SQL Server Architecture

1083

what are the Prerequisites for Replication?

11352

Can you index views?

895

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

945

What are the advantages of sql stored procedure?

1074

What types of replication are supported in sql server?

1063

What command must you use to include the not null constraint after a table has already been created?

1146

What is an indice?

1037

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