Viewing 15 posts - 271 through 285 (of 2,917 total)
To add to the question on losing a connection that may be in a transaction,
We have had site down maintenance and to where the network is just brought down....
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.
April 26, 2024 at 10:13 pm
Something to note - if you HAVE indexed views in place, you can update your queries to use query hints in Standard that will use the indexes on the view....
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.
April 25, 2024 at 7:32 pm
I agree with ratbak here. But I would also like to point out that with so few data points, the estimates are going to be a bit off. But eyeballing...
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.
April 23, 2024 at 7:35 pm
Possibly a silly question but did you set up the SPN's when you installed the new instance?
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.
April 23, 2024 at 5:07 pm
Correct me if I am wrong, but isn't the error a login related issue, not a database related issue?
To me it sounds like the server cert is not recognized or...
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.
April 23, 2024 at 3:24 pm
I think it really depends. Do you know that your disk is going to be the bottleneck? I mean, your approach would make sure the disk is not the bottleneck,...
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.
April 23, 2024 at 2:51 pm
Sounds to me like the certificate chain to identify the server is not valid. This sounds like an SSL issue. I'd reach out to the server team and make sure...
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.
April 23, 2024 at 2:40 pm
I would also like to add that tools will give you a benchmark of how the server performs under load. This is a good benchmark, but if your server doesn't...
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.
April 22, 2024 at 10:18 pm
I'm a mix. SOMETIMES I want silence when I work, sometimes I want music. It depends on the day.
But on average, I prefer music over silence. When I do put...
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.
April 22, 2024 at 9:44 pm
The table will be cleared out before this new process runs, but I do need to process by ID..
Could it multi process the table?
Thanks
I would not recommend "multi-processing" the...
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.
April 22, 2024 at 7:41 pm
Probably a dumb question but did you restart the services after installing the filter pack AND did you install the filter pack on the server (not your local machine)?
Not trying...
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.
April 22, 2024 at 6:31 pm
You can do this however you like. It's your system. You want it batched? then write your code to batch it. You want it to capture failures, toss in some...
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.
April 22, 2024 at 5:09 pm
My opinion - SQL is the wrong tool for the job. I would toss this into a tool that is designed for parsing Office documents such as SharePoint. IF that...
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.
April 22, 2024 at 3:52 pm
Yes, that is what I was saying. Your command for setting the SQL string is wrong.
Again, I STRONGLY encourage you to re-evaluate your solution as I am not sure if...
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.
April 22, 2024 at 2:22 pm
You day it is erroring, what is the error?
Also try printing you dynamic SQL before you run it so you can verify it is what you expect.
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.
April 20, 2024 at 10:29 pm
Viewing 15 posts - 271 through 285 (of 2,917 total)