Question : We have an OrderLines table with columns: Quantity int not null QtyCancelled int not null QtyBackorder int not […]
Is there any specific differences on table level integrity check between DBCC CHECKDB and DBCC CHECKTABLE?
Question : I’ve faced with allocation error in one of our databases while running DBCC CHECKDB on it. It throws […]
What causes DBCC CHECKTABLE to return “session is in the kill state”?
Question : A scheduled job step ran DBCC CHECKTABLE on a table but returned the following error: Cannot continue the […]
Overhead associated with DBCC CHECKTABLE?
Question : Have a logshipped VLDB and don’t run DBCC CHECKDB on primary due to the long running periods of […]
DBCC CHECKTABLE taking 15+ minutes to run on an empty table
Question : I have a database where DBCC CHECKTABLE on a number of small or empty tables taking over 15 […]
Why does DBCC CHECKTABLE WITH TABLERESULTS only report Error 8990 on corrupt tables?
Question : I have a production VLDB that I’m using Paul Randal’s guidance on to spread DBCC CHECKDB workload over […]