Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reindexing
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01529215
Message ID:
01529235
Vues:
37
>>>>>Yes, if your SQL Server is one of the listed. But this is still not recommended.
>>>>
>>>>Ok where are you seeing that its not recommended ?
>>>>
>>>>I haven't been able to find a reference to best practise about this.
>>>
>>>I believe I read this in many threads in Transact SQL forum at MSDN and could have read in other links as well.
>>
>>So its hearsay ?
>
>We never disconnect users before rebuilding indexes. We run SQL Server Standard edition. Doing a rebuild causes the equivalent of a file lock (if I remember right), however, so long as the rebuild occurs quickly this hasn't been an issue for us. We only rebuild when fragmentation > 20%, otherwise we do a reorganize which doesn't require a file lock.

It sounds like you may be one of those Jack of all trades guys ;-) Hats off to you but I am happy being just a developer. The less I have to mess with the system side of databases, OSes, and networking, the happier I am. I can muddle through when necessary but for me it's scut work.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform