Query takes too long to complete

Nadir 2014-12-24 17:09:19

SQLkiwi 2014-12-25 05:35:35
Is it possible to provide a post-execution plan? Ideally with the statements run directly from Plan Explorer?
Nadir 2014-12-30 16:52:17
Aaron Bertrand 2014-12-30 19:11:20
This plan wasn't generated by running the query from inside Plan Explorer, so it is missing a lot of key metrics like duration, reads, table I/O, etc. Any chance you could provide that?
SQLkiwi 2014-12-31 13:25:26
That plan still only has estimated numbers. Run the query from Plan Explorer, or at least turn "Actual Plan On" in SSMS and capture the plan from there.