Interested to Buy Any Domain ? << Click Here >> for more details...
As a part of your job, what are the DBCC commands that you
commonly use for database maintenance?
- 1 Answers
- 4155 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / irimi
DBCC commands are most useful for performance and troubleshooting
PROCCACHE
SHOW_STATISTICS
TRACESTATUS
SHOWCONTIG
....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is asm?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What authentication modes does sql server support? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What the different topologies in which replication can be configured? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
how can you process messages in order asynchronously?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
what do you understand by flashback feature of oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is replication? : sql server DBA
What is transparent data encryption? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is the difference between clustered and non-clustered index? : sql server DBA
