So you want us to guess at the plan and where it goes wrong not seeing missing index, wrong estimations, actual operator costs?

Sorry dude you're better than that and it won't fly with me.

Either give full access to the prod server or post the plans.

Plan C would be to post all the stats using the scripting option with statstream but that's a beast to run on a prod server with larg-ish tables. You might be better off just uploading the actual execution plans 😉

Also it's better netiquette to post the data in this format

http://www.sqlservercentral.com/articles/Best+Practices/61537/

TIA.

P.S. I'll be fetching the page-split / sec and other counters from the SM demo site to site if this idea has any merits (see how I snagged that idea from everybody else too). :hehe: