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)
-
In SQL Server Integration services, we have Script Component, which can be used in Data Flow Task as Source, Destination or Transformation. ...
-
Recently a new learner of C# asked me a question on C# Virtual & Abstract properties. It turned out to a deep dive. Detail follows. D...
-
I was trying to install SharePoint 2013, the setup was complaining about a pending system restart. Even after multiple restart / Shutdown. ...
No comments:
Post a Comment