Skip to content

Opening book details…

About this document

7 Critical SQL 2012 Upgrade Mistakes by Manzoor A. Siddiqui is a document available to read on EtoBox.

The document outlines 7 mistakes to avoid when upgrading a SQL Server database to SQL 2012. The mistakes include: failing to use the SQL 2012 Upgrade Advisor; not reviewing breaking and behavioral changes in documentation; forgetting to execute DBCC CHECKDB WITH DATA_PURITY and DBCC UPDATEUSAGE; not updating statistics with sp_updatestats; failing to refresh views using sp_refreshview; and forgetting to take backups. In addition, the comments note two additional mistakes: not moving to modern hardware if us

Author
Manzoor A. Siddiqui
Language
EN