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 goal posts to reduce scan impact

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.