İptal Edildi

SQL Server stored procedure optimization

It's a SQL 2005 database. I need help with the one stored procedure which takes 50-60 seconds to run and needs to be optimized. LEFT OUTER join and CURSOR seem to cause the problem and the stored procedure is pretty complex.

Beceriler: SQL

Daha fazlasını görün: sql server stored procedure optimization, stored procedure optimization, need sql help, stored, sql, database optimization, cursor, optimization database, sql problem, stored procedure complex join, server sql, SQL stored, database procedure, complex stored procedure, 2010 procedure, optimization problem, sql sql, and25g, server problem, stored procedure xml type sql, complex sql, classic asp passing xml stored server sql, save stored procedure tree structure sql, stored procedures sql server multithread, sql procedure

İşveren Hakkında:
( 5 değerlendirme ) Brooklyn, United States

Proje NO: #697970

28 freelancer bu iş için ortalamada 102$ teklif veriyor

ASYanush

Good day! We are the team of developers from Eastern Europe. We can do this job. Thank you!

in 0 gün içinde50$ USD
(1 Değerlendirme)
6.3
AlosDeveloper

Hello, please see PMB

in 3 gün içinde150$ USD
(28 Değerlendirme)
6.1
CodeGuru123

Please let me know the details.

1 gün içinde 100$ USD
(12 Değerlendirme)
6.1
eperfections

Please check PMB.

1 gün içinde 100$ USD
(69 Değerlendirme)
5.9
TakeReal

Hi, I can rewrite your store procedure and make it running faster. Please, check my profile. It speaks for me. -- Sergey aka TakeReal

in 5 gün içinde200$ USD
(179 Değerlendirme)
5.7
tfcarlos

I am a Certified Microsoft Professional MCP ID: 5489671 and i have more than 10 years of experience with SQL Server

in 2 gün içinde100$ USD
(1 Değerlendirme)
4.0
vhrios

SQL expert, I've experience with complex queries (joins, in)subqueries...

1 gün içinde 100$ USD
(1 Değerlendirme)
2.6
DrMDodd

I have worked on SQL Server since 2003 and have progressed to SQL Server 2008. I am aware of the left join issue, especially the cursor issue. I would welcome the opportunity to help you. Kind regards, Martin

in 3 gün içinde95$ USD
(2 Değerlendirme)
2.6
JohnInFL

Please read PM, you will not be disappointed!

1 gün içinde 150$ USD
(2 Değerlendirme)
2.3
freelancerbuzzo

Ready to do this work for you. Check PM, please.

in 3 gün içinde90$ USD
(2 Değerlendirme)
2.0
sorinpohontu

Experienced SQL DBA (admin, setup, maintenante, SP/Triggers coding). I have worked with SQL Server from version 6.5 to 2008. Will need Remote Desktop access and SQL Server Tools installed.

1 gün içinde 125$ USD
(1 Değerlendirme)
1.6
sabypaul

I have good experience in quary optimization. Give me a chance to prove myself.

in 2 gün içinde35$ USD
(0 Değerlendirme)
0.0
benilfreelancer

I have 5+ years sql server programming/performanc tuning experienc.I can do it. Thanks, Benil

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
ToCain

If this is one storedproc only, this can already be addressed within the day even if needs recoding. I would be asking you to submit query execution plans, table properties e.g. Columns, # of rows, keys and indexes. Th Daha fazlası

1 gün içinde 70$ USD
(0 Değerlendirme)
0.0
eliteinfotech

Hello Let me know when we can start this. Please review your PMB

in 2 gün içinde80$ USD
(0 Değerlendirme)
0.0
subhash0277

Hi, I have good deal of experience in MS SQL Data Base [url removed, login to view] i have worked for 3 years in Integrated Land Record Management [url removed, login to view] huge databases.I Specialize in Performance tuning of databa Daha fazlası

1 gün içinde 100$ USD
(0 Değerlendirme)
0.0
DreamCell

Dears, as expert in MSQL Server 2005/2008 & BI, i can help you. Plz Contact for further details. Regards, DreamCell

1 gün içinde 200$ USD
(0 Değerlendirme)
0.0
HollieM

Hello, I am an expert SQL and BI developer that specializes in query optimization. Please contact me and I can have your stored procedure performing excellently. I can provide my resume if need be. Looking f Daha fazlası

in 0 gün içinde60$ USD
(0 Değerlendirme)
0.0
ppap

MCITP:SQL Server Database Developer and Administratro. If you can provide any information about the stored procedure I can give you more precise estimates.

in 2 gün içinde90$ USD
(0 Değerlendirme)
0.0
codeglyph

Hi, check message board please.

in 7 gün içinde200$ USD
(0 Değerlendirme)
0.0