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...

Pretty sure it depends on your data. I recommend posting some sample data, some DDL, and your expected results so we have something to go on and test.

My thoughts, if it isn't the software firewall, do you have a hardware firewall that your IT team needs to configure?

Alternately, it could be a routing problem.  Depending on your...

Might not hurt to check firewall settings.  Could be that something was recently set up (intentional such as something to improve security, accidental such as a GPO that should have...

To add to what Michael is saying, if you DO get results BUT the results are "NULL" (the literal NULL, not a string), then your variable will also come back...

My opinion - storing PDF's in an IMAGE datatype column is just wrong.  Mind you, I try not to use SQL for storing documents in general, but it sounds like...

I would check the error log.  The log is ONLY cycled if you force it to (I believe).  It can be forced with a command or with a restart.  The...

I am pretty sure Javascript is going to give you the same limitation.  Pretty sure that Javascript will need a trigger to tell them to pick 10 or fewer options...

Personally, I wouldn't worry about the javascript part of it.  I would handle it in the TSQL.  Have the TSQL be something like

IF (TooManySelected > 10)
BEGIN
 ...

Since you got no replies, my guess is nobody here has tried it. My suggestion would be to try it out and see if it works like how you expect. ...