DBCC Meaning

Question

DBCC Meaning

Kendra Little

SSC Enthusiast

Points: 147
More actions
February 17, 2020 at 12:00 am

#3725347

Comments posted to this topic are about the item DBCC Meaning

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

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

Stewart "Arturius" Campbell SSC Guru Points: 72634 More actions · Answer 1

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 SSCrazy Eights Points: 8524 More actions · Answer 2

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: 2772 More actions · Answer 3

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: 258 More actions · Answer 4

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: 9 More actions · Answer 5

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: 31882 More actions · Answer 6

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 Right there with Babe Points: 738 More actions · Answer 7

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

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 8

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