Are Filtered Statistics Useful with Parameterization?
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
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
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
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
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
My third guest blog post was published today on SQLPerformance.com: TRANSACTION_MUTEX and Multi-Session Transaction Access This is related to a recent SQL Server instance I
Last Thursday I presented a session at the PASS Winter 2012 Performance Palooza. It was a great experience and I appreciated the opportunity. The topic
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.