Checksums

  • Paul Randal

    One Orange Chip

    Points: 29438

    Comments posted to this topic are about the item Checksums

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

  • Joy Smith San

    SSC-Insane

    Points: 24877

    Very good question. I gave a wrong answer. This question made me realise that, I need to focus more on this topic.

  • This was removed by the editor as SPAM

  • SQLRNNR

    SSC Guru

    Points: 281210

    Thanks Paul. Excellent question. I learned quite a bit about checksums for this question (most of it coming from your blog).

    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

  • SQLWinther

    SSCertifiable

    Points: 5886

    Thanks for an excellent question.

    /Håkan Winther
    MCITP:Database Developer 2008
    MCTS: SQL Server 2008, Implementation and Maintenance
    MCSE: Data Platform

  • Kelsey Thornton

    SSCrazy

    Points: 2157

    Nice QOTD

    Kelsey Thornton
    MBCS CITP

  • Christian Buettner-167247

    SSChampion

    Points: 13729

    I knew I was gonna miss this QOTD as soon as I read the name "Paul Randal" 😀

    Best Regards,

    Chris Büttner

  • Tom Garth

    SSCertifiable

    Points: 6173

    Its a topic I covered a couple weeks back while studying for the exam. It made my day to get it right.

    Thanks.

    Tom Garth
    Vertical Solutions[/url]

    "There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
  • sjimmo

    SSChampion

    Points: 11139

    Great QOD Paul. Really had me digging deep, and ALMOST got me:-)

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

  • Dave62

    SSCertifiable

    Points: 6446

    Nice question!

    I spent 5 minutes reading here:

    http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/29/Enabling-CHECKSUM-in-SQL2005.aspx

    It does not give the specific answer but I was able to deduce the correct answer from the information given.

    An excellent balance of difficulty without controversy. Well done!

    Dave

  • John McC

    Hall of Fame

    Points: 3410

    Good job I've got Paul's blog bookmarked 😉

    -------------------------------------------------------------------------
    Normal chaos will be resumed as soon as possible. :crazy:

  • Trey Staker

    SSCarpal Tunnel

    Points: 4736

    I really liked this question, I had to really think about it. 😀

    ---------------------------------------------------------------------
    Use Full Links:
    KB Article from Microsoft on how to ask a question on a Forum

  • KevinC.

    SSCommitted

    Points: 1570

    Excellent QotD. Thanks Paul.

    --

    Kevin C.

  • Ray K

    SSC-Dedicated

    Points: 31078

    Argh! I went through the answers and thought, "this sounds like the best one." For some reason, "none of the above" didn't register!

    Oh well. C'est la vie.

    +--------------------------------------------------------------------------------------+
    Check out my blog at https://pianorayk.wordpress.com/

  • Peter Trast

    SSCarpal Tunnel

    Points: 4332

    Got me! I (improperly) assumed WITH CHECKSUM and chose the backup answer... silly me... thanks AGAIN Paul!

    --The devil IS in the details... get out of there pointy ears, I'm trying to work here...--

    Peter Trast
    Microsoft Certified ...(insert many literal strings here)
    Microsoft Design Architect with Alexander Open Systems

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

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