Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between dbcc checkstorage and other
dbcc commands
- 2 Answers
- 11735 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
What causes re-resolution of a stored procedure in sybase?
What is asa in sybase?
How does partition assignment relate to transactions in sybase?
What mandatory options are required for bcp command utility?
What do you mean by asa in sybase?
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
Are you doing the updates from within a cursor?
You want to delete a table in sybase. How would you do it?
There is no space in file system and you need to take a back up. What will you do?
What is the stored procedure to view current lock and processes respectively?
What do you mean by deferred update in sybase?
Does table partitioning require user-defined segments in sybase?
What will you do if a replication thread goes down?
Is sybase owned by sap?
Differences between clustered and non-clustered in sybase?
