Updating sql 2016 name
Foreign keys provide referential integrity between tables, ensuring that write operations on either do not render the related columns orphaned.
With SQL Server 2016, we are promised a new operator that will make checks such as these more efficient and better documented.
Also, you need to follow the steps for each SQL Server instance on the machine.
SQL Server 2016 includes a variety of query optimizer enhancements.
Prior to SQL Server 2016, running a database in a previous version’s compatibility mode had no guarantees with regards to the behavior of the query optimizer and the executions plans it generated.
Starting in SQL Server 2016, Microsoft guarantees that new query optimizer improvements will only be available in compatibility level 130.
Here’s a brief list with a bit of detail: These changes are almost exclusively enhancements—each improving how execution plans or statistics are managed or adding parallelism into plans that previously could not benefit from it.