Optimize SQL procedure
$15-25 AUD / hour
I currently have a couple of Microsoft SQL procedures that was written for me and although it works it takes an extremely long time to run 1+ hour. It is a repetitive script that does a lot of checking through though a long table 12M records. I believe I have optimized indexes but think the task could perhaps be optimized by breaking the search down into 'chunks' (Bottle neck is single processor threads) Hardware is OK.
Project ID: #17200908
About the project
11 freelancers are bidding on average $25/hour for this job
Hi, I have 10 years experience in SQL server and involved in designing databases, performance optimization. I have expertise with optimizing queries by reviewing joins and indexes. Thanks
I am very Expert in Microsoft SQL Server Yes i am ready to do Microsoft SQL procedures that was written for me and although it works it takes an extremely long time to run 1+ hour please contact me back .
Need to re structure the sql procedures and then threading on calling in c#. or if stored procedure is executed in using sql then need to find ways of SQL server feature like parallel que More
I have great experience in SQL Server and data warehouse projects, worked on reports for many years on the basis of SQL Server database. Working on reports is self explanatory, I used to write optimized queries.