Home › Posts tagged SHRINKDATABASE

Tag: SHRINKDATABASE

By Posted on Posted in DBCC Commands, SQL Sunday, TSQL No Comments Tagged with , , , , , ,

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 …

SQL Sunday Fun – Word Search with SQL Server DBCC Commands Read more »

By Posted on Posted in DBCC Commands 1 Comment Tagged with , , , , , , , , , , , , ,

Being day 24 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC SHRINKDATABASE. When I first heard about DBCC Shrink Database (many years ago), I immediately thought “what a great feature, run this every night when …

DBCC ShrinkDatabase Read more »

By Posted on Posted in Performance No Comments Tagged with , , , , , , ,

Is it a good idea to run DBCC SHRINKDATABASE regularly? Download the sample file ShrinkSample. This article and samples apply to SQL Server 2005, 2008, and 2008R2. This really depends on a number of factors, but generally the answer is …

Index Fragmentation and SHRINKDATABASE Read more »