Viewing 6 posts - 1 through 6 (of 6 total)
Thanks for sharing.
February 14, 2022 at 5:53 am
#3983199
It was an error while creating the temp tbl. this is resolved after I removed the [AccountKey] from insert.
Temp tbl improved the performance in my scenario.
February 14, 2022 at 5:48 am
#3983198
How can I check if stats are update to date..is it by going to table ( expand) statistics folder and see properties? or can I use sample below query? if...
February 1, 2022 at 1:38 am
#3979409
I plan on sharing query so that it helps you advise. Thanks
February 1, 2022 at 1:20 am
#3979407
I looked at it again it seems query was the issue. The CTE was selecting DISTINCT values and joining on TABLE A
In the same query we were doing UPDATE TABLE...
January 31, 2022 at 5:25 pm
#3979272
A cte query which joins couple of tables and then updates is in suspended state. Is it possible it is blocking itself?
SP who is active shows NULL in the blocking...
January 25, 2022 at 8:42 pm
#3977143