Where are you thinking about doing the upgrade of sql server 2008 (SP4) Enterprise Edition 64 bit A Sql server 2016 ???. We have a DWH and I would like to know what I need to know for migration, compactibility of versions between the two.
I await your prompt response. Thanks in advance.
You should also look for syntaxes that would no longer be valid in a migration link
For its part I recommend you to have a testing environment where you can enable the QueryStore and compare your queries at a previous compatibility level versus 2016. This to see how you have the new cardinality estimator.