This Stinks
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.
Related Posts
- The SQL Server Performance Tasting Menu: Performance Issues With Parallel Query Plans
- The SQL Server Performance Tasting Menu: How You Compare Date Columns Can Hurt Query Performance
- The SQL Server Performance Tasting Menu: How Multi-Statement Table Valued Functions Hurt Performance
- The SQL Server Performance Tasting Menu: Tuning Modification Queries With #Temp Tables
Hi Erik,
I haven’t seen an EXISTS with similar conditions to your >= u.id and = and <= would just equate to =)
Also, I really did ponder this for longer than I'd be comfortable to admit.