Latest from the Blog
What About Filtered Indexes?
We would all be happy if tables in our databases only contained the data we need. In reality, we tend to have data that needs kept for legal purposes or “just in case” something happens. Are you querying a table where queries only care about a fraction of the data? When optimizing a query that … Continue reading What About Filtered Indexes?
Auto Create Statistics – Do the Stats Tell the Story?
When we query for data, we don’t always think about the magic that goes into efficiently returning results. One vital piece to this magic is statistics. Statistics in SQL Server are histograms that are used by the query optimizer to determine an optimal execution plan when executing a query. Let’s take a look at the … Continue reading Auto Create Statistics – Do the Stats Tell the Story?
Save Enough Job History Before It’s Too Late
Let’s imagine a scenario. It’s one that I’ve been through and I suspect it’s one that some reading this post have been through as well. You come in on Monday morning feeling good after a relaxing weekend. You check your e-mail and have an alert about a job that failed the previous Friday night. Because … Continue reading Save Enough Job History Before It’s Too Late
- October 2021 (7)
- September 2021 (9)
- August 2021 (9)
- July 2021 (7)
- June 2021 (9)
- May 2021 (8)
- April 2021 (8)
- March 2021 (8)
- February 2021 (8)
- January 2021 (9)
- December 2020 (10)
Get new content delivered directly to your inbox.
