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

AOL,

981




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?

TCS, TPK,

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 ?

4823


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

982


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

924


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

899


Comment,Datatypes are unlimited

989






How you trouble shoot when any job fails

774


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

1030


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

4373


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

1559


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?

1116


which backup strategy you are following at ur company

1061


Issues related in upgrading SQL Server 2000 to 2005 / 2008

855


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

920


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

1430


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

1182