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 20298

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

1 7447

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

2 11678

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,

2117

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

2 14333

Difference between server.transfer and server.execute method?

2 12019

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

TCS, TPK,

2 11715

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

ASD Lab,

2 9285

What is a function? Give some example?

3 10156

What is a stored procedure?

3 6307

Difference between Function and Procedure-in general?

6 14967

Un-Answered Questions { SQL Server }

What program is used to store the data source file?

961

How to get the definition of a user defined function back?

1044

How can sql server instances be hidden?

967

What number aggregate functions are accessible there in sql?

1071

What is sql server locking?

992

What is merge?

1018

Which is better statement or preparedstatement?

924

How to convert binary strings into integers in ms sql server?

1027

How to get a list of all tables with "sys.tables" view in ms sql server?

1035

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1263

What is executereader?

952

How many types of keys are there?

1030

What is sql sandbox in sql server?

1222

How to download and install microsoft .net framework version 2.0?

1139

Are connections to sql server encrypted?

1003

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