DBCC Meaning

  • Kendra Little

    SSC Enthusiast

    Points: 117

    Comments posted to this topic are about the item DBCC Meaning

  • Stewart "Arturius" Campbell

    SSC Guru

    Points: 71665

    Nice, easy question to start the week on, thanks Kendra

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • Rune Bivrin

    SSCertifiable

    Points: 7734

    Unless my memory is completely shot, back in version 1.1a (yes, I'm that old / started that young) it really stood for "Database Consistency Check". That was pretty much all it did, and it was quite necessary.

    There's been a lot of functionality added since then. Hence the current meaning of DBCC is more of a backronym.


    Just because you're right doesn't mean everybody else is wrong.

  • Data_God

    SSCrazy

    Points: 2733

    I'm of the same mindset ( and apparently the same age demographic 🙂 ) as that is what I distinctly remember this standing for so hence, I got this one wrong this morning so apparently you can still teach an old dog new tricks as I learned something this morning.

  • Ken.L.Wolff

    SSC Veteran

    Points: 246

    Agree on "Database Consistency Check", although I realize Microsoft subsequently decided to go with "Console Commands" instead.

    My understanding is the names dates back to the early 90s, when Microsoft and Sybase jointly developed the product, which continued until they split off circa 1993.  Until then, however, DBCC stood for "Database Consistency Check", and in fact still does on the Sybase ASE side.

  • ggeotsi

    Newbie

    Points: 8

    Microsoft states "The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server." emphasis added in https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-transact-sql?view=sql-server-ver15 . That statement shouldn't be construed as meeting the definition is Database Console Commands in my opinion.

    Historically DBCC = DataBase Consistancy Check(er). They are console commands per https://www.quora.com/What-are-DBCC-commands-in-SQL-server-and-what-are-they-used-for .

     

  • webrunner

    SSC-Dedicated

    Points: 30133

    Nice question, and it got me because I got it wrong. Although DBCC is often used for "checkdb," of course it has other commands such as OPENTRAN.

    Thanks for the Monday alertness check lol.

     

    -- webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • Stephen Grimshaw

    Say Hey Kid

    Points: 678

    It was in Sybase SQL Server before their flirtation with Microsoft.

  • Shayn Thomas

    SSCertifiable

    Points: 5575

    was convinced i knew the answer,

    clicked it

    Incorrect....

    Everyday is a school day 🙂

    Thanks

    Shayn

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

Viewing 9 posts - 1 through 9 (of 9 total)

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