Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
1 1 3
Impact
~13k people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Oct
9
awarded  Famous Question
Jan
10
awarded  Notable Question
Jul
2
awarded  Popular Question
Feb
3
revised Why does simple ALTER TABLE command take so long on table with full-text index?
added 2348 characters in body
Feb
3
revised Why does simple ALTER TABLE command take so long on table with full-text index?
added 2348 characters in body
Feb
3
comment Why does simple ALTER TABLE command take so long on table with full-text index?
As per Jason's answer below, I issued the following update instead: ALTER TABLE RespondentData ADD NumericValue bit NULL; GO This finally did execute, but took 29 minutes, 16 seconds!
Feb
3
awarded  Student
Feb
3
comment Why does simple ALTER TABLE command take so long on table with full-text index?
Yes. The results were the same (script runs indefinitely until I cancelled it).
Feb
3
revised Why does simple ALTER TABLE command take so long on table with full-text index?
added 22 characters in body
Feb
3
revised Why does simple ALTER TABLE command take so long on table with full-text index?
added 1571 characters in body
Feb
3
awarded  Editor
Feb
3
revised Why does simple ALTER TABLE command take so long on table with full-text index?
added 952 characters in body
Feb
3
asked Why does simple ALTER TABLE command take so long on table with full-text index?