Viewing 15 posts - 196 through 210 (of 2,917 total)
if checking for NULL is faster, why not use that combined with if the value is an empty string?
WHERE r.resolution_text IS NOT NULL and r.resolution_text != ''
Same net result without...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 29, 2024 at 5:00 pm
I think it is one of those "it depends" situations.
The cert would need a static name, but the subject alternate names (SAN's) can allow you to use the cert for...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 29, 2024 at 3:52 pm
the $ at the end of the username makes me think that is a local machine account. I'd recommend checking if the SQL services (SSIS, SQL Server, and SQL Agent......
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 27, 2024 at 8:55 pm
heh, so Scott confirmed what I was assuming, but also clarified which way things would go (read from old table, not be a deadlock victim).
But, my advice when questions like...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 27, 2024 at 8:50 pm
The anonymous login is likely due to either incorrect SPN configuration or delegation being disabled. At least that is my guess as we can't see your system.
I suppose the next...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 27, 2024 at 5:54 pm
I could be mistaken, but I am 99% sure that your schema lock is going to prevent the table rename. The rename will only commit to disk after the query...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 27, 2024 at 5:46 pm
Just wanted to add to Frederico_fonseca's reply about pings - pings are not a reliable way to see if a system is up. MOST security experts recommend having ICMP ECHO...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 27, 2024 at 5:40 pm
Another thing it could be is firewalls.
If I am reading things right - pulling data from ERP using SSMS (19) locally works fine, but SSMS (20) from the Azure VM...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 26, 2024 at 8:38 pm
The aliases must be set up client side, not server side. You can set them up server side, but it doesn't benefit the client to have it set up on...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 26, 2024 at 8:26 pm
So it shouldn't need to be set up on the server hosting the SQL instance, just anything that will connect to that SQL instance.
My next thought would be to verify...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 26, 2024 at 7:49 pm
I personally have found that the saved connections are often misleading and I've had them get blown out by updates. I prefer to set up registered servers, specifically a Central...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 26, 2024 at 3:47 pm
Possibly a dumb question but where are you configuring the SQL Aliases? The aliases need to be configured on ALL instances that are going to connect to the server. SQL...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 26, 2024 at 3:41 pm
Just my 2 cents, but this really sounds like interview questions for a consultant to come in and help with.
But to give a quick read on the question, I think...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 26, 2024 at 3:38 pm
As a thought (I could be completely out in left field here), but my GUESS is that your DELETE is because you are removing the data before re-inserting it based...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 19, 2024 at 4:28 pm
Every time I've seen that error it has been either:
A- typo in server/instance name
B- firewall
C- network issues
A is easy to fix - double check the server and instance name (and...
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
August 15, 2024 at 8:16 pm
Viewing 15 posts - 196 through 210 (of 2,917 total)