111 reputation
14
bio website blog.mikecouturier.com
location Montreal, Canada
age 35
visits member for 4 years, 5 months
seen yesterday

Senior front-end developer at joinbunch.com


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