Closed

Make this SQL query faster

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

Skills: SQL, Microsoft SQL Server, Database Administration

About the Client:
( 5 reviews ) Craigieburn, Saudi Arabia

Project ID: #33732811

22 freelancers are bidding on average $43 for this job

(131 Reviews)
7.2
(65 Reviews)
6.2
(7 Reviews)
5.4
(35 Reviews)
5.6
(21 Reviews)
4.7
TEKSCENT

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
(20 Reviews)
4.4
bhupen2606

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
(33 Reviews)
4.5
Shakerfawzy

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 a More

$25 AUD in 1 day
(11 Reviews)
4.0
ashiruddin

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 you More

$30 AUD in 7 days
(6 Reviews)
4.0
Bhatti1987

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 hav More

$30 AUD in 1 day
(7 Reviews)
2.9
GSingh009

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 More

$20 AUD in 7 days
(2 Reviews)
2.6
(2 Reviews)
0.7
RosrislavStar

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 abo More

$150 AUD in 1 day
(0 Reviews)
0.0
danielreisfl

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 Reviews)
0.0
murtazkumaritas5

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 Reviews)
0.0
Codeitsmarts

I have developed a number of complicated projects related with all of my above mentioned expertise and won the trust of all of my [login to view URL],I have worked on a number of built-in WordPress plugins & API’s and can man More

$69 AUD in 1 day
(0 Reviews)
0.0
shahollianxhela1

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 da More

$20 AUD in 7 days
(0 Reviews)
0.0
mdyeasinbijoy

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 Reviews)
0.0
(0 Reviews)
0.6
arvind11289

Hi Arvind three, I read your job description. I will do your application and provide sufficient work within your estimated. I have 10+ years experience in asp. Net technology. I have last 5 years to work with. Net cor More

$20 AUD in 7 days
(0 Reviews)
0.0