eager – Tarik Billa

Ways to avoid eager spool operations on SQL Server

August 3, 2023 by Tarik

My understanding of spooling is that it’s a bit of a red herring on your execution plan. Yes, it accounts for a lot of your query cost, but it’s actually an optimization that SQL Server undertakes automatically so that it can avoid costly rescanning. If you were to avoid spooling, the cost of the execution … Read more

Linq for NHibernate and fetch mode of eager loading

May 30, 2023 by Tarik

The new Linq provider does it a little differently: var customers = session.Query<Customer>().Fetch(c => c.Orders).ToList(); More here: http://mikehadlow.blogspot.com/2010/08/nhibernate-linq-eager-fetching.html