As a GUESS, I would say that since the problem occurs during busy times on the server, it is LIKELY contention on the log file.  Too many things are writing...

Just to counter-point Ant-Green's suggestion of 2019/2022, I would review what OS version you are on and make sure that the SQL version you upgrade to is supported at the...

I am a little confused about what you are trying to do, but if I understand right, you want to have the report sent out on an email BUT you...

Offhand I don't, BUT I would be cautious of free services.  ANY company that offers a free thing is either losing money on it OR has other ways to make...

Spot on Jeff... I never think to check the profile before replying...

Seeing something like "gemini support team" in the profile then seeing a question posted that doesn't seem to make...

My opinion - I would NOT have modified any upgrade related scripts or any scripts created and provided by Microsoft.

I would follow the same advice that I gave originally:

I would...

My opinion - that is hard to say on a forum post as we have no access to your data or your data structures.  My question to you would be...

I don't think there is enough to go on based on what you wrote.  Plus, what you wrote does not look like TSQL; it looks more like .NET.

So, if you...

My opinion - before making a linked server, find your bottleneck.  If the bottleneck is the network, the linked server is not going to make things any faster.  It will...

Without knowing your setup (hardware side), I would say get a faster network connection.  Transferring 80 GB in 15 hours is just over 5 GB per hour, which is 0.08...

My opinion, I wouldn't be modifying the SSIS package to enable and disable portions of it as things complete (success or failure).  I would have multiple SSIS packages to handle...

I am really confused about what you are asking.... in your expected output, you have 4 columns, yet in your final SELECT you have 6.  So right away, I can...

First thing I notice is that your code for a new user is not using AD.  You'd want a "FROM WINDOWS" not "WITH PASSWORD" for using AD.

Next, if I am...

Since the SELECT takes 11 minutes like the UPDATE, it sounds to me like the data lookup process is what is so slow.  I would look at your execution plan...

aaradhya - I think the app is DOA.  Looking at the link, they have had 10 downloads and it hasn't been updated since December 2020 and personally, I think the...