Can I get clarification on SARGability related to the predicate CarrierTrackingNumber = ISNULL(@Carrier, CarrierTrackingNumber)? I would have thought that this predicate is still SARGable since the ISNULL function...

+1. Luckily I've done this a few times before.

Thanks for the question.

Andre Ranieri

+1 Thanks for the nice question.

Andre Ranieri

+1 helps to have done this a couple times. Great question.

Andre Ranieri

Great questions. I love working with windowing functions.

Nice question, thanks Steve.

+1 - thanks for the question.

+1 Thanks for the great question.

+1

Good question, thanks!

+1

+1; interesting explanation regarding the semi colon. I learned something today.

+1 great question. Thanks.

+1 looks like most people got this one.

+1 Thank you, favorite search engine!