Find Jobs
Hire Freelancers

TSQL script advanced techniques

$10-30 USD

Opravljeno
Objavljeno pred približno 7 leti

$10-30 USD

Plačilo ob dostavi
I have a stored procedure that carries out 4 separate INSERTs into 4 different tables. The issue is that 2 of these tables frequently have other locks on them which means that the tables are locked and the INSERT has to wait; so the entire storedprocedure takes a long time to complete. I want to decouple these two INSERTs, so if these 2 are blocked the stored procedure still continues. I want to do this with minimal changes to the stored procedure as it passes input parameters. I was thinking of using dynamic SQL and passing out these INSERTS with either xp_cmdshell and sqlcmd to create a new session (decouple) or uise sp_executesql or exec to do the same. Need assistance from a more experienced TSQL programmer. Thanks
ID projekta: 12889876

Več o projektu

16 ponudb
Projekt na daljavo
Aktivno pred 7 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
Dodeljeno:
Avatar uporabnika
I have 3 years of professional experience as a database developer and admin while I was working with IBM. What you're trying to do can be implemented by a service broker, I'd recommend it over dynamic SQL statements, because they'd still be executed synchronously and would wait. I could help you with this in a better way if I could take a look at the SP. Hoping to hear back from you soon! Regards, Sahil
$83 USD v 1 dnevu
5,0 (5 ocen)
3,2
3,2
16 freelancerjev je oddalo ponudbo s povprečno vrednostjo $34 USD za to delo
Avatar uporabnika
Hello, As an expert in writing complex sql queries, i am very much interested to assist you with the issue you described, plz let me know if you are interested. Thanks
$42 USD v 1 dnevu
5,0 (239 ocen)
7,6
7,6
Avatar uporabnika
Hi, I am interested about this assignment, hoping that I can achieve it taking into account my experience in software development using .NET and SQL Server. More info about me: - 12 years' experience with SQL Server including T-SQL development, performance tuning, ETL and database design - 4 years as Technical Manager / Manager - 3 years of international experience working at the client premises (France, Austria, Luxembourg, Italy and South Africa) - 6 years experience working as freelancer - 10 years’ experience using .NET / C# developing desktop and web applications Thank you for your time and consideration. Kind regards, Mihai Bejenariu
$20 USD v 3 dneh
4,9 (30 ocen)
4,7
4,7
Avatar uporabnika
Hi, please send me the stored procedure. I can work to you now (in the morning and in my evening): I live in Italy. Have a nice day. Angelo
$55 USD v 1 dnevu
5,0 (20 ocen)
4,2
4,2
Avatar uporabnika
Hello, I am a very experienced database administrator and TSQL developer, with Microsoft certifications as DBA that support my knowledge and skills, I can ensure you high quality on my duties. I am capable to figure out where the bottleneck is and how to fix it to provide you the best solution for your "blocking issue". Regards, LFR
$25 USD v 1 dnevu
5,0 (9 ocen)
3,3
3,3
Avatar uporabnika
Dear , i have experience in SQL server and web development Kindly send me the SP Best Regards, Hassan
$30 USD v 1 dnevu
5,0 (4 ocen)
3,0
3,0
Avatar uporabnika
Hello, This task is very easy for me since I have got the experience and expertise in writing complex TSQL scripts. Please feel free to contact me regarding any query related to this work. Thanks
$20 USD v 1 dnevu
4,7 (7 ocen)
2,5
2,5
Avatar uporabnika
hello, i have more than 8 years of experience in sql server 2000 to 2014 writing T-Sql quirues and stored procedures thanks
$25 USD v 0 dnevu
5,0 (4 ocen)
2,1
2,1
Avatar uporabnika
hi, share details
$35 USD v 1 dnevu
5,0 (1 ocena)
2,0
2,0
Avatar uporabnika
Experience of more than 10 years in Data warehouse with exposure towards Big Data & Data Science. SQL,Oracle,Sql Server
$50 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
A proposal has not yet been provided
$25 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava UNITED KINGDOM
London, United Kingdom
5,0
32
Član(ica) od jul. 15, 2005

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.