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 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?

AOL,

945




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?

TCS, TPK,

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

927


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

698


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.

700


Tell about MOM Tool(Microsoft Operator Manager)?

719


What is RMS migrations?

989






application server is slow what may be the problem

1114


How do you Implement SSIS Packages in your Project?

869


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

1685


Issues related in upgrading SQL Server 2000 to 2005 / 2008

820


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

910


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

1148


Working with TLogs

717


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

1054


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

866


whats new about truncate in sql server 2008?

1345