Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between dbcc checkstorage and other
dbcc commands
- 2 Answers
- 12028 Views
- I also Faced
- E-Mail Answers
Answer Posted / jayakumar
1.dbcc checkstorage runs checks against the database on
disk. If a corruption is only in memory, dbcc checkstorage
may not detect the corruption. To ensure consistency
between two dbcc checkstorage runs, run checkpoint before
running dbcc checkstorage. However, doing so can turn a
transient memory corruption into corruption on disk.
2.dbcc checkstorage checks the entire database, including
unused pages, so execution time is relative to database
size. Therefore, when you use dbcc checkstorage, there is
not a large difference between checking a database that is
nearly empty and checking one that is nearly full, as there
is with the other dbcc commands.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Are you doing the updates from within a cursor?
What is the relationship between jdbc and sybase?
What are the important features of sybase?
You need to remove the affected rows and dashes. How would you do that?
How do I run multiple versions of sybase on the same server?
Explain about the sybase group?
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 pipe the output of isql to a file in sybase?
How to connect to sybase database from linux?
When are stored procedures compiled in sybase?
Can you create your own sps for system wise?
What is open client in sybase?
What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?
What is sybase ?
What causes re-resolution of a stored procedure in sybase?
