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 15998

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

Adea Solutions,

3 16276

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

1 5501




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

2 9074

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

1 6046

Can XML be used to access data?

2 1812

What is referential integrity and how is it achieved?

Adea Solutions,

1 8283

What is indexing?

AOL,

919




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

2 11563

Difference between server.transfer and server.execute method?

2 9762

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

TCS, TPK,

2 8528

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

ASD Lab,

2 6183

What is a function? Give some example?

3 7370

What is a stored procedure?

3 3163

Difference between Function and Procedure-in general?

6 10810


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

781


How to trouble shoot if unable to connect SQL Server

767


Call by value and call by reference in procedure and function, with NOCOPY.

150


what is checksum in sql server.........???

392


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1618






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?

864


how to do partition in sqlserver

1305


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

811


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4769


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

710


Delete duplicate rows without using rowid.

191


New concepts of sql server 2005 use in your project.

1235


How we create SQL Server 2005 Reporting Services ? Give me Sample

920


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

313


What is the difference between NOROW and LOCKROW?

1293