“CSelCalcCombineFilters_ExponentialBackoff” Calculator
One more post for the day, just while I have the blogging bug… Per my last post, we saw that the query_optimizer_estimate_cardinality event can provide
One more post for the day, just while I have the blogging bug… Per my last post, we saw that the query_optimizer_estimate_cardinality event can provide
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
In the last SQLskills Insider demo video I went through a scenario where you can use the query_hash column from sys.dm_exec_query_stats to aggregate statistics for
My 10th guest blog post was published today on SQLPerformance.com: Exploring Low Priority Lock Wait Options in SQL Server 2014 CTP1 In this post I
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
Now before I begin this post, a quick disclaimer… SQLskills partners with SQL Sentry on a couple of things. We periodically write guest-posts on SQLPerformance.com
My 8th guest blog post was published today on SQLPerformance.com: Exploring SQL Server 2014 SELECT INTO Parallelism In this post I kick the tires of
My 7th guest blog post was published today on SQLPerformance.com: Observer Overhead and Wait Type Symptoms This article details seven test scenarios I performed in
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
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
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.