Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Re building Indexes of sql 2005 database
We have a small sql 2005 database (9Gb), but a couple of tables are under alot of action (for us).
I am interested in re-indexing but would like some real life comments of how to plan, test and impliment a rebuild indexes not just on tables but our main reporting views and of course what are the main pitfalls.
I have a couple of test databases where I was planning to to try this out first and see if the action did improve response time
Do you have a couple of good links to read up on this first
Ian