Need a SQL server DB expert to optimize a stored procedure performace

Completed Posted 1 year ago Paid on delivery
Completed Paid on delivery

We have a stored procedure which is parsing a XML file and inserting and updating a table with more than 25 column which is already having more than 4 lakh record, Procedure is doing its job but it is taking approx. 900ms to just insert or update few records which is too much as large no of records need to be updated, we need an expert who can optimize this procedure to complete the task.

SQL Microsoft SQL Server XML

Project ID: #36252134

About the project

14 proposals Remote project Active 1 year ago

Awarded to:

(33 Reviews)
5.0

14 freelancers are bidding on average ₹8899 for this job

bizmanas

Hi I have 16 years of experience in sql server database development, mysql database development and postgresqldb development. Expert in sql performance tuning. Extensive etl on json and xml data structure. Programming More

₹35000 INR in 7 days
(13 Reviews)
4.6
ashiruddin

I have read your requirement,I am 10 years experienced database optimizer, database developer, designer,administrator,Database Programmer in MS SQL Server , MySQL, I am specialize in database design,analysis, report More

₹2000 INR in 7 days
(11 Reviews)
4.4
Shakerfawzy

Hi, I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions , SAN Storage and Backup Solutions Thank you f More

₹5000 INR in 3 days
(16 Reviews)
4.3
CourserXu

Hello there, I am excited to apply for the job you have posted. With over ten years of experience in Oracle PLSQL, PostgreSQL, MySQL, MS SQL, and other NoSQL databases, I am confident that I have the necessary skills More

₹10000 INR in 7 days
(4 Reviews)
3.0
Peefect

Please share the code, I will do it now Thanks

₹1589 INR in 1 day
(12 Reviews)
3.2
SyedRohaanAlam

Hello, I have more than seven years of experience in the office and more than three years of freelance experience in the required area of work and would like to help you with this task. Thanks for posting in my area of More

₹7000 INR in 999 days
(2 Reviews)
0.9
robartint

Hello I am a professional python developer. My main specializations are automation, web scrapers and bots development. I have already developed over 200 scrapers. From the simplest (for example, a competitor's price More

₹1500 INR in 7 days
(0 Reviews)
0.0
vw7105461vw

Hi, could you share the stored procedure with me? So I could check first how to tune the SP. Please contact me via chat for the details. Thanks

₹12500 INR in 7 days
(0 Reviews)
0.0
heigarp

I have 7 years of experience working in SaaS, I worked on databases like Oracle, Sql Server and Mysql. I believe in my experience to help you. let me look at your stored procedure to see what I can do.

₹10000 INR in 7 days
(0 Reviews)
0.0
meherjagruthi

i constantly look for new ways to improve myself and keep updated.i will be open minded when presenting the ideas by looking pros and cons. and i seek help when needed and do not hesitate to ask any questions

₹6000 INR in 7 days
(0 Reviews)
0.0
niks16

I have 14 years of experience in SQL and .net technologies. Experience in writing complex queries and expertise in optimization of query

₹11000 INR in 15 days
(0 Reviews)
0.0
joseortegasalina

Según mi experiencia y ser considerado para el proyecto te daré unos tips a mejorar 1-Simplifica el código: Revisa tus procedimientos almacenados para asegurarte de que estén lo más simples y directos posible. Reduci More

₹11000 INR in 7 days
(0 Reviews)
0.0