What are the different types of locks in the database?
What are the advantages dts has over bcp?
Explain filtered indexes?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What the different components in replication and what is their use?
Get Current System Date Time
Which are the important points to note when multilanguage data is stored in a table?
Can we use where clause in union?
Why do we use stored procedures in sql server?
What is a trigger what are the advantages of trigger?
Do you know the policy based administration feature of sql server 2008?
What is the difference between a primary key and a unique key? Are they the same?
What are user defined functions in ms sql server?