Find Jobs
Hire Freelancers

SQL Server stored procedure pivot performance problem

$10-30 USD

Opravljeno
Objavljeno pred približno 5 leti

$10-30 USD

Plačilo ob dostavi
I need to pivot 4 columns in 180 rows to a result set, so 720 columns. I'm running into a performance problem. Can you do this pivot with a stored procedure in under a few seconds? It is taking around 30 seconds on average now. Please take a look at the attached stored procedure before bidding!
ID projekta: 18783951

Več o projektu

11 ponudb
Projekt na daljavo
Aktivno pred 5 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
Hello, MCT Trainer, consultant & sql server administrator, and MCSA SQL Server, 20 years of experience in Visual Basic and Microsoft SQL Server, IT project manager in a software development company, Programmer oracle forms reports, PL / SQL, Transact-SQL expertise for SQL Server, Cordially Med. MESTIRI [login to view URL] Bonjour, MCT Trainer, consultant et administrateur de serveur SQL, et MCSA SQL Server, 20 ans d'expérience dans Visual Basic et Microsoft SQL Server, Chef de projet informatique dans une entreprise de développement de logiciels, Rapports de formulaires Oracle Programmer, PL / SQL, Expertise Transact-SQL pour SQL Server, Cordialement Med. MESTIRI [login to view URL]
$25 USD v 1 dnevu
5,0 (8 ocen)
3,2
3,2
11 freelancerjev je oddalo ponudbo s povprečno vrednostjo $34 USD za to delo
Avatar uporabnika
Hello, As an expert in ms sql server, i am very much interested to do this project. I checked your current query and i understand that it will really take time to execute this! I can optimize this, not sure how much time will be reduced after optimization, i am sure i can optimize it for better performance for speed. Thanks
$50 USD v 1 dnevu
5,0 (239 ocen)
7,6
7,6
Avatar uporabnika
Hi I am a database expert with 12 years experience in handling MS SQL and MySQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. I have worked with several ERP databases to write queries and procedures to create custom reports. The slow query could be either due to a badly written query or due to the lack of proper indexing or a genuine delay due to huge volume of data. I would like to do some trial and error, try various options and see if the performance can be improved, without changing the functionality of the script. Is it possible to share the backup of the database, so that I can try it on my PC. If backup is not possible, an export of the tables involved also will be fine. Look forward to hear from you. Thanks Roni
$50 USD v 1 dnevu
5,0 (77 ocen)
6,4
6,4
Avatar uporabnika
yes. I can do. Need 2 hrs time to fix you performance issue. I may achieve the same functionality with same result in different way. But this will be done. I am sure it will be more than 50% performance gain. But once I will see the query then only I will be able to tell you how much we can achieve performance.
$25 USD v 1 dnevu
5,0 (14 ocen)
4,5
4,5
Avatar uporabnika
HI i have made lot of pivot in my organization . ping me where you stuck and ur problem with that so that i coul help you and fix ur requirement. i will make optimizations and work with ur requirement
$66 USD v 1 dnevu
4,9 (17 ocen)
4,4
4,4
Avatar uporabnika
I checked your SP and found that there are so many sub query. I can fix your problem but I need DB design and some sample data with required output. So kindly provide above things to complete your task ASAP. Please message me to start your work. Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 9.3 years experience in MS SQL Server and 6.5 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when we will start. Sky pe jikenjd
$30 USD v 0 dnevu
5,0 (22 ocen)
4,1
4,1
Avatar uporabnika
i have more than 6+ experience in sql server (store procedure, view, trigger ,indexing, union and joins) to manage the complex data and processing.
$30 USD v 1 dnevu
5,0 (2 ocen)
0,4
0,4
Avatar uporabnika
Hi. I can just did this 4 u :) . .
$35 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
I would love the opportunity to try and assist you here. I’m a Microsoft SQL Server Certified MCP DBA & Developer with a passion for BI and Data. Experienced Sql Server Consultant with a demonstrated history of working in the information technology and financial services industry over the last 12 years. Skilled in Advanced TSQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Migration, Data Warehousing, Powershell Scripting, as well as a strong aptitude in C# .Net and Object Orientated principles. Proficient information technology professional with a Bachelor of Science - BSc. focused in Computer Science I am an Experienced Sql Server Consultant with a demonstrated history of working in the information technology and financial services industry over the last 12 years. Skilled in Advanced TSQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Migration, Data Warehousing, Powershell Scripting, as well as a strong aptitude in C# .Net and Object Orientated principles. Proficient information technology professional with a Bachelor of Science - BSc. focused in Computer Science
$15 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Dear Sir , I have 20 years of experience in BI Analytics and Data Integration . Expert level work experience in SQL and PL/SQL in various database like Oracle , SQL Server , MY SQL , Teradata etc . Good exposure in Database tuning and application tuning . If you think I can help you then kindly let me know . Regards , Goutam Sahoo
$25 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava CANADA
McKinney, Canada
5,0
57
Plačilna metoda je verificirana
Član(ica) od mar. 20, 2007

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.