Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between dbcc checkstorage and other
dbcc commands
- 2 Answers
- 12006 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
Tempdb is full. How would you clear it?
Is sybase open source?
What is server replication?
Can I partition any table in sybase ?
Explain table partitioning in sybase.
Can you create your own sps for system wise?
How to divide by zero and nulls in sybase?
What is the default size of master database in sybase?
Explain timestemp datatype in sybase.
What is asa in sybase?
How do I tell which tables have identities in sybase?
How do I create a partitioned table that spans multiple devices in sybase?
Explain about the sybase group?
How do I set ts role in order to run certain dbccs?
A single operation is failing to escalate?
