Should Stored Procedure name start wi...

Should Stored Procedure name start with SP_ ??? - NO, user defined Stored Procedures, should not start with SP_, as ... http://ping.fm/cm9uh

List 10 difference between TRUNCATE &...

List 10 difference between TRUNCATE & DELETE statement in SQL Server? http://ping.fm/NmDGT

How to trace Deadlock in SQL Server ?...

How to trace Deadlock in SQL Server ? - What is a DEAD LOCK in SQL Server? When two or more transactions conflict in... http://ping.fm/6fdhj

Does Mirroring works with FileStream ...

Does Mirroring works with FileStream databases ? - NO, FILESTREAM doesn’t work with mirroring and database Sna... http://ping.fm/atHex

How to Monitor Database Mirroring, SQ...

How to Monitor Database Mirroring, SQL Server? - SQL Server Mirroring can be monitored SQL Server Management Studio ... http://ping.fm/9qKEw

What is SQL Server Feature Pack ? - W...

What is SQL Server Feature Pack ? - What is SQL Server Feature Pack ? The Feature Pack is a collection of standalone... http://ping.fm/zlNnn

How to perform SQL Server Mirroring M...

How to perform SQL Server Mirroring Manual Failover? - What is SQL Server Mirroring Failover ? When the principal se... http://ping.fm/AiEfQ

SQL Server 2008 R2 Cumulative Update ...

SQL Server 2008 R2 Cumulative Update 5 is released - Microsoft has released Cumulative Update 5 for SQL Server 2008 ... http://ping.fm/OwXNO

How to Setup Mirroring in SQL Server ...

How to Setup Mirroring in SQL Server ?(Screen Shots) - What is Mirroring in SQL Server ? Database mirroring is an al... http://ping.fm/MdRZ4

Database mirroring must be removed be...

Database mirroring must be removed before you drop SQL Server database http://ping.fm/AnEY9

Can we have Mirroring between Standar...

Can we have Mirroring between Standard and Enterprise editions ? http://ping.fm/PHEw9

How to get SQL Server Install Directo...

How to get SQL Server Install Directory / Error LOG via TSQL Statement ? http://ping.fm/kYhhw

How to Monitor SQL Server Log Shippin...

How to Monitor SQL Server Log Shipping? - LOG Shipping can be monitored SQL Server Management Studio or via TSQL Que... http://ping.fm/9zUdh

SQL Server DENALI HARDON DMVs and Fun...

SQL Server DENALI HARDON DMVs and Functions – SYSTEM View MAP http://ping.fm/a6In5

How to subscribe for SQL Server Cloud...

How to subscribe for SQL Server Cloud Services (SQL Server AZURE) FREELY ? http://ping.fm/NXOIc

What is SQL Server Crescent - Crescen...

What is SQL Server Crescent - Crescent, is a new Microsoft Business Intelligence tool (ad hoc reporting) which is pl... http://ping.fm/jzXhp

What is SQL Server Crescent - Crescen...

What is SQL Server Crescent - Crescent, is a new Microsoft Business Intelligence tool (ad hoc reporting) which is pl... http://ping.fm/Ht0jb

SQL Server Developer Tool "Juneau" ??...

SQL Server Developer Tool "Juneau" ??? - "Juneau" is going to be a high productivity development environment... http://ping.fm/vAQnC

Do you know what is Enhanced in Denal...

Do you know what is Enhanced in Denali for HIGH Availability ? http://ping.fm/RS0fL

Can We connect to SQL Server Denali u...

Can We connect to SQL Server Denali using 2008/2008 R2 SSMS ? http://ping.fm/r8LPg

How to use THROW command (Error Handl...

How to use THROW command (Error Handling) in SQL Server ? - What is THROW in SQL Server ?     &#... http://ping.fm/G7DvK

SQL Server Atlanta ? Proactive Monito...

SQL Server Atlanta – Proactive Monitoring - What is SQL Server Atlanta Project ? Microsoft Atlanta is a cloud-based,... http://ping.fm/x99L8

What are the Features of HADRON in SQ...

What are the Features of HADRON in SQL Server DENALI (2011) ? http://ping.fm/qbuDb

How to use OFFSET / FETCH option in ...

How to use OFFSET / FETCH option in SQL Server Order By Clause ? http://ping.fm/ui2nA

How to Restore Database in SQL Server...

How to Restore Database in SQL Server 2011 (Denali) from an older SQL Server version? http://ping.fm/khXR6

What is Sequence in SQL Server ? - SQ...

What is Sequence in SQL Server ? - SQL Server 2011, Denali, introduces a new alternative to identity columns. There ... http://ping.fm/LMCDU

What is the Difference between Identi...

What is the Difference between Identity and Sequence in SQL Server? http://ping.fm/FD4At

What are ate Discontinued Features an...

What are ate Discontinued Features and Functionalities, which will not be available, in SQL Server Denali (2011)? http://ping.fm/UWqWb

What is COLUMNSTORE Index in SQL Serv...

What is COLUMNSTORE Index in SQL Server? - What is COLUMNSTORE Index ? The SQL Server Denali (2011) launched a new t... http://ping.fm/BPsI0

Weekly Note : What is new in SQL Serv...

Weekly Note : What is new in SQL Server 2011 ? - Last week, I spent a lot of time on working with SQL Server Denali ... http://ping.fm/zUuZd

What is HADR in SQL Server ? - What i...

What is HADR in SQL Server ? - What is HADR in SQL Server ? "HADR" is a High-Availability and Disaster Recov... http://ping.fm/CzdQ3

How to Implement HADR (a high-availab...

How to Implement HADR (a high-availability and disaster recovery solution) in SQL Server ? Step by Step Guide with s... http://ping.fm/maZ5d

List of DMV and DMF availability acro...

List of DMV and DMF availability across all SQL Server Versions http://ping.fm/jzQwm

What are the new DMV and DMF are adde...

What are the new DMV and DMF are added in SQL Server 2011 ? - Here is the List of DMV's (Dynamic Management Views) a... http://ping.fm/CTZG8

VIDEO : SQL Server Contained Database...

VIDEO : SQL Server Contained Database - The Following Video covers What is Contained Database Why Contained Database... http://ping.fm/d5pAc

How to Create Server Roles in SQL Ser...

How to Create Server Roles in SQL Server ? - Can we create user defined Server Roles in SQL Server ? YES, we can cre... http://ping.fm/Zewnz

Compatibility Levels supported by SQL...

Compatibility Levels supported by SQL Server 2011 (Denali) - What are the compatibility Levels supported by SQL Serv... http://ping.fm/TJsjU

New Permissions added in SQL Server 2...

New Permissions added in SQL Server 2011 (Denali) - Following are the New Permissions added in SQL Server Denali. Al... http://ping.fm/B0wRh

How to use Managed Code (CLR) in SQL ...

How to use Managed Code (CLR) in SQL Server? Video - SQL CLR Integration allows you to create database objects that ... http://ping.fm/2rE4i

SQL Server 2011 (Denali) Certificatio...

SQL Server 2011 (Denali) Certification - Microsoft have announced that the next version of SQL Server Certifications... http://ping.fm/X4wkz

How to turn off Auto Recovery (AUTO S...

How to turn off Auto Recovery (AUTO Save) in SQL Server Management Studio? http://ping.fm/rvhcC

What is Relational Database Managemen...

What is Relational Database Management System - What is Relational Database Management System ? A relational databas... http://ping.fm/eWWov

Introduction to RDBMS : Day 1 : Chapt...

Introduction to RDBMS : Day 1 : Chapter 1 - In this session, you will learn to: Define a Database Management System ... http://ping.fm/x8v5c

What are T-SQL Enhancements done in S...

What are T-SQL Enhancements done in SQL Server 2008 - What are T-SQL Enhancements done in SQL Server 2008 ? SQL Serv... http://ping.fm/aYUdh

How to install SQL Server (2011) Dena...

How to install SQL Server (2011) Denali Sample Databases - Sample databases form SQL Server Denali (2011 can be down... http://ping.fm/pTUuz

SQL Server Denali no longer support D...

SQL Server Denali no longer support DTS packages - SQL Server 2011 / Denali no longer supports Data Transformation S... http://ping.fm/LqPEV

How to Disable/restrict SSRS Export f...

How to Disable/restrict SSRS Export format ? - SQL Server Reporting Services (SSRS) supports export to different for... http://ping.fm/MWzhr

Denali : Integration Services now Sup...

Denali : Integration Services now Supports undo and redo (CTL+Z and CTL+Y)operations http://ping.fm/c7t2P

SQL Server MiracleDB - What is Miracl...

SQL Server MiracleDB - What is MiracleDB in SQL Server ? MiracleDB is user database created by DBA to operationally ... http://ping.fm/vmSUh

SQL Server Denali : Changed Startup P...

SQL Server Denali : Changed Startup Parameter : New Feature - Changing SQL Services Startup Parameters is very easy ... http://ping.fm/yXDbF

Video : Install SQL Server Denali Set...

Video : Install SQL Server Denali Setup (Install SQL Server 2011) http://ping.fm/uJ3Ep

SQL Server Interview Questions - SQL ...

SQL Server Interview Questions - SQL Server Basic Interview Question Answers, soon I am going to post my own Intervi... http://ping.fm/iHutv

How to secure against SQL injection ?...

How to secure against SQL injection ? - What is SQL Injection? The ability to inject SQL commands into the database ... http://ping.fm/K2u8t

SQL Error : Msg 801, Level 20, State ...

SQL Error : Msg 801, Level 20, State 1, Line 1 A buffer was encountered with an unexpected status of 0x%x. http://ht.ly/1a0wRF

Hardware and Software Requirements fo...

Hardware and Software Requirements for Installing SQL Server http://ping.fm/okWOT

Video : How to Add a Node to an Exist...

Video : How to Add a Node to an Existing SQL Server 2008 Failover Cluster http://ping.fm/A7P6W

Video : How to Setup Replication with...

Video : How to Setup Replication with SQL Server 2008 ? - What is Replication ? Replication is the mechanism for cre... http://ping.fm/DvCUD

Video : How to implement Resource Governor

This Video demonstrates

How to Enable & Disable Resource Governor using SQL Server Management Studio
How to create Resource Pool ?
How to create Workload Group ?
Create a Classification Function ?
How to monitor the resource pools using performance monitor?
What is Resource Governor ?
How to use Resource Governor?
What is the use of Resource Governor ?
How to implement Resource Governor ?

From: http://ping.fm/4MBCJ

Video : How to Export SQL Server Data...

Video : How to Export SQL Server Data to Excel - Copying data from SQL Server to Excel is business requirement. Toda... http://ping.fm/iaUUf

How to Implement Transparent Data Enc...

How to Implement Transparent Data Encryption (TDE)? - What is Transparent Data Encryption (TDE)? Transparent Data En... http://ping.fm/nUPs1

SQL Server 2011 ? New Version Release...

SQL Server 2011 – New Version Release - SQL Server 2011, Yes, Microsoft has planned for it and working on same line,... http://ping.fm/cbujZ

Best Practice ? SQL Server Error Log ...

Best Practice – SQL Server Error Log Management - What is the SQL Server Error Log? SQL Server maintains its own err... http://ping.fm/984dv

SQL Error : Msg 204, Level 20, State ...

SQL Error : Msg 204, Level 20, State 1, Line 1 Normalization error in node http://ping.fm/iIoFs

SQL Server DBA Resume

SQL DBA Resume with 10+ years of Experience

From: http://ping.fm/NqBGB

SQL Server 2005 Service Pack 4 CTP av...

SQL Server 2005 Service Pack 4 CTP available - The CTP version of Service Pack 4 (SP4) for Microsoft SQL Server 2005... http://ping.fm/rGhYS

How to Enable PAE in Windows Server 2...

How to Enable PAE in Windows Server 2008 - PAE (Physical Address Extension) is an Intel-provided memory address exte... http://ping.fm/9yhye

How to Install and Configure Master D...

How to Install and Configure Master Data Services – Video - Master Data Management (MDM) comprises a set of processe... http://ping.fm/khoor

How to Set up Maintenance Plan to Bac...

How to Set up Maintenance Plan to Backup Databases (Video) - Setting up a Maintenance Plan to Backup Databases This ... http://ping.fm/8paN4

New Features in SQL Server 2008 R2 - ...

New Features in SQL Server 2008 R2 - Here are five of the most important features you should watch for in SQL Server... http://ping.fm/i1eSH

Msg 21, Level 20, State 1, Line 1 War...

Msg 21, Level 20, State 1, Line 1 Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact ... http://ht.ly/19Ie0C

SQL Server Management Studio (SSMS) ?...

SQL Server Management Studio (SSMS) – Keyboard Shortcut Keys http://ping.fm/zRRXl

SQL Server Management Studio ? Client...

SQL Server Management Studio – Client Statistics - SQL Server Client Statistics,Client Execution Time ,Query Profile... http://ping.fm/4bP9n

Microsoft SQL Server 2008 Service Pac...

Microsoft SQL Server 2008 Service Pack 2 - Microsoft SQL Server 2008 Service Pack 2 (SP2) is now available for downl... http://ping.fm/PWjCW

Is it possible to restore a backup of...

Is it possible to restore a backup of a SQL Server 2008 database onto an instance of SQL Server 2005? http://ping.fm/Y0DLR

SQL Server Update Statistics with FUL...

SQL Server Update Statistics with FULL SCAN -   Sometimes you just need a quick method to update all statistics... http://ping.fm/fH99o

Why Should I Use Extended Events in S...

Why Should I Use Extended Events in SQL Server 2008 ? - SQL Server Extended Events (Extended Events) is a general ev... http://ping.fm/6nH5M

How Much Space is used by all SQL Ser...

How Much Space is used by all SQL Server Databases ? - This is the very handy question during the operational suppor... http://ping.fm/MqJH7

SQL Server 2005 memory configuration ...

SQL Server 2005 memory configuration - Some notes on memory configuration management for SQL server 2005 (32bit and ... http://ping.fm/BssXj

SQL Server Trainer ? Profile

DBATAG, specialized in SQL Server Corporate trainings and SQL Server Consulting. Please download the attached profile for your ready reference.

From: http://ping.fm/KiPqc

SQL Server Trainer ? Profile - DBATAG...

SQL Server Trainer – Profile - DBATAG, specialized in SQL Server Corporate trainings and SQL Server Consulting. Plea... http://ping.fm/TtWg0

SQL Server Securable ? Permissions / ...

SQL Server Securable – Permissions / Security - SQL Server 2005 introduced a new concept to SQL Server security and ... http://ping.fm/VUjML

SQL Server Advance L3 Workshop in HCL...

SQL Server Advance L3 Workshop in HCL, NOIDA – Oct 04 to Oct 08, 2010 http://ping.fm/OsLV7

How to change default value of SELECT...

How to change default value of SELECT or EDIT top rows in SSMS 2008 ? http://ping.fm/QQEXu

Find All SQL Servers in your Local Ne...

Find All SQL Servers in your Local Network - Today, somebody asked me, how can I find what all are SQL Server Instan... http://ping.fm/wpP2O

Microsoft SQL Server 2008 R2 ? PowerP...

Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010 http://ping.fm/F15BA

How to convert LiteSpeed backup to a ...

How to convert LiteSpeed backup to a native SQL backup ? - SQL Lite Speed is a well known SQL backup software. At ti... http://ping.fm/P3pnt

"Black Box" in SQL Server 2008 - In S...

"Black Box" in SQL Server 2008 - In SQL Server 2008, the Default trace is enabled by default during the installation... http://ping.fm/2UQdb

SET STATISTICS TIME ON ? how to read ...

SET STATISTICS TIME ON – how to read results? - The SET STATISTICS TIME command is used in order to identify parse, ... http://ping.fm/DB5i8

Find All Queries executed on a partic...

Find All Queries executed on a particular Table - Question : what all select queries are running against a particula... http://ping.fm/DV0qw

SQL Monitoring with DDL Triggers - We...

SQL Monitoring with DDL Triggers - We can create a DDL trigger to audit operations such as creating or dropping tabl... http://ow.ly/18TD3N

If you wanted to know : What is Stor...

If you wanted to know :

What is Stored in tempdb ?
A more about tempdb Internals
How to Monitor tempdb
How to Optimize tempdb
tempdb Space Allocation
Tips for Optimizing tempdb
How Many Physical Files Should tempdb Have ?
How to Move tempdb ?

Checkout the answer at :
http://ping.fm/P7SeW

DBATAG, SQLServer-Training, SQL School have been providing Online and Classroom Trainings. DBATAG undertake interactive and quality trainings with real-time orientation on SQL Development (DEV), Database Administration (DBA) and Business Intelligence (MSBI) modules. They prefer real-time guidance rather than bookish information to acquaintance with growing demand in the IT Industry today.

Training Features
=====================
Study Material
Real Time Methodologies
Recorded version of each session
Example Case Studies
24*7 Availability for doubts
Sample Projects
Resume Preparation
Interview guidance and tips
Mock Interviews
FAQs and Best Practices

Training Silos
==============
Online Training
Offline (Class Room)Training
Corporate Training
Weekend Training
Weekend Workshops
Fast Track Courses
Interview Assistance

Courses Offered
=================
SQL Server Development
SQL Server Administration
Microsoft Business Intelligence
Certification Oriented Trainings
DBA Job Support
MSBI Job Support


Certifactions Training
=========================
MCITP - SQL Server 2008, Implementation and Maintenance
MCITP - SQL Server 2008, Database Development
MCITP - SQL Server 2008, Business Intelligence Development and Maintenance
MCTS - SQL Server 2005
MCITP - SQL Server 2005 DBA
MCITP - SQL Server 2005 Developer
MCITP - SQL Server 2005, Business Intelligence Development and Maintenance


Visit http://www.sqlserver-training.com/ for more info or Email : info@sqlserver-training.com

sqlserver-training.com
sqlserver-training
DBATAG

List of Undocumented DBCC STATEMENTS which works with SQL Server 2000

1. DBCC activecursors [(spid)]
2. DBCC addextendedproc (function_name, dll_name)
3. DBCC addinstance (objectname, instancename)
4. DBCC adduserobject (name)
5. DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename,
dbusername, loginid)
6. DBCC autopilot (typeid, dbid, tabid, indid, pages [,flag])
7. DBCC balancefactor (variance_percent)
8. DBCC bufcount [(number_of_buffers)]
9. DBCC buffer ( {‘dbname’ | dbid} [, objid [, number [, printopt={0|1|2} ][,
dirty | io | kept | rlock | ioerr | hashed ]]])
10. DBCC bytes ( startaddress, length )
11. DBCC cachestats
12. DBCC callfulltext
13. DBCC checkalloc [('database_name'[, NOINDEX | REPAIR])] [WITH NO_INFOMSGS[,
ALL_ERRORMSGS][, ESTIMATEONLY]]
14. DBCC checkcatalog [('database_name')] [WITH NO_INFOMSGS]
15. DBCC checkconstraints [( 'tab_name' | tab_id | 'constraint_name' |
constraint_id )] [WITH ALL_CONSTRAINTS | ALL_ERRORMSGS]
16. DBCC checkdb [('database_name'[, NOINDEX | REPAIR])] [WITH NO_INFOMSGS[,
ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, DBCC TABLOCK]
17. DBCC checkdbts (dbid, newTimestamp)]
18. DBCC checkfilegroup [( [ {'filegroup_name' | filegroup_id} ] [, NOINDEX] )]
[WITH NO_INFOMSGS[, ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][,
TABLOCK]]
19. DBCC checkident (‘table_name’[, { NORESEED | {RESEED [, new_reseed_value]} } ] )
20. DBCC checkprimaryfile ( {‘FileName’} [, opt={0|1|2|3} ])
21. DBCC checktable (‘table_name’[, {NOINDEX | index_id | REPAIR}]) [WITH
NO_INFOMSGS[, ALL_ERRORMSGS][, PHYSICAL_ONLY][, ESTIMATEONLY][, TABLOCK]]
22. DBCC cleantable (‘database_name’|database_id, ‘table_name’|table_id,
[batch_size])
23. DBCC cacheprofile [( {actionid} [, bucketid])
24. DBCC clearspacecaches (‘database_name’|database_id, ‘table_name’|table_id,
‘index_name’|index_id)
25. DBCC collectstats (on | off)
26. DBCC concurrencyviolation (reset | display | startlog | stoplog)
27. DBCC config
28. DBCC cursorstats ([spid [,'clear']])
29. DBCC dbinfo [('dbname')]
30. DBCC dbrecover (dbname [, IgnoreErrors])
31. DBCC dbreindex (‘table_name’ [, index_name [, fillfactor ]]) [WITH NO_INFOMSGS]
32. DBCC dbreindexall (db_name/db_id, type_bitmap)
33. DBCC dbrepair (‘dbname’, DROPDB [, NOINIT])
34. DBCC dbtable [({'dbname' | dbid})]
35. DBCC debugbreak
36. DBCC deleteinstance (objectname, instancename)
37. DBCC des [( {'dbname' | dbid} [, {'objname' | objid} ])]
38. DBCC detachdb [( 'dbname' )]
39. DBCC dropcleanbuffers
40. DBCC dropextendedproc (function_name)
41. DBCC dropuserobject (‘object_name’)
42. DBCC dumptrigger ({‘BREAK’, {0 | 1}} | ‘DISPLAY’ | {‘SET’, exception_number} |
{‘CLEAR’, exception_number})
43. DBCC errorlog
44. DBCC extentinfo [({'database_name'| dbid | 0} [, {'table_name' | table_id} [,
{'index_name' | index_id | -1}]])]
45. DBCC fileheader [( {'dbname' | dbid} [, fileid])
46. DBCC fixallocation [({'ADD' | 'REMOVE'}, {'PAGE' | 'SINGLEPAGE' | 'EXTENT' |
'MIXEDEXTENT'}, filenum, pagenum [, objectid, indid])
47. DBCC flush (‘data’ | ‘log’, dbid)
48. DBCC flushprocindb (database)
49. DBCC free dll_name (FREE)
50. DBCC freeproccache
51. DBCC freeze_io (db)
52. DBCC getvalue (name)
53. DBCC help (‘dbcc_command’ | ‘?’)
54. DBCC icecapquery (‘dbname’, stored_proc_name [, #_times_to_icecap (-1 infinite,
0 turns off)]) Use ‘dbcc icecapquery (printlist)’ to see list of SP’s to
profile. Use ‘dbcc icecapquery (icecapall)’ to profile all SP’s.
55. DBCC incrementinstance (objectname, countername, instancename, value)
56. DBCC ind ( { ‘dbname’ | dbid }, { ‘objname’ | objid }, { indid | 0 | -1 | -2 } )
57. DBCC indexdefrag ({dbid | dbname | 0}, {tableid | tablename}, {indid | indname})
58. DBCC inputbuffer (spid)
59. DBCC invalidate_textptr (textptr)
60. DBCC invalidate_textptr_objid (objid)
61. DBCC iotrace ( { ‘dbname’ | dbid | 0 | -1 }, { fileid | 0 }, bufsize, [ { numIOs
| -1 } [, { timeout (sec) | -1 } [, printopt={ 0 | 1 }]]] )
62. DBCC latch ( address [, 'owners'] [, 'stackdumps'])
63. DBCC lock ([{'DUMPTABLE' | 'DUMPSTATS' | 'RESETSTATS' |
'HASH'}]|[{'STALLREPORTTHESHOLD', stallthreshold}])
64. DBCC lockobjectschema (‘object_name’)
65. DBCC log ([dbid[,{0|1|2|3|4}[,['lsn','[0x]x:y:z’]|
['numrecs',num]|['xdesid','x:y']|
['extent','x:y']|['pageid','x:y']|
['objid',{x,'y'}]|['logrecs',{'lop'|op}...]|
['output',x,['filename','x']]…]]])
66. DBCC loginfo [({'database_name' | dbid})]
67. DBCC matview ({‘PERSIST’ | ‘ENDPERSIST’ | ‘FREE’ | ‘USE’ | ‘ENDUSE’})
68. DBCC memobjlist [(memory object)]
69. DBCC memorymap
70. DBCC memorystatus
71. DBCC memospy
72. DBCC memusage ([IDS | NAMES], [Number of rows to output])
73. DBCC monitorevents (’sink’ [, 'filter-expression'])
74. DBCC newalloc – please use checkalloc instead
75. DBCC no_textptr (table_id , max_inline)
76. DBCC opentran [({'dbname'| dbid})] [WITH TABLERESULTS[,NO_INFOMSGS]]
77. DBCC outputbuffer (spid)
78. DBCC page ( {‘dbname’ | dbid}, filenum, pagenum [, printopt={0|1|2|3} ][,
cache={0|1} ])
79. DBCC perflog
80. DBCC perfmon
81. DBCC pglinkage (dbid, startfile, startpg, number, printopt={0|1|2}, targetfile,
targetpg, order={1|0})
82. DBCC pintable (database_id, table_id)
83. DBCC procbuf [({'dbname' | dbid}[, {'objname' | objid}[, nbufs[, printopt = { 0 |
1 } ]]] )]
84. DBCC proccache
85. DBCC prtipage (dbid, objid, indexid [, [{{level, 0} | {filenum, pagenum}}]
[,printopt]])
86. DBCC pss [(uid[, spid[, printopt = { 1 | 0 }]] )]
87. DBCC readpage ({ dbid, ‘dbname’ }, fileid, pageid, formatstr [, printopt = { 0 |
1} ])
88. DBCC rebuild_log (dbname [, filename])
89. DBCC renamecolumn (object_name, old_name, new_name)
90. DBCC resource
91. DBCC row_lock (dbid, tableid, set) – Not Needed
92. DBCC ruleoff ({ rulenum | rulestring } [, { rulenum | rulestring } ]+)
93. DBCC ruleon ( rulenum | rulestring } [, { rulenum | rulestring } ]+)
94. DBCC setcpuweight (weight)
95. DBCC setinstance (objectname, countername, instancename, value)
96. DBCC setioweight (weight)
97. DBCC show_statistics (‘table_name’, ‘target_name’)
98. DBCC showcontig (table_id | table_name [, index_id | index_name] [WITH FAST,
ALL_INDEXES, TABLERESULTS [,ALL_LEVELS]])
99. DBCC showdbaffinity
100. DBCC showfilestats [(file_num)]
101. DBCC showoffrules
102. DBCC showonrules
103. DBCC showtableaffinity (table)
104. DBCC showtext (‘dbname’, {textpointer | {fileid, pageid, slotid [,option]}})
105. DBCC showweights
106. DBCC shrinkdatabase ({dbid | ‘dbname’}, [freespace_percentage [, {NOTRUNCATE |
TRUNCATEONLY}]])
107. DBCC shrinkdb is no longer supported. Please use shrinkdatabase instead
108. DBCC shrinkfile ({fileid | ‘filename’}, [compress_size [, {NOTRUNCATE |
TRUNCATEONLY | EMPTYFILE}]])
109. DBCC sqlmgrstats
110. DBCC sqlperf (LOGSPACE)({IOSTATS | LRUSTATS | NETSTATS | RASTATS [, CLEAR]} |
{THREADS} | {LOGSPACE})
111. DBCC stackdump [( {uid[, spid[, ecid]} | {threadId, ‘THREADID’}] )]
112. DBCC tab ( dbid, objid )
113. DBCC tape_control {‘query’ | ‘release’}[,('\\.\tape')]
114. DBCC tec [( uid[, spid[, ecid]] )]
115. DBCC textall [({'database_name'|database_id}[, 'FULL' | FAST] )]
116. DBCC textalloc ({‘table_name’|table_id}[, 'FULL' | FAST])
117. DBCC thaw_io (db)
118. DBCC traceoff [( tracenum [, tracenum ... ] )]
119. DBCC traceon [( tracenum [, tracenum ... ] )]
120. DBCC tracestatus (trace# [, ...trace#])
121. DBCC unpintable (dbid, table_id)
122. DBCC updateusage ({‘database_name’| 0} [, 'table_name' [, index_id]]) [WITH
[NO_INFOMSGS] [,] COUNT_ROWS]
123. DBCC upgradedb (db)
124. DBCC usagegovernor (command, value)
125. DBCC useplan [(number_of_plan)]
126. DBCC useroptions
127. DBCC wakeup (spid)
128. DBCC writepage ({ dbid, ‘dbname’ }, fileid, pageid, offset, length, data)