Before you read on, know that I am looking for someone who is very familiar with how ERP systems like Oracle and SAP work, and has years of experience working with Microsoft SQL and .NET technologies.
I am looking for an experienced Microsoft SQL Query/Stored Procedure expert to help to tune a stored procedure that is very inefficient. It causes a huge amount of growth in the SQL transaction log file, it timeouts or simply takes way too long to run most of the time.
I am trying to avoid having to use a CLR procedure due to the fact that we need to be able to install it quickly. If you don't know what a CLR procedure is please move on to the next project.
The program has quite a bit of business logic in it which makes the use of indexes and such difficult. It is 640 lines of code presently. I have tried increasing performance by removing all Cursors from the logic and trying to use temp tables with my own indexes (#temp for example). I have greatly improved performance but it's still no where near I think it should be.
I am looking for a long term contact that I can rely on for future tuning as well as new development projects to be written in Microsoft SQL, .NET, and ASP .NET.