This article is about a situation that many of us could describe the
theoretical approach to solving, but then struggle to understand why SQL Server wasn’t following that
theoretical approach when you tried it for real. Earlier this week, I had a client ask about the best way to perform: a partial
…