What is difference between rownum and rowid?
No Answer is Posted For this Question
Be the First to Post Answer
Explain SELF JOIN ?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What are the limitation of the Online Index Rebuild Operation?
What are the events recorded in a transaction log?
what are the advanced features in sql 2008?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
what are the new features introduced in sql server 2000? : Sql server database administration
What is the disadvantages of index?
What are the two modes of authentication in sql server?
what are default? Is there a column to which a default cant be bound?
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform
Why would you call update statistics?