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 16484

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

Adea Solutions,

3 16430

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

1 5620

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

2 9286

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

1 6203

Can XML be used to access data?

2 1928

What is referential integrity and how is it achieved?

Adea Solutions,

1 8535

What is indexing?



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

2 11787

Difference between server.transfer and server.execute method?

2 9865

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


2 8777

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

ASD Lab,

2 6394

What is a function? Give some example?

3 7491

What is a stored procedure?

3 3257

Difference between Function and Procedure-in general?

6 10929

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How can we call UDF(User Define Function) using C# code in ASP.net ?


can any body tell me how to know the password of current user in sql server


how to take backup bcp out for a column in table in sql server?


how can you attach more than 20 ldf files in sql server


Comment,Datatypes are unlimited


How you trouble shoot when any job fails


wat wil hapn if we give the both read and deny read permission to user?


Why we need to use secondry database file? though, we can do same work using primary database file also.


Any one plz send me SQL Server Developer/DBA resume for 4 years experience


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?


which backup strategy you are following at ur company


Issues related in upgrading SQL Server 2000 to 2005 / 2008


If user is owning any SQL Objects, can we drop that user


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do


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