Tag: CHECKDB

DBCC CheckDB and CheckTable doesn’t check In-Memory OLTP.

Special thanks to my friend Theresa Iserman for introducing me to Jos de Bruijn the Senior Program Manager for the In Memory OLTP (Hekaton) project to help get my questions answered at PASS Summit. So, the Hekaton – In Memory

Posted in Corruption, Hekaton Tagged with: , , , , ,

Introducing the DataBase Corruption Challenge (DBCC) – Week 1 Challenge

Welcome to the DataBase Corruption Challenge, this is an about weekly blog challenge where I will post a corrupt SQL Server database with some details on what happened to it. If at this point you are already a bit irked

Posted in Corruption, SQL 2014 Tagged with: , , , , , , ,

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

Posted in DBCC Commands, SQL Sunday, TSQL 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: , , , , , , , , , , ,
Top