Actually, I pity the SQL Server that has to create Spools in order to handle nasty queries. But that is too long for a title. The title is a lie. With that being said, spools may appear in specific situations, e.g. where some repetitive operations are done, or Halloween Protection is required. There are four … Continue reading Performance Woes & Wows #6: I Pity The Spool
Querying the Same Thing. Faster. In a previous post, we’ve seen that equivalent queries can produce distinct execution plans – Yes, how nice and intuitive of you SQL Server. But this happens for a logical reason: The Query Optimizer hates you doesn’t have the means to explore every possible semantic equivalence. Hence, the shape of … Continue reading Performance Woes & Wows #5: IN vs UNION
Follow My Blog
Get new content delivered directly to your inbox.