All we need is an easy explanation of the problem, so here it is.
Our production server is currently running SQL Enterprise 2017.
We’re paying for software assurance which means we can upgrade at any time.
Should we be looking at SQL 2019?
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
Don’t upgrade just for the sake of upgrading. Upgrade if there are enhancements or features that you’ll get meaningful benefit from.
2017 enters Extended Support later this year, but 2022 will be released this year as well. It’s probably better to let 2022 come out, see how solid a release it is (are there major bugs fixed in the first few CUs?), and then consider your options between 2019 & 2022.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂