Free Ransomware Course – Everyday Value
Around a year ago I put together this free Ransomware Awareness course. It is one of those things that I felt so strong about because… Read More »Free Ransomware Course – Everyday Value
FREE
Database Health Monitor Beta 10.2 Released Today
It has been a long day, but I was able to get the latest Beta release of Database Health Monitor out. If you haven’t heard… Read More »Database Health Monitor Beta 10.2 Released Today
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
Over 400 downloads of the database health reports.
Today, the Database Health Reports had its 400th download. I would like to say thank you to everyone who is using the product, and an extra thank… Read More »Over 400 downloads of the database health reports.
Over 300 Dowloads of the Database Health Reports
Today, the Database Health Reports had its 300th dowload. I would like to say thank you to everyone who is using the product, and an… Read More »Over 300 Dowloads of the Database Health Reports
Backup Set Report added to FREE Server Health Reports
In preparation for an upcoming SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. This report… Read More »Backup Set Report added to FREE Server Health Reports
Database Size report added to SQL Health Reports
In preparation for a SQL Saturday presentation I have created another report to add to the FREE SQL Server Health reports project. The Database… Read More »Database Size report added to SQL Health Reports