what is the difference between dbcc checkstorage and other
dbcc commands
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
How do I configure identities in sybase?
How does partition assignment relate to transactions in sybase?
Explain locking. List its types.
Explain defncopy and it's usage?
Explain about the sybase group?
what is update statistics in sybase?
How to implement if-then-else in a select clause in sybase?
You need to multiply all values of a single column. How would you do that?
What is my identity burn factor vulnerability right now in sybase?
What is sybase? What are its important features?
Is sybase relational database?
What is the equivalent of oracle/db2 coalesce function in sybase?
Is sybase sql?
Why not max out all my columns sybase?
What is sybase ?