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