Tag Archives: sql server

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

Full-Text Search – Stoplists in SQL Server

Posted on December 31, 2012 by way0utwest

Full-text search is an interesting subsystem in SQL Server. It allows you to implement searches through a variety of text formats stored in SQL Server. This is a one of a series of posts that looks at different facets of … Continue reading →

Posted in Blog | Tagged , , | 4 Comments

2013 Goals

Posted on December 28, 2012 by way0utwest

It’s the last Friday of 2012. If you’re reading this, then I assume the world hasn’t ended and you are planning on starting the next year next week. This is the time of year where we often look forward and … Continue reading →

Posted in Editorial | Tagged , , | 2 Comments