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
- 4285 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
Where do you find the default index fill factor and how to change it? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
what do you understand by fine-grained auditing?
how can you process messages in order asynchronously?
How do you open a cluster administrator? : sql server DBA
Why would you call update statistics? : sql server DBA
what are the performance views in an oracle rac environment?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
internal architecture
What is a correlated sub-query? : sql server DBA
How would you extract DDL of a table without using a GUI tool?
