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 15277

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

Adea Solutions,

3 16084

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

1 5384

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

2 8831

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

1 5879

Can XML be used to access data?

2 1702

What is referential integrity and how is it achieved?

Adea Solutions,

1 7954

What is indexing?



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

2 11211

Difference between server.transfer and server.execute method?

2 9607

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


2 8256

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

ASD Lab,

2 5939

What is a function? Give some example?

3 7195

What is a stored procedure?

3 3015

Difference between Function and Procedure-in general?

6 10628

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

what is isolation level at dead lock?


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?


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


how to do partition in sqlserver


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you


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


tell me the disaster recovery plan


If a stored procedure is taking a table data type, how it looks?


How retrieve field names from the table in SQL through JAVA code?


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


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


How do use Having,Group by,Group function in SQL?


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?


Issues related in upgrading SQL Server 2000 to 2005 / 2008


how can u get last observation in an unknown dataset ?