A first look at the query_optimizer_estimate_cardinality XE event
This weekend I set up a Windows Azure virtual machine running SQL Server 2014 CTP2 (12.0.1524). I had a local copy of SQL Server 2014
Menu
This weekend I set up a Windows Azure virtual machine running SQL Server 2014 CTP2 (12.0.1524). I had a local copy of SQL Server 2014
My 9th guest blog post was published today on SQLPerformance.com: Exploring Partition-Level Online Index Operations in SQL Server 2014 CTP1 In this post I explore
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
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
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
Last November I blogged about how index usage stats don’t get updated when the associated index statistics (but not index) are used. This post will
I was thinking back to a conversation I had some time ago regarding cases when sys.dm_db_index_usage_stats does not get updated after an index is used
Today there isn’t a fine-tuned way to clear the accumulated statistics from the “missing index” set of DMVs. Certainly restarting SQL Server will do 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.