Category: DBCC Commands

DBCC FreeSystemCache

Being day 14 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC FREESYSTEMCACHE. Description: DBCC FREESYSTEMCACHE is used to free all memory associated with all of the SQL Server caches. DBCC FREESYSTEMCACHE Syntax: Example: The following

Posted in DBCC Commands Tagged with: ,

DBCC FreeSessionCache

Being day 13 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC FREESESSIONCACHE. Description: DBCC FreeSessionCache is only available on SQL Server 2005 and newer it removes all queries from the distributed query cache. This however

Posted in DBCC Commands Tagged with: , , ,

DBCC FreeProcCache

Being day 12 of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC FREEPROCCACHE. Description: DBCC FREEPROCCACHE is used for purge all of the parsed query plans out of memory. This is commonly used in development environments,

Posted in DBCC Commands Tagged with: , , , , , , , ,

DBCC DropCleanBuffers

Being day ten of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC DROPCLEANBUFFERS. Description: DBCC DropCleanBuffers is great to use in a development or test environment to flush all of the clean data pages out of memory

Posted in DBCC Commands Tagged with: ,

DBCC DBReIndex

Being day nine of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC DBREINDEX. Microsoft recommends avoiding the use of DBCC DBREINDEX. DBCC DBReIndex has been deprecated  meaning that Microsoft has announced that DBCC DBReIndex will be going

Posted in DBCC Commands Tagged with: , , ,

DBCC CleanTable

Being day eight of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CLEANTABLE. Many times I have worked on a database that has evolved over 10 or more years of changes from different developers and DBAs.

Posted in DBCC Commands Tagged with: , , , ,

DBCC CheckTable

Being day seven of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKTABLE. Description: DBCC CheckTable is used to check the structure of a table to verify the integrity of every data page associated with that

Posted in DBCC Commands Tagged with: , , , , , ,

DBCC CheckIdent

Being day six of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKIDENT. Description: DBCC CHECKIDENT is used for check on the current value in the identity column for a table.  It also reports on the

Posted in DBCC Commands Tagged with: , , , , , , , , , ,

DBCC CheckFilegroup

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.

Posted in DBCC Commands Tagged with: , , , ,

DBCC CheckDB for Database Consistency

Being day four of the DBCC Command month at SteveStedman.com, today’s featured DBCC Command is DBCC CHECKDB. For more info on DBCC see the Database Corruption Challenge. DBCC CheckDB Description: DBCC CHECKDB is used to check the physical integrity of

Posted in DBCC Commands Tagged with: , , , , , , , , , , ,