Optimize SQL procedure

In Progress Posted 5 years ago Paid on delivery
In Progress

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.

Microsoft SQL Server

Project ID: #17200908

About the project

11 proposals Remote project Active 5 years ago

Awarded to:

vaidyag

HI, I have excellent experience in database programming. I have worked on various databases like Oracle, MYSql, Sql. I have worked on various projects like tuning, writing complex queries , or working on full f More

$25 AUD / hour
(10 Reviews)
5.3

11 freelancers are bidding on average $25/hour for this job

feninsoftech

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

$23 AUD / hour
(26 Reviews)
6.4
Yknox

Dear employer. I am Gang Lee, web developer . I've just read your job posting and I'm very interested. I'm a certificated freelancer with almost 1000 good reviews from clients. I'm a Good ASP.NET , MS SQL , Mean s More

$22 AUD / hour
(7 Reviews)
6.0
Itblast

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 .

$22 AUD / hour
(2 Reviews)
3.3
aam5a07343e1437d

i have good experience with these things, i can do it fast

$44 AUD / hour
(0 Reviews)
0.0
tracygearth

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

$22 AUD / hour
(0 Reviews)
0.0
dkjain1406

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.

$16 AUD / hour
(0 Reviews)
0.0