IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Mentioned that
The table needs to remain available during the process. Yes, it would be much better if we could take it offline, but until we get replication/load balancing working, it needs to stay up.
--

Drew
New Confused
Does the table access REQUIRE the index?
New Only if we want it to not suck
This is multiple millions of records, and we're searching on it constantly. If we drop all indices for several minutes while we do bulk updates, it's the same as being offline for that amount of time, isn't it? Unless we're assuming very different things.
--

Drew
New Nope, we are in agreement
Does this work for you?

http://blog.sqlautho...ndex-alter-index/
New That's it
I knew there was a command for it. We'll need to understand the ramifications of course, but that's exactly what I was looking for. Thanks.
--

Drew
New Enjoy
New Not the word I'd use :-D
--

Drew
     Can you temporarily suspend index updates in SQL Server? - (drook) - (11)
         Can you drop the index before the activity? -NT - (crazy) - (7)
             Mentioned that - (drook) - (6)
                 Confused - (crazy) - (5)
                     Only if we want it to not suck - (drook) - (4)
                         Nope, we are in agreement - (crazy) - (3)
                             That's it - (drook) - (2)
                                 Enjoy -NT - (crazy) - (1)
                                     Not the word I'd use :-D -NT - (drook)
         using BulkCopy bcp program? - (S1mon_Jester) - (2)
             oh, and I'd check to see if you could turn replication off - (S1mon_Jester) - (1)
                 This isn't (currently) replicated - (drook)

Out of respect for Apple's good name, this LRPDism has been censored.
45 ms