Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 17585

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

Adea Solutions,

3 16978

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

1 5961

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

2 9728

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

1 6591

Can XML be used to access data?

2 2290

What is referential integrity and how is it achieved?

Adea Solutions,

1 9210

What is indexing?



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

2 12471

Difference between server.transfer and server.execute method?

2 10245

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


2 9358

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

ASD Lab,

2 6984

What is a function? Give some example?

3 7907

What is a stored procedure?

3 3779

Difference between Function and Procedure-in general?

6 11612

Un-Answered Questions { SQL Server }

What is BLOCK statements in SQL?


How will you know when statistics on a table are obsolete?


What are the tables in sql?


How can you hide the sql server instances?


What is temporal data type?


What is the purpose of object explorer and its features? : sql server management studio


Please illustrate physical database architecture? : SQL Server Architecture


i have made a project i n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?


What are the options which must be set to allow the usage of optimistic models?


when would you go for denormalization? : Sql server database administration


what changed between the previous version of sql server and the current version? : Sql server database administration


What are the types of dml?


What is sql sandbox in sql server?


New concepts of sql server 2005 use in your project.