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.
28 freelancer bu iş için ortalamada 102$ teklif veriyor
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
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.
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ı
MCITP:SQL Server Database Developer and Administratro. If you can provide any information about the stored procedure I can give you more precise estimates.