Sedang Disiapkan

Optimize SQL procedure

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.

Kemahiran: Pelayan Microsoft SQL

Lihat lagi: oscommerce optimize sql, sql procedure return, sql procedure, sql server stored procedure optimization tools, how to improve stored procedure performance in sql server 2012, how to check performance of stored procedure in sql server, how to fine tune a stored procedure in sql server, optimize stored procedure online, how to optimize stored procedure in oracle, how to improve stored procedure performance in sql server 2008 r2, how to troubleshoot stored procedure performance in sql server, sql, database administration, microsoft sql server, database development, database programming, windows server, sql procedure return table, sql procedure convert oracle procedure, convert sql procedure oracle

Tentang Majikan:
( 8 ulasan ) Mornington, Australia

ID Projek: #17200908

Dianugerahkan kepada:

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 Lagi

$25 AUD / jam
(5 Ulasan)
4.3

13 pekerja bebas membida secara purata $25/jam untuk pekerjaan ini

Agiletechstudio

Hi, there i read your initial requirements and i have some question regarding to your sql procedure [login to view URL] can we discuss it on chat ?

$15 AUD / jam
(9 Ulasan)
4.0
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 Lagi

$22 AUD / jam
(3 Ulasan)
4.4
mahmoudgamal008

I have more than 7 years of professional and practical experience in SQL Server and database development. I wrote and optimized hundreds and hundreds of SQL queries. I have more than 1800 answers in Stackoverflow(Q& Lagi

$25 AUD / jam
(9 Ulasan)
4.2
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 / jam
(14 Ulasan)
3.8
AllProgs

Dear, I have extensive experience programming on Transact-SQL (TSQL) and I am a Microsoft Certified Professional (MCP), I can optimize the stored procedures that you have, for this it would require a backup of the data Lagi

$24 AUD / jam
(3 Ulasan)
2.3
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 / jam
(0 Ulasan)
0.0
aam5a07343e1437d

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

$44 AUD / jam
(0 Ulasan)
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 Lagi

$22 AUD / jam
(0 Ulasan)
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 / jam
(0 Ulasan)
0.0
$22 AUD / jam
(0 Ulasan)
0.0
peng72083

Hello. I am very familiar with Query optimizing. I can give you the best result due to my experience and skills in this field. I have worked for Microsoft SQL before. Let's contact each other and make your query fa Lagi

$16 AUD / jam
(0 Ulasan)
0.0
$44 AUD / jam
(0 Ulasan)
0.0