I do not have forced parameter turned on. Thank you for your insight. I'm at a loss as well, that is why I posted. The SQL Server...

It probably does have to do with parameterization though, parameter sniffing specifically. I wouldn't be too surprised if the parameterized version was originally run with different parameter values that were...

Here are the row counts for the tables:

item_balances = 7

item_bill_of_materials = 51,855

item_locations = 17,866

items = 22,320

Attached are the scripts to create the tables and views used in the...

Thank you, I will attach the missing information shortly.

I am a professional VB.NET developer and the only limitation that I have yet to find that I have needed is the VB.NET equivalent of the C# yield keyword for...