Viewing 15 posts - 631 through 645 (of 2,917 total)
If the code is running longer due to waits, I would review which wait is causing the slowest performance of the query and go from there. If it is something...
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.
March 15, 2022 at 3:43 pm
I agree with Grant here - what are you trying to debug with the debugger?
In general, my "debugging" of SQL scripts is to take the UPDATE, INSERT, or DELETE statements...
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.
March 15, 2022 at 3:40 pm
I was just reviewing the link you provided and it basically tells you what to do, just not in plain terms. Basically, determine what is causing the latch, then determine...
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.
March 14, 2022 at 9:36 pm
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...
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.
March 14, 2022 at 3:02 pm
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...
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.
March 14, 2022 at 2:56 pm
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...
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.
March 11, 2022 at 2:46 pm
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...
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.
March 11, 2022 at 2:44 pm
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...
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.
March 9, 2022 at 8:15 pm
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...
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.
March 9, 2022 at 5:52 pm
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...
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.
March 9, 2022 at 5:48 pm
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...
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.
March 9, 2022 at 2:44 pm
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...
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.
March 8, 2022 at 6:59 pm
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...
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.
March 8, 2022 at 2:54 pm
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...
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.
March 8, 2022 at 2:43 pm
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...
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.
March 3, 2022 at 2:56 pm
Viewing 15 posts - 631 through 645 (of 2,917 total)