DBCC Meaning

  • Comments posted to this topic are about the item DBCC Meaning

  • 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”

  • 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.

  • 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.

  • 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.

  • 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 .

     

  • 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

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

  • 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