Last week I presented a session, Demystifying Statistics in SQL Server, at the PASS Community Summit, and I had a lot of great questions; so many that I’m creating multiple posts to answer them. This second post is dedicated to questions specific to updating statistics in SQL Server. Of note…I have a couple previous posts which also include helpful information:
SQLskills SQL101: Updating SQL Server Statistics Part I – Automatic UpdatesSQLskills SQL101: Updating SQL Server Statistics Part II – Scheduled UpdatesQ: If we have both update statistics and updatestats asynch set to true, what happens?They are both in effect, it