Do you know what is difference between index seek vs. Index scan?

901

Distinguish between nested subquery and correlated subquery?

975

Can I save my report as html, excel or word? : sql server management studio

908

what are isolation levels? : Sql server database administration

913

How to start and end transact-sql statements?

971

What is code near application topology?

271

What is role playing dimension with two examples? : sql server analysis services, ssas

954

Describe how to use the linked server?

1066

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2323

What are the differences between user defined functions and stored procedures?

1007

What is a natural primary key?

952

What are the different types of locks in the database?

874

What is the purpose of the model database?

965

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

852

Where are sql server user names and passwords stored in sql server?

1018