Anyone have experience in optimizing the database?
Would you just use the tools in SQL maintenance to resize freespace ... reindex ... or have you guys tried something more? I came across a vendor they claim to at least double the speed. I am going to try this and will report back weather or not it worked. If anyone has tips on database optimization other then sw/hw bottlenecks ... but something like rebuilding the indexes .... Macola suggested that we archive the old data we have 6 yrs of stuff in the database but our controller is dead against it.
Would you just use the tools in SQL maintenance to resize freespace ... reindex ... or have you guys tried something more? I came across a vendor they claim to at least double the speed. I am going to try this and will report back weather or not it worked. If anyone has tips on database optimization other then sw/hw bottlenecks ... but something like rebuilding the indexes .... Macola suggested that we archive the old data we have 6 yrs of stuff in the database but our controller is dead against it.