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?


2 16255

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

Adea Solutions,

3 16374

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

1 5556

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

2 9192

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

1 6110

Can XML be used to access data?

2 1875

What is referential integrity and how is it achieved?

Adea Solutions,

1 8395

What is indexing?



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

2 11680

Difference between server.transfer and server.execute method?

2 9812

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


2 8677

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

ASD Lab,

2 6258

What is a function? Give some example?

3 7442

What is a stored procedure?

3 3212

Difference between Function and Procedure-in general?

6 10879

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do


Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.


Tell about MOM Tool(Microsoft Operator Manager)?


What is RMS migrations?


application server is slow what may be the problem


How do you Implement SSIS Packages in your Project?


Scalability, Availability, Integration with internet, etc.)?


Issues related in upgrading SQL Server 2000 to 2005 / 2008


Which is the best place or learning center for MS SQL?????In Bangladesh?????


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible


Working with TLogs


Why do you want to join software field as you have done your BE in Electronics?


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i


whats new about truncate in sql server 2008?