Viewing 15 posts - 916 through 930 (of 2,917 total)
I think this really falls under "it depends".
Are you already licensed for 2019 (ie do you have software assurance OR do you need to buy 2019)?
Are there features in 2019...
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.
October 4, 2021 at 10:06 pm
I rarely do an uninstall. What I do when I decommission a SQL instance is to stop the services and change them to disabled. I've had odd hiccups when doing...
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.
October 1, 2021 at 9:54 pm
I agree with Grant here, and would like to add that you miss 100% of the chances you don't take.
I know in my organization, once a product hit a certain...
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.
October 1, 2021 at 9:01 pm
First thing, posting an Oracle question in the SQL Server 2016 forum section is likely not going to get many results (if any).
Next, I am confused why you posted here...
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.
September 30, 2021 at 10:35 pm
This is a multi-step process and depends on your requirements, but one approach would be to use what you have but turn the AVG into a windowing function and store...
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.
September 30, 2021 at 10:27 pm
On top of books, it may be beneficial to take some training courses. There is a LOT of training available out there.
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.
September 28, 2021 at 5:50 pm
To add to what Grant said, I had a similar introduction to my DBA role. I found a company that did work I was interested in. They were not hiring...
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.
September 28, 2021 at 4:25 pm
So to confirm - the problem is resolved by turning off XACT_ABORT? That is a new one for me, but good find!
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.
September 21, 2021 at 2:21 pm
I would like to counter burke.marg's comment about peak performance being more important than readability. My opinion, readability is the most critical piece of the puzzle. If I need to...
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.
September 20, 2021 at 5:10 pm
as a wild thought - have you tired casting the credentials to the appropriate datatype?
Looks like you may need to do something like this:
https://gist.github.com/Jaykul/81fd8ee55ce4df656d36d23e59788151
The above is a powershell script to...
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.
September 20, 2021 at 4:37 pm
To add to what Jeff says - just because the standard definition is X, doesn't mean that company Y will follow that. For example, I was a DBA by title,...
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.
September 20, 2021 at 4:19 pm
I think when you say "lean" you really are referring to normalized, and I do recommend normalizing tables that have a high number of write operations.
Tables with high number of...
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.
September 20, 2021 at 2:51 pm
Without seeing your setup, the full text of the error message, or knowing anything about the setup, I am making a LOT of assumptions below.
But if I remember right, error...
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.
September 17, 2021 at 8:48 pm
I don't see why you couldn't capture the data with XE. Create the XE session to capture the data you want, have it save it to file or table 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.
September 17, 2021 at 8:41 pm
I thought it was a joke, but I've learned (the hard way) to never assume that people are joking 🙂
And I think you should be good to go then! Good...
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.
September 17, 2021 at 3:21 pm
Viewing 15 posts - 916 through 930 (of 2,917 total)