Tom Bakerman (9/4/2013)
Sean Lange (9/4/2013)
Start with execution plans. Are they the same?Unfortunately, the named user does not have permission for SHOWPLAN. I won't be able to change that until next week. Is there any reason to suspect they would be different plans?
In theory they should get the same plan but in reality if everything else is the same (query, parameters) then you have to find what is different. Thinking that would be a good place to start. Maybe somebody else has dealt with this issue but I don't remember hearing of it before.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/