Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

There are potentially significant performance improvements to be made by making sure the compatibility level of your database matches that of the SQL Server version. When you restore a database from an older version of SQL Server to a newer version, by default the restored database has the compatibility version set to the older SQL Server version. It is recommended to change thisthe compatibility level of the database to match that of the SQL Server version.

 

Step-by-step guide

Warning
titleSQL Advanced programming skills required

This tasks needs advanced SQL programming skills.

...