Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / monal
IN SQL SERVER 2005 USING NON CLUSTERED INDEX WOULD BE BETTER.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What is the default port no on which sql server listens? : sql server DBA
who owns the operating system files created by the utl_file package?
how can you communicate with operating system files from oracle?
What are the steps you will take to improve performance of a poor performing query?
What authentication modes does sql server support? : sql server DBA
What is replication? : sql server DBA
what are the performance views in an oracle rac environment?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the operating modes in which database mirroring runs? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what is the use of ocr?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
