On the 10th anniversary of SQLPerformance.com, I look back on my favorite posts – one from each year.

For this month's T-SQL Tuesday, Deb Melkin asks us get up on our favorite soapbox. I have so many, but this time I picked a new one…

Logging tables get huge, and date range queries get more if they don't use the clustered index. Here's one way I've addressed the issue.