General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2008
>>>We rebuild indexes daily, but we have a fair amount of CRUD.
>>
>>What is CRUD?
>>
>>>Don't forget about reorganizing indexes. Fragmentation greater than 10% but less than 30% (IIRC) suggests that index be reorganized rather than rebuilt. SQL Server can reorganize indexes without making them inaccessible which means no down time, though I would recommend doing reorgs during off-peak hours.
>>
>>I never rebuilt. I delete them and recreate them from scratch.
>>
>>>SQL Server Enterprise allows rebuilding of indexes while leaving them online for 24/7/365 uptime goals.
>>
>>What do you mean exactly?
>
>CRUD - insert/update/delete operations.
Ahem...
C reate
R ead
U pdate
D elete
;-)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only