Our SQL Server business applications database has many stored procedures which can benefit from non-clustered indexes and rewriting. I need a Microsoft MVP to study the stored procedures and do the needful to speed up retrieval to less than 3 secs. I have identified a list of these stored procedures and can make them available for study.
I have attached an Excel file that gives statistics collected from a live production database. The "last_elapsed_time" column can be sorted to show the stored procedures that took the highest execution time. These would be the ones to target first. I can setup access to the database to those interested. The database is over 25GB and can't be uploaded for review. From the "statement" column one can see that some stored procedures use views. These are also candidates for rewriting. Our target is SQL Server 2008 R2. Please feel free to get back to me with any questions. Thank you.
42 freelancer chào giá trung bình $36/giờ cho công việc này
Hi There Senior SQL Engineer here. I would like to complete this project for you. I can provide you with my certifications as well. Please let me know when your available to discuss further.
George here based from Los Angeles, USA. I am expert in desired skills for this project and have done similar tasks already. Please get back to me, so I can show you some of the work I have done.