Friday, September 11, 2015

SQL Server - Queries, Views or Stored Procedures run slow after upgrade

Read this article

http://thomaslarock.com/2014/06/upgrading-to-sql-server-2014-a-dozen-things-to-check/


DBCC CHECKDB WITH DATA_PURITY;
DBCC UPDATEUSAGE(db_name);
EXEC sp_MSforeachtable @command1='UPDATE STATISTICS ? WITH FULLSCAN';

No comments:

Post a Comment