Adding a clustered index to a SQL table: what dangers exist for a live production system?
- by MoSlo
Right, keep in mind i need to describe this by abstracting all possible confidential info:
I've been put in charge of a 10-year old transactional system of which the majority business logic is implemented at database level (triggers, stored procedures etc). Win2000 server, MSSQL 2000 Enterprise.
No immediate plans for replacing/updating the system…