Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Nakul Vachhrajani is a Technical Specialist & Systems development professional with iGATE. He holds a MCTS (SQL Server 2008: Implementation & Maintenance)
Browse by Tags · View All
#SQLServer 305
SQL Server 304
Administration 252
DBA 241
T-SQL 234
#TSQL 232
Development 226
Tips 216
Guidance 148
Best Practices 119

Archive · View All
April 2011 14
March 2012 11
December 2011 11
March 2011 11
December 2012 10
October 2011 10
January 2011 10
September 2013 9
January 2013 9
November 2012 9

#0218 - SQL Server-Get Help for DBCC commands using DBCC HELP

Dec 3 2012 12:00AM by Nakul Vachhrajani   

Database Consistency Check, abbreviated as DBCC commands are perhaps the best friends of any DBA. Following are some of the most common DBCC commands that can be found in almost all the script banks:

  1. CHECKDB
  2. CHECKIDENT
  3. CHECKALLOC
  4. CHECKTABLE
  5. TRACEON
  6. TRACEOFF
  7. SHOWCONTIG

I am poor at remembering the syntax of these commands and therefore take occasional help of the SQL Server Books On Line (BOL) to get a hint on the parameters that a particular DBCC command uses. However, there are cases when one is working directly off the development or quality assurance servers, which generally do not have BOL installed. In such cases, the easiest way to obtain help for the DBCC commands is to use another, obvious DBCC command – DBCC HELP!

Here’s a quick example:

DBCC HELP ('CHECKIDENT')
GO

Running the above returns the following text, which is essentially the syntax help for DBCC CHECKIDENT:

dbcc CHECKIDENT
(
    'table_name'
    [ , { NORESEED
        | { RESEED [ , new_reseed_value ] }
    } ]
)
    [ WITH NO_INFOMSGS ]

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

So the next time you are stuck with the syntax for a DBCC command, ask DBCC for HELP before reaching out for the BOL.

(The catch: To the best of my knowledge DBCC HELP only works for the documented DBCC commands, similar to the BOL.)

Until we meet next time,

Be courteous. Drive responsibly.

Tags: #SQLServer, SQL Server, Administration, Tips, DBA, T-SQL, #TSQL


Nakul Vachhrajani
4 · 36% · 11645
5
 
0
Lifesaver
 
 
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"#0218 - SQL Server-Get Help for DBCC commands using DBCC HELP" rated 5 out of 5 by 5 readers
#0218 - SQL Server-Get Help for DBCC commands using DBCC HELP , 5.0 out of 5 based on 5 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]