Thanks the link is very useful.
However, I have another question. What is actually lost through setting the UseTransaction query property to No?
If there are no real detrimental effects and this option serves only to improve performance, why is the default "Yes"?