Stats Q&A 2: Updating SQL Server Statistics
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
Menu
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
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
This is tale of troubleshooting… When you unexpectedly or intermittently encounter a change in query performance, it can be extremely frustrating and troublesome for a
I am a HUGE fan of updating statistics as part of regular maintenance. In fact, if you don’t know if you have a step or
This post originally went live on May 11, 2018, but modifications were made on May 14, 2018 after some additional internal discussions with Microsoft. Changes
In last week’s post I discussed the basics of how automatic updates to statistics occur in SQL Server. This week I want to talk about
One of my favorite topics in SQL Server is statistics, and in my next two posts I want to cover how they are updated: either
This week I’ve been working with SQL Server 2016 and it’s been a lot of fun – this is truly a great release from the
A new question on an older post, Understanding When Statistics Will Automatically Update, came in this week. If you look in the comments, you see
This past Tuesday I presented “Statistics Starters” for the PASS DBA Fundamentals Virtual Chapter. You can read the abstract here, and as you may have
In my previous post, SQL Server Maintenance Plans and Parallelism – CHECKDB, we looked at the degree of parallelism used when CHECKDB is run. It
During the PASS Summit in November I presented a session on Demystifying Database Statistics (if you attended Summit but missed it, you can stream it
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.