New Article on SQLPerformance.com: "Avoid HA/DR Solution Self-Delusion"
My sixth guest blog post was published today on SQLPerformance.com: Avoid HA/DR Solution Self-Delusion This article gives a few examples of how we can delude
My sixth guest blog post was published today on SQLPerformance.com: Avoid HA/DR Solution Self-Delusion This article gives a few examples of how we can delude
I had an interesting question yesterday in class about query execution plan control flow (from the root of the plan to the leaf level) and
My fifth guest blog post was published today on SQLPerformance.com: Troubleshooting SQL Server CPU Performance Issues In this post I describe the general framework you
Yesterday Pluralsight published my new course, “SQL Server 2012: Nonclustered Columnstore Indexes”. The intent behind this course was to provide a fast ramp-up on the
In this blog post we’ll explore columnstore index batch execution mode limits. I’m using SQL Server 2012 Developer Edition, version 11.0.3349 (SP1, CU3). To start
There doesn’t seem to be much documentation out on the web regarding the AlwaysOn Availability Group policies and associated conditions that come with SQL Server
My fourth guest blog post was published today on SQLPerformance.com: The Case of the Cardinality Estimate Red Herring This was inspired by a case that
In my post Row and Page Count Influence on Estimated CPU and I/O Cost I demonstrated how I/O cost of a clustered index scan had
Yesterday Pluralsight published my new course, SQL Server: Query Plan Analysis. The short description is as follows: “Learn how to interpret and analyze SQL Server
Chalk this post up as an “exploratory” mission based on the following question… How do I track which LOB pages are associated with a specific
You may have read the blog posts a few weeks ago regarding indexed views and MERGE statement usage and incorrect results. If not, please see the following
This post is based on a question I received last week… If we have a filtered index that was not a match for a query
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.