What is the syntax to execute the sys.dm_db_missing_index_details?
What is the difference between a function and a stored procedure?
how to use DTS package in 2000,2005,2008 in sql server
what is the difference between count(*) and count(1) ?
Wht is the difference between stored procedure and trigger
how to rename the table
What is the difference between local and global temporary tables?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What command is used to create a database in the sql server and how?
List the various tools available for performance tuning?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is sql server profiler trace data file?
Why do we use functions?