How is Fill Factor Impacting My Indexes?

The theme for this month's T-SQL Tuesday is indexes so it seemed like the perfect excuse to blog about a script that I have written to see what choices...

One wide index or multiple narrow indexes?

Or “If one index is good, surely many indexes (indexes? indices? indi?) will be better”
This is a question that comes...

PASS Election Ends Tomorrow (Sep 15, 2010)

If you haven’t voted I hope you will. Ballots were sent out via email to those members eligible to vote....

September OPASS Meeting Tonight!

Live Meeting: https://www.livemeeting.com/cc/usergroups/join?id=NQ65ZG&role=attend

Mini-Session

Topic: Using PIVOT – Going from Static to Dynamic

Sometimes data normalization results in a data structure that is not convenient for...

Some Days....

Some days I think I go full retard.

SQL Server 2008 Surface Area Configuration

Ever wondered what happened to the SQL 2005 Surface Area Configuration Utility in SQL SERVER 2008.
Well you can accomplish pretty...

SQL Server Security Checklist

In this post, I continue my checklist series that will eventually become a new book. The focus of this checklist...

Task Manager - Don't Believe the System Idle Process Percentage

This morning my laptop went to a crawl. I looked, and sure enough, there was an AntiVirus scan running. Argh!...

The SQLSaturday Squirrel

A bit of mid week humor. Recently I met up with Jack Corbett to review our room options for SQLSaturday...

T-SQL Tuesday #10 - Indexes

It’s time for T-SQL Tuesday again, the brainchild of Adam Machanic (Blog|Twitter), and this month’s topic is Indexes. A thanks...