Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between dbcc checkstorage and other
dbcc commands
- 2 Answers
- 11901 Views
- I also Faced
- E-Mail Answers
Answer Posted / sucheta khattri
dbcc checkstorage is different from the other dbcc commands
in that it requires:
1.)The dbccdb database to store configuration information
and the results of checks made on the target database.
2.)At least two workspaces to use during the check operation
3.)System and stored procedures to help you prepare your
system to use dbcc checkstorage and to generate reports on
the data stored in dbccdb.
4.)Unlike the other dbcc commands, the performance of dbcc
checkstorage does not depend heavily on data placement.
Therefore, performance is consistent for each session, even
if the data placement changes between sessions.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain defncopy and it's usage?
How do I check if log truncation is blocked in sybase?
How to remove row affected and dashes?
What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?
How do I exclude a column in sybase?
Can I partition any table in sybase ?
What is table partitioning in sybase?
Explain update statistics.
Explain 'forcing an index' concept.
Differences between clustered and non-clustered in sybase?
What is the use of 'with check' option in views?
Does sybase support row level locking?
What is the default size of master database in sybase?
What is the equivalent of oracle/db2 coalesce function in sybase?
How to divide by zero and nulls in sybase?
