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 15573

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

Adea Solutions,

3 16154

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

1 5430

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

2 8946

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

1 5932

Can XML be used to access data?

2 1742

What is referential integrity and how is it achieved?

Adea Solutions,

1 8104

What is indexing?



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

2 11346

Difference between server.transfer and server.execute method?

2 9669

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


2 8363

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

ASD Lab,

2 6032

What is a function? Give some example?

3 7260

What is a stored procedure?

3 3064

Difference between Function and Procedure-in general?

6 10687

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

Issues related in upgrading SQL Server 2000 to 2005 / 2008


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


what is isolation level at dead lock?


How to convert a table data in XML format in sql server?


query processing


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .


how can u get last observation in an unknown dataset ?


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.


role of sql sever 2005 in database rather than any other database


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


how to overcome kernel isssues


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


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?


sql database suspect We have a sql database that is showing as suspect. How can we recover?