Here is my situation.
We are a company that provides software to the Staffing Industry. One of our applications that
queries the database is a Sales Analysis Gross Margin report. Below is a snippet of the SELECT / INSERT (1st snippet). Over the years we noticed some
degradation of the speed of
as the database became larger and larger. Usually we
the query up to 5000 rows of information. The following steps and resources were implemented:
1.) Set up SQL Database Maintenance Plans at the customer site to REBUILD the indexes
2.) Invoke the SQL Tuning and Optimizing Plans through the SQL Server Profiler and Database Engine Tuning Adviser
Based on those recommendations we applied the following Indexes to our Clients Database (see 2nd snippet). The results were spectacular.
Queries that were taking 30 minutes went down to 20-3
View Complete Post