Troubleshooting Microsoft SQL Server

Blog is a collection of misc troubleshooting tips collected while supporting Microsoft SQL Server 2000, 2005, and 2008. Specialty area covered is SQL Server Data Replication including Transactional Replication, Merge Replication, Change Data Capture, and

Browse by Tags

Tagged Content List
  • Blog Post: Do we need to run UPDATE STATISTICS WITH FULLSCAN

    Auto-Update Statistics For a large majority of SQL Server installations, the most important best practice is to use auto create and auto update statistics database-wide. Auto create and auto update statistics are on by default. If you observe bad plans and suspect that missing or out of date statistics...
Page 1 of 1 (1 items)