Tag: CHECKFILEGROUP

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 TRACEON TRACESTATUS UNPINTABLE UPDATEUSAGE USEROPTIONS END OF PUZZLE ————————- See also: For more information on DBCC Commands: DBCC CheckAlloc DBCC …

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

By Posted on Posted in DBCC Commands No Comments Tagged with , , , ,

Being day five of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKFILEGROUP. Description: DBCC CHECKFILEGROUP is used for a specific filegroup to check the disk allocation and structural integrity of all tables and indexed views. DBCC CHECKFILEGROUP Syntax: filegroup_name – The name of the filegroup to be checked. Ddefault (or if 0 is specified) = …

DBCC CheckFilegroup Read more »