Use the highest database compatibility level - AWS Prescriptive Guidance

Use the highest database compatibility level

Check to make sure that you’re using the current database compatibility level to take advantage of the latest improvements in SQL Server. This is important to check because when you restore a database from a lower version to a higher version, it will keep the compatibility level of the lower version. Some of the latest database enhancements are effective only when you set database compatibility to the most recent level available for the engine version you installed.

To check the current database compatibility use:

$ select name, compatibility_level from sys.databases

For more information about database compatibility levels, see the Microsoft SQL Server documentation.