Pass Through

Question

Pass Through

Hugo Kornelis

SSC Guru

Points: 64790
More actions
November 12, 2015 at 11:32 pm

#399322

Comments posted to this topic are about the item Pass Through
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

porter.james Mr or Mrs. 500 Points: 590 More actions · Answer 1

A quick google search returned no relevant results explaining this property. Perhaps this is something Microsoft could do better to document.

Rich Mechaber SSChampion Points: 11130 More actions · Answer 2

As usual, a great question Hugo, but even better are your explanations!

I have no link for "documentation" per se, but this page has a nice example of a pass-through situation forcing a nested loop join, even when that hurts performance.

Rich

Ken SSCoach Points: 17191 More actions · Answer 3

Very informative as usual Hugo! Odd that I couldn't find anything online regarding this. Thanks for the explanation!

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 4

Never heard of such property "pass through" before. But while reading the question multiple times and by doing a smart elimination, picked up the correct option.

Thanks.

Hany Helmy SSChampion Points: 13921 More actions · Answer 5

Rich Mechaber (11/13/2015)
As usual, a great question Hugo, but even better are your explanations!
I have no link for "documentation" per se, but this page has a nice example of a pass-through situation forcing a nested loop join, even when that hurts performance.
Rich

Never enocuntered/or noticed a usage of this property b4, but that link helped me to understand it, thanx.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 6

Thanks for this interesting question on a difficult topic.

I have been able to guess the good choice only because I have studied the chapter 10 of the Microsoft SQL Server 2012 Internals written by Kalen Delaney ( and many others famous persons like Jonathan Kehayias or Paul Randal ) during the August month.

For people who could be interested : have a look at the pages 578 ==> 580.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 7

Thanks for a very good question that taught me something.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 8

Quite an elaborate explanation in the answer. Thank you.

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 9

Hugo should get extra points for his very elaborate answer!

Great question, well done.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Marcia J SSCertifiable Points: 5649 More actions · Answer 10

Koen Verbeeck (11/17/2015)
Hugo should get extra points for his very elaborate answer!
Great question, well done.

Agreed.

Pass Through

Cookies on SQLServerCentral