Would like to know how to identify the problem node from the HTML query plan:
file-001.png
How can we fix Generated result rows vs Estimated result Rows big difference.
Est. temp space used and Act. Temp space used also having big dif...
Hello, Do we have an option to find out the session which is utilizing the highest CPU? or do we have an option to limit the number of cores for a user?
@Mark, Thanks for your advise. Need one more help; As per the following query the join is retuning many to many in the query plan since it has to fetch the latest record from both the tables. The cost of join also very high; can we extract the lates...
@Bart, We had calculated and reaching around 1684bytes but the update failed, definitely there will be some offset values how do we calculate?don't you think is this a basic requirement? At a time we should be able to calculate a particular rows size...
Hi Bart, The server page size is 2k and the error was Attempt to update or insert row failed because resultant row of size 1964 bytes is larger than the maximum size 1962 bytes allowed for this table.I do understand it is a limitation; how can we che...
