Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Frequency of index
Message
 
To
20/03/2014 11:49:54
General information
Forum:
Microsoft SQL Server
Category:
Indexing
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01596908
Message ID:
01596945
Views:
37
>>Should have dropped the R and said CUD - create, update, delete operations
>>
>>Why wouldn't you just rebuild the indexes? What purpose does dropping them and re-adding them serve?
>>
>>Rebuilding indexes with the online option = no downtime:
>>http://www.mssqltips.com/sqlservertip/2361/rebuilding-sql-server-indexes-using-the-online-option/
>
>Rebuilding is not recommanded. I prefer to have it clean whenever I create one.

I have never heard of rebuilding indexes not being recommended. Do you have any good references to support that statement?
Brandon Harker
Sebae Data Solutions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform