Ditutup

MSSQL SERVER OPTIMIZE STORED PROCEDURES PERFORMANCE

I use MSSQL Server 2019. Some of my stored procedures are slow. I need them to be optimized and execution time should be reduced > 50%. If you are an expert at Stored procedures and how to optimize them, we are interested. I have close to 500 stored procedures to optimize. Each SP is about 1000 lines. Minimum requirement is expertise in MSSQL server SPs for 8 years.

Kemahiran: Pelayan Microsoft SQL, SQL

Lihat lagi: sql server 2005 stored procedures, mssql 2008 stored procedures, mssql stored procedures zip radius, copy stored procedures mssql 2000, search stored procedures sql server 2000 search, sql server stored procedures copy data table, mssql writing stored procedures, mssql search stored procedures, convert stored procedures mssql oracle, sql server 2000 copy tables data stored procedures, stored procedures sql server multithread, mssql stored procedures oracle conversion, mssql stored procedures oracle converter, sql server 2005 search stored procedures, mssql stored procedures copy, send mssql mail 2008 stored procedures, hidden stored procedures mssql, freelance work writing sql server stored procedures

Tentang Majikan:
( 21 ulasan ) San Diego, United States

ID Projek: #22876677

57 pekerja bebas membida secara purata $34/jam untuk pekerjaan ini

sumon355

Hello, As an expert in MSSQL and optimizing stored procedure, i am very much interested to work on this project. Is it allowed to do any changes in the related tables like adding indexes? Let's discuss more in detail. Lagi

$34 USD / jam
(237 Ulasan)
7.6
leadconcept

As per my understanding, MSSQL stored procedures are to be optimized to gain better execution time. Kindly let us know the detail of a sample stored procedure so that we may know the complexity of the optimization? L Lagi

$30 USD / jam
(15 Ulasan)
7.3
NallakumarKC

Hi, I am Nallakumar. I have more than 12 years of experience in MS SQL SPs, Indexing etc. I can make the SPs optimised without compromising existing logic. Slowness may related to the loops, conditional statements or Lagi

$25 USD / jam
(60 Ulasan)
7.1
bmartynvw

Hi, My name is Benjamin. I'm an expert solution architect and developer with over 14 years of experience. As a Microsoft certified expert, I have helped many enterprises optimize their SQL procedures.. I can ensure h Lagi

$45 USD / jam
(11 Ulasan)
5.4
paskal77

Hi, I can help you by refactoring T-SQL in stored procedures. I would like to talk to you by chat Experience to apply: Microsoft platform: Language: VB.NET / C # ASP.net / Web Form - / MVC MySql Server / SQL Serve Lagi

$30 USD / jam
(51 Ulasan)
5.5
dhanuitdevendra

Hello, Hope you are doing well! I can help you as a Database Developer. Please visit [login to view URL] for details. Please have a look at our existing cus Lagi

$35 USD / jam
(7 Ulasan)
5.4
intemo

Hi! I offer you my skills for your task. I have long term (12+ years) for working with MS SQL SERVER (starting frrom MS SQL SERVER 2000) as admin and as developer for T-SQL (stored procedures, triggers, user functions, Lagi

$33 USD / jam
(43 Ulasan)
5.4
shobhitpundir

Hi There, You have a massive DB with 500 SP. I'm sure you knwo teh common problems associated with SP performance to look for 1) Reindexing of tables. 2) Create views in case there are more joins 3) Use No Lock I Lagi

$25 USD / jam
(12 Ulasan)
5.2
dogradiwakar

I am a microsoft certified BI developer with 10 + years of experience of working with ETL and BI tools such as SSIS , SSAS , Azure ETL , Pervasive , Informatica , castiron , SAP Bods , SAP BO , OBIEE etc .

$38 USD / jam
(3 Ulasan)
4.9
IMExpertEngineer

Hi, I'm exper sql server DBA and been working in sql server since 2005 and I've done lot of stored procedure optimization in past. I can work on this project and fix your issues. Could you tell me what's the size of Lagi

$38 USD / jam
(9 Ulasan)
4.8
AliSafder

Hi, My Name is Ali and I can work on it with immediate availability. I am expert in Optimization of queries, Stored Procedures and Functions with 11 years of experience. See my portfolio for reference. Let's have qu Lagi

$30 USD / jam
(31 Ulasan)
4.7
WhizPool

Hello, I have been working as a consultant for 6 years now, primarily their database migration from Oracle to SQL server. I have experience of optimization as well as maintenance. How about, you give me 1 stored proc Lagi

$45 USD / jam
(3 Ulasan)
4.8
juaninfante

Hi, I have worked as a database administrator for 5 years. Responsible for tasks of optimization of stored procedures, optimization of disk space used by tables, maintenance of log file. I worked with SQL Profile and a Lagi

$40 USD / jam
(1 Ulasan)
4.3
dreamci

Hi! I have more than 15 years development experience and a great team, we can complete your project with clean code and best practices Please check my profile and message me for more details. Thanks!

$50 USD / jam
(6 Ulasan)
3.8
harihut

Hello Sir , I am core SQL Server DBA with 10+years of experience .My main area of expertise is query tuning . I will optimize all your stored procedures to make it run super fast. I have worked primarily for Banking Lagi

$25 USD / jam
(9 Ulasan)
3.6
thampl

Hi there, I'm senior database developer with 12 years experience. I'm ready to optimize one Stored Procedure for free to prove my skills. Kind regards, Tom

$38 USD / jam
(4 Ulasan)
3.5
mozammalidbctg

Hi, I am experts in .Net, .Net Core,C#,Vb,Windows application,Asp.net Web Forms, MVC,Boilerplate,NopCommerce,WCF Service, Web Service, Android &IOS ,Web API,AngularJS,MSSQL,MySQL,PostGreSQL,Crystal report ,Krypton To Lagi

$25 USD / jam
(3 Ulasan)
2.6
SqlDevelopment

I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday Lagi

$33 USD / jam
(5 Ulasan)
2.7
WeazenSoft

Dear Prospect Hiring Manager, After a full understanding of your project description, I can say I could help you with strong interests and desire. I am a serious bidder here and i have already worked on a similar p Lagi

$44 USD / jam
(4 Ulasan)
2.7
aramgev

Hi I am SQL expert, have expereince of queries and stored procedures optimization. I also have Microsoft Certificate for SQL Server exam. If you award this project to me I'll be glad to help you

$38 USD / jam
(1 Ulasan)
2.9