Knowing when and how often your indexes are used can really come in handy. Indexes that are never utilized aren't worth keeping around, and knowing their usage patterns can be a big help when making decisions regarding things such as filegroup placement and compression settings. SQL Server 2005 brought some great …

Read More

This post is my contribution to T-SQL Tuesday #10, which is being hosted by Michael J. Swart (blog | twitter) Each year my Boy Scout troop has a rummage sale as a fundraiser. All the scouts and their families gather up their old clothes, books, toys, electronics, and any other treasures they no longer need and donate …

Read More

This post is my contribution to T-SQL Tuesday #007, hosted this month by the SQLChicken himself, Jorge Segarra (Blog | Twitter). Since I'm a bad DBA and have yet to get my hands on a copy of R2, I'll make use of the rule that we can discuss any feature from 2008. My favorite is filtered indexes, as they were the …

Read More