Viewing 15 posts - 631 through 645 (of 2,904 total)
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...
February 18, 2022 at 7:34 pm
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...
February 18, 2022 at 2:26 pm
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.
February 17, 2022 at 9:42 pm
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...
February 17, 2022 at 2:22 pm
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...
February 16, 2022 at 9:18 pm
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...
February 16, 2022 at 2:26 pm
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...
February 10, 2022 at 8:19 pm
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...
February 10, 2022 at 2:44 pm
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...
February 9, 2022 at 3:28 pm
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
...
February 8, 2022 at 10:05 pm
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. ...
February 8, 2022 at 9:11 pm
Just to step back a bit - you indicated that you have 1 SQL instance per VM and the ones without AG's are working fine, but everything in an AG...
February 8, 2022 at 7:37 pm
The error from Chome should tell you that things are not set up properly.
My GUESS is you didn't add a script map for the PUMP dll. You didn't list that...
February 8, 2022 at 5:05 pm
Licensing is a question best answered by your licensing provider. Forum answers are going to be guesses based on what WE have seen, and you may have some deal with...
February 8, 2022 at 5:01 pm
My opinion - blocking outgoing traffic is only required if there is a risk of the server being compromised. If you can download and install arbitrary applications on the server...
February 7, 2022 at 3:01 pm
Viewing 15 posts - 631 through 645 (of 2,904 total)