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 20064

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

Adea Solutions,

3 20466

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

1 7513

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

2 11783

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

1 7990

Can XML be used to access data?

2 4126

What is referential integrity and how is it achieved?

Adea Solutions,

1 10959

What is indexing?

AOL,

2211

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

2 14472

Difference between server.transfer and server.execute method?

2 12131

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

TCS, TPK,

2 11857

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

ASD Lab,

2 9409

What is a function? Give some example?

3 10306

What is a stored procedure?

3 6454

Difference between Function and Procedure-in general?

6 15195

Un-Answered Questions { SQL Server }

How do I start sql server?

1030

Working with TLogs

1900

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

1090

Does partitioning help performance?

997

What are trace flags and mention a few common trace flags used with sql server?

1144

Can we use where and having clause together?

1106

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

1321

What is a partitioned view?

1059

What is constraints and its types?

1001

What do you think of this implementation? Can this be implemented better?

1002

What is side by side migration in sql server?

1176

Define cross join in sql server joins?

1080

What is a trigger? Why we need it?

1062

Explain contrast amongst grouped and non-bunched records?

1096

Does a full backup include transaction log?

1052

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