async

External Article

SQL Server's Auto Update Statistics Async Option

  • Article

I have been trying to tune my SQL Server and I noticed a few database settings for statistics. I also read the previous tip on automatic statistics updates. Could you please describe the Auto Create Statistics Async option? How is this configured and when should I use it and when should I avoid using it?

2013-03-26

4,282 reads

Blogs

SQL Server Journey (Part 1)- Enterprise Database 2016

By

Continued thinking about my Journey blog where we have to look back at the...

Announcements from the Microsoft Fabric Community Conference

By

A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...

PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)

By

PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...

Read the latest Blogs

Forums

Identities and Sequences II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Identities and Sequences II

Using PostgreSQL as a NoSQL Store and a Search Engine

By sabyda

Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...

Is Your Time "Free"?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Your Time "Free"?

Visit the forum

Question of the Day

Identities and Sequences II

In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?

See possible answers