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.
Bu iş için 10 freelancer ortalamada $278 teklif veriyor
I have more than 10 years of experience with sql server. I have knowlodge of SAP erp.
Hello, we are the expert team in Asp.net working since 2 years. We will give you your work within your time limit. thanks, md
We must work together on a problem. 2-way communication, I mean. Please check PM.
Hi, we can do it. Please contact me to discuss details
Hi, my specialization is tuning of large databases, vies, procedures, sqlclr procedures.