Tag Archives: administration

sp_Blitz, v16, on SQLServerCentral

Posted on January 10, 2013 by way0utwest

Brent Ozar Unlimited released v16 of this sp_blitz script, which is designed to run on a SQL Server instance and give you a quick, comprehensive report of the state of the instnace. It’s a great script, and if you have … Continue reading →

Posted in Blog | Tagged , , | Comments Off on sp_Blitz, v16, on SQLServerCentral

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

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

The Daily Routine

Posted on December 27, 2012 by way0utwest

This editorial was originally published on Mar 10, 2008. It is being re-run as Steve is on holiday. If you work in an operational area, especially if you’re a DBA, you typically have a fairly tedious routine. You definitely have … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on The Daily Routine