Recently I came across a user request to create statistics on few newly created indexes. Index names were not provided to use so we had to figure out the indexes created in last 2 days and them create statistics on those indexes.Also, AUTO_CREATE_STATISTICS option was OFF when these indexes were created. I noticed three things [...]
From the category archives:
