SQL Sunday Fun – Word Search with SQL Server DBCC Commands
The following DBCC commands are all hidden in the word search. Be aware, some of the DBCC commands are undocumented.
| CACHESTATS | CHECKCATALOG | CHECKCONSTRAINTS |
| CHECKDB | CHECKFILEGROUP | CHECKIDENT |
| CLEANTABLE | DROPCLEANBUFFERS | FLUSHPROCINDB |
| FREE | FREEPROCCACHE | FREESESSIONCACHE |
| FREESYSTEMCACHE | INDEXDEFRAG | OPENTRAN |
| OUTPUTBUFFER | PAGE | PROCCACHE |
| SHOWCONTIG | SHRINKDATABASE | TRACEON |
| TRACESTATUS | UNPINTABLE | UPDATEUSAGE |
| USEROPTIONS |
END OF PUZZLE ————————-
See also:
For more information on DBCC Commands:
- DBCC CheckAlloc
- DBCC CheckCatalog
- DBCC CheckConstraints
- DBCC CheckDB
- DBCC CheckFilegroup
- DBCC CheckIdent
- DBCC CheckTable
- DBCC CleanTable
- DBCC DBReIndex and the proper defragmentation of indexes.
- DBCC DropCleanBuffers
- DBCC FreeProcCache
- DBCC FreeSessionCache
- DBCC FreeSystemCache
- DBCC Help
- DBCC IndexDefrag and what to use for proper defragmentation after SQL Server 2000.
- DBCC InputBuffer (How to see what T-SQL others are running).
- DBCC OutputBuffer
- DBCC ShrinkDatabase (someone sent in a quote “every time you you run DBCC ShrinkDatabase a kitten dies”).
- DBCC ShrinkFile
- DBCC SqlPerf
- DBCC checkalloc
- DBCC checkcatalog
- DBCC checkconstraints
- DBCC checkdb
- DBCC checkfilegroup
- DBCC checkident
- DBCC checktable
- DBCC cleantable
- DBCC dbreindex
- DBCC dropcleanbuffers
- DBCC free
- DBCC freeproccache
- DBCC freesessioncache
- DBCC freesystemcache
- DBCC help
- DBCC indexdefrag
- DBCC inputbuffer
- DBCC opentran
- DBCC outputbuffer
- DBCC pintable
- DBCC proccache
- DBCC show_statistics
- DBCC showcontig
- DBCC shrinkdatabase
- DBCC shrinkfile
- DBCC sqlperf
- DBCC traceoff
- DBCC traceon
- DBCC tracestatus
- DBCC unpintable
- DBCC updateusage
- DBCC useroptions
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Leave a Reply