Ditutup

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

Kemahiran: SQL, Pelayan Microsoft SQL, Pentadbiran Pangkalan Data

Tentang Klien:
( 5 ulasan ) Craigieburn, Saudi Arabia

ID Projek: #33732811

22 pekerja bebas membida secara purata $43 untuk pekerjaan ini

(131 Ulasan)
7.2
(65 Ulasan)
6.2
(7 Ulasan)
5.4
(35 Ulasan)
5.6
(21 Ulasan)
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 dalam sehari
(20 Ulasan)
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 dalam sehari
(33 Ulasan)
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 Lagi

$25 AUD dalam sehari
(11 Ulasan)
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 Lagi

$30 AUD dalam 7 hari
(6 Ulasan)
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 Lagi

$30 AUD dalam sehari
(7 Ulasan)
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 Lagi

$20 AUD dalam 7 hari
(2 Ulasan)
2.6
(2 Ulasan)
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 Lagi

$150 AUD dalam sehari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
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 Lagi

$69 AUD dalam sehari
(0 Ulasan)
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 Lagi

$20 AUD dalam 7 hari
(0 Ulasan)
0.0
mdyeasinbijoy

I AM Working With MS SQL Database Last 4 Years..... You Need Use STORE PROCEDURE For Solved Your Problem..

$20 AUD dalam 7 hari
(0 Ulasan)
0.0
(0 Ulasan)
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 Lagi

$20 AUD dalam 7 hari
(0 Ulasan)
0.0