For a couple of months we have had requests on the SQL Data Partners Podcast to do an episode on indexing. It is my pleasure to announce that the Indexing episode was released today, well at lease half of it. …

Podcast Episode – The Long Awaited Index Episode Read more »

TL;DR summary: Don’t do it. Stop reading here if you want, but just don’t do it. This post refers to shrinking your database files (mdf, or ndf files), not shrinking the log file. The log file is a completely different …

DBCC ShrinkDatabase – I want to shrink my database. Read more »