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 18870

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

Adea Solutions,

3 18610

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

1 6708

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

2 10621

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

1 7233

Can XML be used to access data?

2 3117

What is referential integrity and how is it achieved?

Adea Solutions,

1 10046

What is indexing?

AOL,

1580

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

2 13313

Difference between server.transfer and server.execute method?

2 10987

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

TCS, TPK,

2 10513

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

ASD Lab,

2 8001

What is a function? Give some example?

3 8989

What is a stored procedure?

3 4942

Difference between Function and Procedure-in general?

6 13048


Un-Answered Questions { SQL Server }

What the different components in replication and what is their use?

496


Explain view in sql server?

598


How will you optimize a stored procedure optimization?

486


How to copy data from one table to another table?

524


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

513






How do I know if localdb is running?

489


How to list all stored procedures in the current database using ms sql server?

612


how many type of indexing in database?

557


What is the default fill factor value?

556


What is the use of floor function in sql server?

515


Tell me what are cursors and when they are useful?

482


Define cross join in sql server joins?

572


Differentiate between delete and truncate.

557


Explain the collation?

595


how would you store your query in an SSRS report or a Database server?

116