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 19184

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

Adea Solutions,

3 18926

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

1 6880

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

2 10889

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

1 7429

Can XML be used to access data?

2 3376

What is referential integrity and how is it achieved?

Adea Solutions,

1 10258

What is indexing?

AOL,

1692

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

2 13574

Difference between server.transfer and server.execute method?

2 11252

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

TCS, TPK,

2 10858

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

ASD Lab,

2 8305

What is a function? Give some example?

3 9257

What is a stored procedure?

3 5206

Difference between Function and Procedure-in general?

6 13470


Un-Answered Questions { SQL Server }

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2310


Explain various On-Delete options in a DB table. Which is the default option?

1031


What happens on checkpoint?

697


Explain database normalization?

738


How to view existing indexes on an given table using sys.indexes?

712






Determine when an index is appropriate?

677


How can we remove orphan records from a table?

638


Explain triggers?

675


Explain having clause?

631


why would you call update statistics? : Sql server database administration

674


Do you know what are the restrictions that views have to follow?

732


How to get a list of columns in a view using the "sp_columns" stored procedure?

718


How to enforce security in sql server? : sql server security

720


How to use group functions in the select clause in ms sql server?

627


What is the filtered index?

694