Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What are views in ms sql server?
What are the steps to follow to configure SQL*Net?
What is update_statistics command?
What is history table in sql server?
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
How to find table changes in sql server?
what is Full Text Search ?
How to create a user to access a database in ms sql server using "create user" statements?
How to check status of stored procedure in sql server?
What is 'write-ahead log' in sql server 2000 ?
How to enable/disable indexes?
define and explain the differences between clustered and non-clustered indexes.