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
22 pekerja bebas membida secara purata $43 untuk pekerjaan ini
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
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.
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