Redundant Query Plan Branches
Consider the following “basic_member” view definition from the Credit database: A simple SELECT from this view returns 8,498 rows and has the following plan shape
Consider the following “basic_member” view definition from the Credit database: A simple SELECT from this view returns 8,498 rows and has the following plan shape
On the week of April 8th, in the MGM Grand in Las Vegas, I’ll be delivering a few sessions at the SQLIntersection conference along with
SQLServerCentral.com just published the following article: Windows Server 2012 Deduplication – Should you use it with SQL Server Backups? This new Windows Server functionality is
My last post about nonclustered Columnstore indexes was written back on February 25th, 2012 (Exploring Columnstore Index Metadata, Segment Distribution and Elimination Behaviors). Amazed by
I’ve had a couple of months at home, focusing on consulting engagements, and now I’m about to enter back in to conference / Immersion Event
In this post I’ll just share the results of a simple set of tests regarding automatic-update sampling. Nothing fancy – I just populated the category
My latest online course, “SQL Server: Troubleshooting Query Plan Quality Issues” was published today by Pluralsight. The short description is as follows… “Learn how to identify, diagnose, and
I’ve been mulling over a potential Microsoft Connect item regarding selectivity guess warnings, but I’m uncertain if it would have enough demand to drive product
My prior post demonstrated the influence of row and page counts on estimated CPU and I/O cost. Now in this post I’m going to step
In this post I’ll step through a few scenarios regarding row and page counts – and their associated influence on estimated CPU and I/O cost.
SQL Server 2008 R2 SP1 and SQL Server 2012 RTM+ includes actual row count statistics in the sys.dm_exec_query_stats dynamic management view. This includes the total_rows,
SQL Server 2012 introduces the new inaccurate_cardinality_estimate extended event, and I had a few miscellaneous thoughts about it that I wanted to discuss on this
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.