Agile Terminology – Sunday Fun Crossword
Across 1. These are specific criteria identified by the customer for each functional requirement. 2. Work in Progress. Down 1. A timeboxed task to go… Read More »Agile Terminology – Sunday Fun Crossword
TSQL
Sessions Accepted for DevTeach Vancouver BC
Today I learned that two of the sessions that I proposed for Vancouver DevTeach were accepted. This event taking place on December 2nd to 4th 2013… Read More »Sessions Accepted for DevTeach Vancouver BC
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
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
SQL Server Crossword Puzzle
Across 2. Management Studio 5. The database that is used as a template when creating a new database 6. Using a backup 7. Reporting Services… Read More »SQL Server Crossword Puzzle
250th Blog Post at SteveStedman.com
This is my 250th blog post at Steve Stedman.com. Many of the post over the last year have been focused on Common Table Expression topics… Read More »250th Blog Post at SteveStedman.com
End of DBCC Command Month
As the month of May comes to an end so does DBCC command month at SteveStedman.com. I didn’t cover all the DBCC Commands this month,… Read More »End of DBCC Command Month
DBCC SqlPerf
Being day 27 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC SQLPERF. Description: DBCC SQLPERF is used to do a… Read More »DBCC SqlPerf