Performance Issues
2017-05-08 10:42:43
ny sugestions to improve peroformance ?
Thanks
Aaron Bertrand 2017-05-08 18:33:22
There are some things here that I'm not sure you can make better – parsing JSON, for example, there is no magic in SQL Server 2014. I would start by getting rid of the table variables. For better input, please generate an actual plan from within Plan Explorer – this will add runtime metrics and other data you don't get when you open a plan generated in Management Studio (especially an estimated plan).
2017-05-09 07:25:21
Hi,
thanks for the feedback.
i've attached the plan (XML)