Find Jobs
Hire Freelancers

Make this SQL query faster

$10-30 AUD

Closed
Posted almost 2 years ago

$10-30 AUD

Paid on delivery
I am using SQL Server 2019 I have an SQL query it takes more than an hour to finish a friend told me this can be improved significantly and finish this query in a few minutes. The query and tables files are in the attachment files end with csv should become a table in SQL there is a function called Dist() and query called [login to view URL] just make an offer if you really can improve significantly and tell me what is the time it will take to run the query
Project ID: 33732811

About the project

21 proposals
Remote project
Active 2 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
21 freelancers are bidding on average $44 AUD for this job
User Avatar
Hi, i have checked your query and data files you have provided. There is good scope for improvement and i can provide the details in chat. Please ping me.
$25 AUD in 1 day
5.0 (51 reviews)
4.9
4.9
User Avatar
Hi , I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an assortment of technologies MS SQL Server 2000/2005/2008/2012/2014/2016/2017/2019, SAN Storage and Backup Solutions Thank you for your time and consideration. Best Regards, Shaker
$25 AUD in 1 day
5.0 (20 reviews)
4.6
4.6
User Avatar
I can do this job in 1 day. I am a well-experienced SQL TSQL developer. I have read your project description with great interests, so that I feel 100% sure on it. I promise A+. I can get started right now and keep your timeline. I hope your kind messages to discuss about this project in more detail. Thanks in advance.
$30 AUD in 7 days
4.9 (11 reviews)
4.3
4.3
User Avatar
I have around 12+ years of professional experience in sql development in oracle/Db2/mysql/sqlserver. I have worked in more than 300 projects. Lets discuss your requirements
$20 AUD in 1 day
5.0 (20 reviews)
4.4
4.4
User Avatar
I have more than 12 years of experience in Oracle/ SQL Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an efficient way. I have very good experience in TSql, writing complex scripts, complex stored procedures, functions, triggers etc. I am good with performance tuning which includes Index and its usages, JOINS, dynamic queries, CTE, Temp tables, Table variable, and all its usages. I am also good and working with big clients for BI part like SSIS, SSRS and SSAS. Created different workflow PACKAGES and reports for clients. I also involved in Data warehouse design form OLTP systems. I have worked with medium to large mission critical databases. Worked as DBA for 24*7 support environment. Involved in activities like Performance monitoring, Log file maintenance, deadlocks and blocking handling, disk space management, Job monitoring and failure handling, Backup and recovery process for disaster management
$30 AUD in 1 day
4.9 (12 reviews)
3.1
3.1
User Avatar
Hi , After reading listed requirements in details, I am placing my bid . Let me know If I can help you. I will summarize all the requirements and will provide you with quality notes. I am a ASP.NET ,.NET Core, .NET Core Web API ,PHP, HTML,C# & .NET MVC, .NET MAUI (App for Windows,android and iOS ) Excel VBA ,Macro and MSBI/SQL Database expert. Experience on Cross platform application development using .NET MAUI. In SQL Server, SQL Server Reporting Services and IIS I have 15 years of experience. I will provide you quality work according to your instructions. please award me the project so that we can discuss it more. Thanks, Gajen
$20 AUD in 7 days
4.7 (2 reviews)
2.5
2.5
User Avatar
Hi, I've read your description carefully. I have full experience with sql server. I've also worked on several similar projects. So I can complete your project with high quality on time. Looking forward to hear more about the project from you via chatting. Thanks & Best regards!
$150 AUD in 1 day
0.0 (0 reviews)
3.0
3.0
User Avatar
I have over 10 years of experience in databases and work with big data architectures. I'm the best for this job.
$20 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi I can upload your commands faster to sql server using SSIS I tried to upload in less than a minute. If you want to know more, you can talk to me. I did your file. Best Regard, Murtaz Kumaritashvili
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Greetings I have worked remotely and I have worked with personal projects with Java and building Web Applications with Spring Boot framework. Also, I have worked with HTML/HTML5, CSS, JavaScript, PHP and MySql/Sql database, MariaDB with XAMPP and React js framework recently. I have built an e-commerce website. Thank you, Anxhela
$20 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I AM Working With MS SQL Database Last 4 Years..... You Need Use STORE PROCEDURE For Solved Your Problem..
$20 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have over than 20 years of experience with SQL queries, any problem that you have with SQL I'll be able to solve it. Besides of that I have data science certificate by Harvard Extension School.
$30 AUD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SAUDI ARABIA
Craigieburn, Saudi Arabia
5.0
5
Payment method verified
Member since Aug 7, 2008

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.