Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

DBCC CHECKDB Expand / Collapse
Author
Message
Posted Wednesday, July 31, 2013 3:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:59 AM
Points: 12,190, Visits: 9,140
Back to basics. Thanks for the question Steve.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1479354
Posted Wednesday, July 31, 2013 6:34 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:32 AM
Points: 1,884, Visits: 1,860
Nice question Steve!

So far, the most chosen wrong answer is: CHECKINTEGRITY.

Which, of course is not a valid DBCC check.
Post #1479436
Posted Wednesday, July 31, 2013 7:28 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 3:13 PM
Points: 2,409, Visits: 3,435
Dave62 (7/31/2013)
Nice question Steve!

So far, the most chosen wrong answer is: CHECKINTEGRITY.

Which, of course is not a valid DBCC check.


No it's not, but, it sounds really good for one. A nice red herring thrown in there by Steve.

However, there is an SSIS task named Check Database Integrity.
Post #1479476
Posted Wednesday, July 31, 2013 9:22 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 4:56 PM
Points: 8,271, Visits: 8,717
It's a good question.

It's a bit shocking to see that so far out of just over 600 people about 55 people picked the non-existent and utterly implausible DBCC CHECKCACHE, and about 175 picked the equally non-existent although less implausible sounding DBCC CHECKFILEGROUP; and it seems amazing that about 120 people thought that DBCC CHECKIDENT was something that DBCC CHECKDB would do. So I hope that people will learn from this question.


Tom
Post #1479540
Posted Wednesday, July 31, 2013 10:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, March 10, 2014 5:44 PM
Points: 2,225, Visits: 1,258
L' Eomot Inversé (7/31/2013)
It's a good question.

It's a bit shocking to see that so far out of just over 600 people about 55 people picked the non-existent and utterly implausible DBCC CHECKCACHE, and about 175 picked the equally non-existent although less implausible sounding DBCC CHECKFILEGROUP; and it seems amazing that about 120 people thought that DBCC CHECKIDENT was something that DBCC CHECKDB would do. So I hope that people will learn from this question.


Tom, I was looking for DBCC ATTITUDE to see how I felt about the question but could not find it in the list.


Not all gray hairs are Dinosaurs!
Post #1479579
Posted Wednesday, July 31, 2013 10:49 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 2:43 AM
Points: 41,517, Visits: 34,434
L' Eomot Inversé (7/31/2013)
and about 175 picked the equally non-existent although less implausible sounding DBCC CHECKFILEGROUP;


http://msdn.microsoft.com/en-us/library/ms187332.aspx

DBCC CHECKFILEGROUP (Transact-SQL)

Checks the allocation and structural integrity of all tables and indexed views in the specified filegroup of the current database.


Although, since CheckFilegroup wasn't an answer, I suspect you meant CheckIntegrity, which indeed does not exist.



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1479604
Posted Wednesday, July 31, 2013 11:13 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 11:58 PM
Points: 4,243, Visits: 3,317
Interesting question, interesting discussion. Thanks, Steve!
Post #1479611
Posted Wednesday, July 31, 2013 12:34 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 14, 2014 8:59 AM
Points: 1,670, Visits: 550
kapil_kk (7/31/2013)
Hugo Kornelis (7/31/2013)
karuppusamy.kk (7/31/2013)
Please clarify my following concern about this question..

Why not DBCC CHECKIDENT?

The short and simple answer: because Microsoft didn't build DBCC CHECKDB to include CHECKIDENT.

The longer and more useful answer: DBCC CHECKDB is intended to test the integrity of the database. The errors it finds are the errors that can cause the database to go corrupt. If there are no corruptions in the database, DBCC CHECKDB will do nothing. If there are errors, if may attempt to repair them with as little side effects as possible.
Contrast that the DBCC CHECKIDENT. This doesn't test for corruption; it tests for specific situations in user tables that may be a sign of inconssitencies, but definitely not of corruption. If DBCC CHECKIDENT "repairs" issues it finds, it will have a side effect on the user data (i.e. it affects identity values to be assigned in the future).

Bottom line - DBCC CHECKIDENT is too different from the intended use of DBCC CHECKDB to be included in it.

+1


great explanation..
Post #1479642
Posted Wednesday, July 31, 2013 4:26 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 4:56 PM
Points: 8,271, Visits: 8,717
GilaMonster (7/31/2013)
L' Eomot Inversé (7/31/2013)
and about 175 picked the equally non-existent although less implausible sounding DBCC CHECKFILEGROUP;


http://msdn.microsoft.com/en-us/library/ms187332.aspx

DBCC CHECKFILEGROUP (Transact-SQL)

Checks the allocation and structural integrity of all tables and indexed views in the specified filegroup of the current database.


Although, since CheckFilegroup wasn't an answer, I suspect you meant CheckIntegrity, which indeed does not exist.

Ouch! My fingers have betrayed me.
Yes, I did indeed mean CHECKINTEGRITY. But it's so hard to type non-existent commands, I'm almost surprised that my fingers managed CHECKCACHE without changing it to something like DBCCFREESESSIONCACHE.


Tom
Post #1479733
Posted Thursday, August 01, 2013 3:01 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 4:54 AM
Points: 647, Visits: 134
Thanks for the question and discussion...
Post #1479835
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse