Beta 7+ Filter Technical Debt by Debt Type
One of the ideas behind Scrum software development is the idea of “Release early, Release Often and Get Customer Feedback.” After the release of Beta… Read More »Beta 7+ Filter Technical Debt by Debt Type
SteveStedman
Database Health Beta 7 Released – Featuring SQL Technical Debt Analysis
I have been working on Beta 7 over the last 3 months, and it is finally ready. Beta 7 has been released today featuring the addition… Read More »Database Health Beta 7 Released – Featuring SQL Technical Debt Analysis
Suggest An Idea for Database Health Reports
As I get ready for Beta 7 to launch I have decided that for Beta 8 I will focus on feature suggestions from the users… Read More »Suggest An Idea for Database Health Reports
Finished the Beginning C# Course on the Joes2Pros Academy
After 23 years of programming experience, many years of C, C++ and C#, I realized that I have never actually taken a course in C#.… Read More »Finished the Beginning C# Course on the Joes2Pros Academy
Introducing the Joes2Pros Academy
The new Joes2Pros Academy has just launched. The Academy provides an interactive classroom experience that can be accessed on your own time as you need it. This site… Read More »Introducing the Joes2Pros Academy
SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality
Click on the grid to enlarge, then print it. Find the following words in the grid up, down, left, right, horizontal, vertical, and… Read More »SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality
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
I’m Speaking at SQL Saturday #190 in Denver
One of my sessions was accepted for SQL Saturday #190 in Denver this year. Please come see my CTE presentation. Common Table Expressions –… Read More »I’m Speaking at SQL Saturday #190 in Denver
SQL Server Technical Debt
As Beta 7 of the Database Health Reports approaches is just three weeks, the big new feature that has been added is the SQL Technical… Read More »SQL Server Technical Debt
SQL Sunday Fun – Word Search with SQL Server Keywords
The following SQL Server keywords are hidden in the word search puzzle. Find them all! ALTER BETWEEN CLUSTERED COLUMN COMMIT CREATE DATABASE DEFAULT ELSE END… Read More »SQL Sunday Fun – Word Search with SQL Server Keywords