SQLSaturday Orlando 2010 - The Planning Begins

Believe it or not, it's already time to start planning for Orlando's next SQLSaturday.  Andy Warren and I had our...

2010 Goals – First Quarter Review

Overall, not too bad for the first quarter, but definitely some areas I need to pick up the slack on.

Community...

Use a Clustered Index

I stumbled across this clustered index test from Hugo Kornelis recently from a post in the forums. I think I’d...

New MSSQLTips Article: Nesting Database Roles in SQL Server

I'm still way behind on my writing for the year, thanks to fighting off stronger than usual migraines and now...

A DMV a Day – Day 7

I have three different DMVs for Day 7. The first one is sys.dm_db_missing_index_group_stats, which is described by BOL as:
Returns summary...

Catching Transient CPU Spikes Using SQL Trace

Catching Transient CPU Spikes Using SQL Trace If there was one thing I wish everyone who works with SQL Server would...

LV April SQL Users Group Meeting

S3OLV or SSSOLV will be holding our meeting Thursday April 8th.  The User Group is in affiliation with PASS and...

24 Hours of PASS Registration Now Open

Registration for the 24 Hours of PASS is now open. This free, online training event will be held starting 12:00...

IP and Default Trace…T-SQL Tuesday #005 - A week early - D'oh

As chance would have it, I had been checking Adam’s blog daily for the last few days to find the...

Is Anybody Using That Stored Procedure?

Introduction
From time to time I get asked to check if a stored procedure is still used in preparation for dropping...