Monthly Archives: January 2013

The Default Fillfactor for an Index

Posted on January 7, 2013 by way0utwest

I ran down the rabbit hole on transaction logs recently. I started with Paul Randal’s post over at the SQL Sentry blog on trimming the transaction log, then went to his video on log analysis. I also glanced at the … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on The Default Fillfactor for an Index

The $50,000 Laptop

Posted on January 7, 2013 by way0utwest

I wrote a long time ago about the value of the data on a laptop being worth more than the hardware. That’s certainly true for me, and I very much worry more about losing the data on my devices than the any … Continue reading →

Posted in Editorial | Tagged , | 3 Comments

Speaking at SQL Saturday #183 – Albuquerque

Posted on January 4, 2013 by way0utwest

I’ve been accepted to speak at SQL Saturday #183 in Albuquerque, NM on Feb 9, 2013. This is the first SQL Saturday in New Mexico, and I’m excited to drive down and meet the SQL Server pros down there. My … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Speaking at SQL Saturday #183 – Albuquerque

Checking the Instance Fill Factor

Posted on January 3, 2013 by way0utwest

I was reading a post from Paul Randal recently and noted that he recommends not changing the instance’s default fill factor. I agree, and you shouldn’t alter it. However if you aren’t sure if it’s been changed on any of … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Checking the Instance Fill Factor