Mike Gleason jr Couturier
Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
1 4
Impact
~3k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Oct
3
awarded  Notable Question
Nov
5
awarded  Popular Question
Jul
26
awarded  Supporter
Jul
26
comment Large insert/update in table causes timeout while SQL Server re-arrange indexes
Hi, if I manually update the statistics, is the procedure will block any other connections from performing queries? Will they be in a queue until the stats are updated? Or the incoming connection will use the old execution plans? Thanks!
Jul
25
comment Large insert/update in table causes timeout while SQL Server re-arrange indexes
I'll check it out if it helps, thanks
Jul
25
comment Large insert/update in table causes timeout while SQL Server re-arrange indexes
I'll try that, keep you informed
Jul
24
awarded  Student
Jul
23
comment Large insert/update in table causes timeout while SQL Server re-arrange indexes
the timeouts are gone after a few minutes..
Jul
23
comment Large insert/update in table causes timeout while SQL Server re-arrange indexes
"[..] modified table, correct?" Yes :) We don't do anything else. After some more investigations, I think that the server doesn't re-index quickly enough so the queries made on indexed columns (but on the new data) eventually times out. The queries are not returning large amount of data but can be quite complex..
Jul
23
asked Large insert/update in table causes timeout while SQL Server re-arrange indexes
Jul
21
awarded  Autobiographer