Category Archives: DBCC
-
Why shouldn’t I shrink my database data file?
2November 20, 2017 by Kenneth Fisher
A while back I did a post about why you shouldn’t shrink your data file. This one is going to …
Continue reading -
Uniquifier is a rather unique word isn’t it?
8September 18, 2017 by Kenneth Fisher
tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique. Uniquifier is a rather funny …
Continue reading -
Why shouldn’t I shrink my database log file?
3May 15, 2017 by Kenneth Fisher
TL;DR: It’s pretty pointless and can cause performance issues. Let’s start by asking why you might want to shrink your …
Continue reading -
I need help with DBCC
2June 6, 2016 by Kenneth Fisher
Many years ago during an interview I was asked to “Name the top 7 DBCC commands that you use.” I …
Continue reading -
Does SQL Server do a CHECKDB during an instance restart?
11May 7, 2014 by Kenneth Fisher
When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server …
Continue reading
