TSQL script advanced techniques

$10-30 USD

Tamamlandı

İlan edilme:

yaklaşık 7 yıl önce

$10-30 USD

Teslimde ödenir

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

Database Programming

Microsoft SQL Server

SQL

Proje No: 12889876

Proje hakkında

16 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 7 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

Seçilen:

@sahilnarain

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 1 gün içinde

5,0

(5 değerlendirme)

3,2

16 freelancers are bidding on average $34 USD for this job

@sumon355

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 1 gün içinde

5,0

(239 değerlendirme)

7,6

@mihaibejenariu

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 3 gün içinde

4,9

(30 değerlendirme)

4,7

@angnut

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 1 gün içinde

5,0

(20 değerlendirme)

4,2

@riveralf

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 1 gün içinde

5,0

(9 değerlendirme)

3,3

@HDDevelopment

Dear , i have experience in SQL server and web development Kindly send me the SP Best Regards, Hassan

$30 USD 1 gün içinde

5,0

(4 değerlendirme)

3,0

@saadq

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 1 gün içinde