Try dbcc dbreindex

This is just a comment. The first thing to do is reading your company service level agreement. This agreement should contains lower limit to acceptable perfomance. If the system already...

There are other issuee which are

1. transparancy

2. scalability

3. bussines rule enforcement

with sp you can tackle all of these issues in one time. It's killing 3 birds with one stones.

an example...