DBCC CHECKDB

Question

DBCC CHECKDB

baabhu

SSCertifiable

Points: 6205
More actions
May 16, 2012 at 9:30 pm

#261154

Comments posted to this topic are about the item DBCC CHECKDB
May 17, 2012 at 7:20 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 24 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Hardy21 SSCrazy Eights Points: 9708 More actions · Answer 2

Nice question. I have to read BOL to identify correct answer...

Thanks

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 3

Nice Question - made me read up in BOL and actually learn something useful.

Thanks

Gazareth One Orange Chip Points: 27737 More actions · Answer 4

Nice one. Got it by a process of elimination rather than actual knowing the incorrect one!

Ken SSCoach Points: 17191 More actions · Answer 5

Ken

SSCoach

Points: 17191

May 17, 2012 at 6:22 am

#1488944

Nice question, thanks.

TomThomson SSC Guru Points: 104773 More actions · Answer 6

Nice question.

Surprising that fewer than half of people got it right so far (140 out of 306) as the three true options are rather obviously true. But at least the correct answer is the most popular one.

Tom

mtassin SSC-Insane Points: 23099 More actions · Answer 7

Nice easy question.... I misread it....

I read the BLOB one as that it does check BLOBs.... and went... wait I think it does all of these...

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

Dana Medley SSCertifiable Points: 6764 More actions · Answer 8

Great question, thanks! I'm with Gazareth on this one; it was just process of elimination for me.

Everything is awesome!

sknox SSChampion Points: 12388 More actions · Answer 9

I take issue with this option:

DBCC CHECKDB can repair corruption if you specify the REPAIR_ALLOW_DATA_LOSS option.

This is not always true (it depends on exactly where the corruption is), and when it is, it is true only for very weak definitions of "repair", as the end result is not your database as it was before the corruption occurred but instead a possibly valid but most likely inconsistent database file.

EDIT: BBCode/IFCode, NOT HTML. :blush:

Thomas Abraham SSChampion Points: 10761 More actions · Answer 10

Thanks for the question. Almost got it wrong due to speed reading wording about link-level consistency of BLOBS in the FILE SYSTEM. As others have mentioned, I knew I had to recheck that, due to eliminating the other three answers.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Thomas Abraham SSChampion Points: 10761 More actions · Answer 11

sknox (5/17/2012)
I take issue with this option:
DBCC CHECKDB can repair corruption if you specify the REPAIR_ALLOW_DATA_LOSS option.
This is not always true (it depends on exactly where the corruption is), and when it is, it is true only for very weak definitions of "repair", as the end result is not your database as it was before the corruption occurred but instead a possibly valid but most likely inconsistent database file.
EDIT: BBCode/IFCode, NOT HTML. :blush:

From the BOL ref: "These repairs can cause some data loss."

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 12

OzYbOi d(-_-)b

SSCarpal Tunnel

Points: 4054

May 17, 2012 at 8:04 am

#1489037

good questions - cheers

Andre Ranieri SSCrazy Points: 2819 More actions · Answer 13

Followup question: What class of command is DBCC CHECKDB ? It doesn't seem to fall into the category of DML, DDL, DCL or TCL.

Thoughts?

Andre