CopyPaste.Net

The copy-pastes and explanations blog for SQL code, errors and daily cases! This blog is a 'list' of actions that always good to have available. The copy-paste concept here is short and clear explanations and descriptions (no long stories!) and - of course - the code to take (copy) and use (paste). The blog deals in the database (mostly) and software issues.

Blog Pages

▼

Force statistics update - WITH FULLSCAN

SQL Server automatically update statistics according to few rules.

In order to force statistics update (even when SQL Server rules are not met) - use WITH FULLSCAN.

UPDATE STATISTICS TABLENAME WITH FULLSCAN

Note: sp_autostats doesn't force the statistics update.

itaigitt

Share

No comments:

Post a Comment

‹

›

Home

View web version

itaigitt: SQL Server DBA. More than 10 years of experience in SQL development and design. Project Manager and Programmer, with over 5 years of experience in software development, software design and project management. BSc in Computer Science and Mathematics, MBA in Business Management.

View my complete profile

Powered by Blogger.