Find Jobs
Hire Freelancers

Fix Concurrency in 2 SQL Stored Procedures

$10-30 USD

Closed
Posted over 9 years ago

$10-30 USD

Paid on delivery
I have 2 sql stored procedures that when run repeatedly result in concurrency issues. Both of them are being executed in the scope of a transaction so it just doesn't make sense. I need a sql expert to review them, I have attached them. Basically the Count can go way over 50, sometimes over 100. When UpdateTokenCount is called, the Decrement value is in the range of 0-7.
Project ID: 6234714

About the project

25 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
25 freelancers are bidding on average $28 USD for this job
User Avatar
Hey there, Please attach script. I am certified SQL developer and hopefully I will take care of this immediately. Thanks.
$34 USD in 1 day
5.0 (8 reviews)
4.6
4.6
User Avatar
I'm interested. .
$30 USD in 1 day
5.0 (28 reviews)
4.7
4.7
User Avatar
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around databases and SQL development around (SQL Server ,Mysql ,Oracle ) . My last job was database consultant within Accenture ,for more than 4 years .I worked for several database projects and advanced SQL development on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in database development and SQL to develop all types of requirements related ,and given my experience, I am persuaded to give you High quality of work delivery withing budget and time Best regards,
$34 USD in 1 day
4.9 (15 reviews)
4.6
4.6
User Avatar
Hi I am very interest your problem to solve. Are you using linked server? I am asking because you did not attached the queries. I am ready to start right now and solve this problem. Thanks
$25 USD in 1 day
4.9 (11 reviews)
4.6
4.6
User Avatar
Aucune proposition n'a encore été fournie.
$50 USD in 1 day
4.5 (26 reviews)
5.2
5.2
User Avatar
La propuesta todavía no ha sido proveída
$25 USD in 3 days
5.0 (13 reviews)
3.8
3.8
User Avatar
Hi! I am expert in SQL procedures and have more than 5 years of experience in it contact me so that we may discuss it in more details Thanks!
$40 USD in 1 day
4.5 (4 reviews)
3.6
3.6
User Avatar
I saw you have not attached the script. Can you send the attachment? So I can analyze and confirm to you that I capable. Thanks
$30 USD in 1 day
4.9 (7 reviews)
2.7
2.7
User Avatar
A proposal has not yet been provided
$10 USD in 1 day
5.0 (2 reviews)
1.9
1.9
User Avatar
I am expert of T-SQL please provide the procedures so that I can estimate the time required to fix them.
$22 USD in 1 day
5.0 (2 reviews)
1.1
1.1
User Avatar
Hello. It seems be one of the produces is holding(read, insert, update) the data in a long time that make the data is blocked so that the other is unable to access to the data. Could you attach the sql procedures and share about their execute speed?
$30 USD in 1 day
5.0 (1 review)
0.5
0.5
User Avatar
I have 2.5+ years experience as a Software Engineer in US Based Health Care IT Company. So, I can provide you better solution according to your requirement.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, I had seven years of exp. in Sql server 2000,2005,2008. And also solve tese type of situation many time. Definitely solve this issue on time. need some more info for this. Plz suggest time at which time we discuss it
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
La propuesta todavía no ha sido proveída
$55 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 10 years of experience in Microsoft sql server programing, mainly programing procedures, Performance optimization and handling deadlock issues.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an expert in the development sql server, I understand the problem but I need the stored procedures contained in it is due to changes, additions on the table?
$20 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am an expert in SQL(Having good exposure in Oracle). Can you please attach the procedures so that I can analyze and provide you a fix. Looking forward for your response. Thanks,
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I have 2.5 year experience in asp.net /sql server in sql server many times I have used sp which retrieves very complex result with large number record. So I like in your work.
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
New York, United States
5.0
18
Payment method verified
Member since Jul 9, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.