Post reply

what does DBCC stand for?

  • May 4, 2005 at 11:18 am

    #164475

    what does DBCC stand for?

     

     

    what exactly happens when you shrink a database?

    thanks

  • May 4, 2005 at 11:35 am

    #556859

    DataBase Command Console

    Don't know what really happens in a shrink... I'll let someone else answer this one.

  • May 4, 2005 at 11:45 am

    #556864

    I always heard DataBase Consistency Checker, but BOL (DBCC statements, overview in the index) says:

    The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for Microsoft® SQL Server™ 2000. These statements check the physical and logical consistency of a database. Many DBCC statements can fix detected problems.

  • May 4, 2005 at 11:47 am

    #556865

    thanks

     

    why do you need to put it before a command in QA sometmes?

     

    example

    DBCC shrink...?

     

    what is a command console. sorry, I could not find dbcc in BOL

  • May 4, 2005 at 11:52 am

    #556869

    Look up 'DBCC statements, overview'  in Books Online. It gives you a good overview of the four classes of commands, etc.

    My interpretation is that it is a loose grouping of commands. some commands are DBCC commands, while others are not (excepting DDL, DML, DCL of course). Sometimes it isn't terrible obvious why.  

  • May 4, 2005 at 11:55 am

    #556871

    Sorry about the reversed Cs but I translated from french and looks like I was wrong.

  • May 4, 2005 at 12:05 pm

    #556877

    Different order, same meaning, Remi.

  • May 4, 2005 at 12:10 pm

    #556880

    A command console and a console command doesn't ring the same to my hear.. or does it?

  • May 4, 2005 at 4:53 pm

    #556949

    thanks you all you have been very helpul!

  • May 5, 2005 at 7:12 am

    #557046

    Actually, it used to mean Database Consistency Check, but in the SQL2K BOL, it looks like MS has changed the meaning.

    Even Microsoft's own knowledge base refers to the previous meaning is many places. Here is one such link:

    http://support.microsoft.com/?kbid=242953

    In the end, it doesn't really matter what it stands for, since everyone I know just refers to the letters (D B C C).

     

  • May 5, 2005 at 11:13 am

    #557175

    Just a thought, but it struck me that the difference between Consistency Check and Concole Command could possibly be significant in a certification exam.  I would really hate to miss a question on something so trivial.

    Myself, it'll always be the former, I harken back to the 4.21a days on top of LanMan/OS2.

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • May 6, 2005 at 4:45 am

    #557300

    DBCC stands for Database Consistency Checker .

    Database shrinking: When a database grows on its own it will create free spces. Also re-indexing the table  create free spaces in DB as if you want to re-index a table of size 100MB u require more than 100 MB space to recreate the table. What happened when u shrink the DB is that it will remove these free space and make the DB size smaller.It is better to avoid shrinking production DB unless and otherwise it is needed B'coz free space are needed in DB to perform maintenance function.So when u  shrink DB and do regular maintenance functions it has to create free space agin and resulting in waste of time and resources.

    Also do'nt shrink Db from EM.Shrink it manually using DBCC commands.U can shrink logfiles also.

    search following link for more

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_03_3vvp.asp

Viewing 12 posts - 1 through 11 (of 11 total)

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