Real example #3
Some SQL Server Consulting clients chose to tune databases periodically.
This is one of those clients.
Here is a recent example of performance tuning slow MS SQL Server Stored Procedure.
And here is a capture from SQL Server Profiler to compare BEFORE vs. AFTER tuning results.
How did we do it?
Simple.
Two main things happened here:
1. SQL Cursor changed from Local to Fast Forward (cant replace the SQL cursor, because this is a third party application and we are limited on what we can do).
2. Indexes hint was added to force specific index usage.
That’s it! That simple!