My 10 Favorite SQLPerformance Posts Over 10 Years
On the 10th anniversary of SQLPerformance.com, I look back on my favorite posts – one from each year.
Monthly Archive: July 2022
T-SQL Tuesday #152 : Soapboxing
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…
Using a “Goal Posts” Table to Reduce Scan Impact
Logging tables can grow unchecked for years, and date range queries against them get more and more expensive if they don't use the clustered index. Read about one way I've mitigated this problem.