SQL Sunday Fun – Word Search with SQL Server DBCC Commands

SQL_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:

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 you to those who have provided me with feedback.

Here is a history of the Database Health Report project, http://databasehealth.stevestedman.com/about.

My Goal:  I would like to provide the Database Health Reports project for free to as many people as I possibly can for as long as I can.  One day I am sure that it will require more of a support team, and more developers, but as long as I can do this for FREE with just me working on it I will continue to do that.

Download

If you haven’t tried out the Database Health Reports project you can get it from the FREE download page.

I am currently working on Beta 6. Currently Beta 5 is out in the wild and going well.

Thanks!!!

Thanks everyone for using the Database Health Reports project!

-Steve Stedman

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 extra thank you to those who have provided me with feedback.

Since I started  planning the Database Health Reports a year and a half ago, until the latest download release on January 10th, 2013, it has been quite an adventure. I have met many great people, learned lots about their specific environments and needs, and grown the product to more than I ever considered.

Here is a history of the Database Health Report project, http://databasehealth.stevestedman.com/about.

My Goal:  I would like to provide the Database Health Reports project for free to as many people as I possibly can for as long as I can.  One day I am sure that it will require more of a support team, and more developers, but as long as I can do this for FREE with just me working on it I will continue to do that.

Download

If you haven’t tried out the Database Health Reports project you can get it from the FREE download page.

I am currently working on Beta 5, and plan to add some great new features in the next beta release.

Thanks!!!

Thanks everyone for using the Database Health Reports project!

-Steve Stedman

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 has been replaced with the Backup Report in the Database Health Project.

The Backup Set Report has been added to the SQL Health Reports.  The Backup Set Report  is the 7th report to be added to the Database Health Reports package.

The Database Health reports package is a FREE collection of several reports that I have created to monitor and maintain the health of your SQL server.

With this report you can quickly check out the sizes and growth of the databases with the 10 largest backups.

Download it and enjoy.  If you have any feedback, please send it my way.

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 Size Report has been added to the SQL Health Reports.  The Database Size Report  is the 6th report to be added to the Database Health Reports package.

The Database Health reports package is a FREE collection of several reports that I have created to monitor and maintain the health of your SQL server.

 

With this report you can quickly assess the size of your databases and the logs to determine which may be growing faster than you expect.