Probe Residual when you have a Hash Match – a hidden cost in execution plans

The power of T-SQL's APPLY operator

Rob Farley — Tue, 12 Apr 2011 23:30:13 GMT

I could go on all day about APPLY – it really is an incredible part of T-SQL. It helps solves problems

LobsterPot submissions for SQLPASS

Rob Farley — Fri, 06 May 2011 04:05:43 GMT

My guys are great! When PASS started accepting abstract submissions for their Summit (in October this

Join Performance, Implicit Conversions, and Residuals

Paul White: Page Free Space — Tue, 19 Jul 2011 01:06:04 GMT

You probably already know that it’s important to be aware of data types when writing queries, and that

re: Probe Residual when you have a Hash Match – a hidden cost in execution plans

Chris Adkin — Tue, 27 Nov 2012 08:41:28 GMT

Presumably the use of filter indexes might be another option for solving this problem ?

re: Probe Residual when you have a Hash Match – a hidden cost in execution plans

Rob Farley — Tue, 27 Nov 2012 08:45:53 GMT

Yes - but this post is more designed for highlighting the issue. I figure that solving it is a standard exercise in query tuning, once you see the impact of the Residuality.