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

AOL,

860




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?

TCS, TPK,

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

720


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

752


what is isolation level at dead lock?

968


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

1351


query processing

956






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

797


how can u get last observation in an unknown dataset ?

1083


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.

2628


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.

728


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

834


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

848


how to overcome kernel isssues

436


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

812


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?

817


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

671