We had an interesting issue today. We have stored procedure which gets the ids using a CTE and update attributes using the ID. The SP is timing out and when we try to execute the scripts in the sp separately, it worked without timeout issue.
After all the analysis we realized that it may be due to bad statistic issue.
We executed sp_updatestats commend to update statistics. The query worked in no time!
Subscribe to:
Post Comments (Atom)
Engineering Excellence
Engineering Excellence Having solid engineering process and tools in place help to improve the agility of the system. Here is the high-level...
-
Windows 8.1 added with lot of small improvements, this post highlight the Navigation Customization. Right click on Task Bar and bring the P...
-
Engineering Excellence Having solid engineering process and tools in place help to improve the agility of the system. Here is the high-level...
-
Dumeter Netmeter toast.net->Internet Speed Test
No comments:
Post a Comment