HomeData Modelling & AIPaul White: Row Goals Part 4: Anti Join Anti Pattern

Paul White: Row Goals Part 4: Anti Join Anti Pattern

Paul White continues his series on row goals, treating a redundant and problematic TOP (1) that is added to the inner side of an apply anti join.

Continue reading…

SQLPerformance.com is about providing innovative and practical solutions for improving SQL Server performance. Whether you are running a 3rd party application database where very little can be changed, or you are a DBA at a site where getting the application developers to change anything is next to impossible, industry experts including Paul Randal, Jonathan Kehayias, Erin Stellato and Paul White will cover both the “how” and the “why.”

RELATED ARTICLES

Most Popular

Dominic
32686 POSTS0 COMMENTS
Milvus
131 POSTS0 COMMENTS
Nango Kala
7053 POSTS0 COMMENTS
Nicole Veronica
12193 POSTS0 COMMENTS
Nokonwaba Nkukhwana
12291 POSTS0 COMMENTS
Shaida Kate Naidoo
7178 POSTS0 COMMENTS
Ted Musemwa
7444 POSTS0 COMMENTS
Thapelo Manthata
7157 POSTS0 COMMENTS
Umr Jansen
7147 POSTS0 COMMENTS