New Course: “SQL Server: Common Performance Issue Patterns”
My latest course, “SQL Server: Common Performance Issue Patterns“ was just published by Pluralsight.com. The course description is as follows: “There are a wealth of problems
My latest course, “SQL Server: Common Performance Issue Patterns“ was just published by Pluralsight.com. The course description is as follows: “There are a wealth of problems
I wrote a new article for Simple-Talk that was published recently: Fixing Gatekeeper Row Cardinality Estimate Issues In the article I talk about a specific
My second guest blog post was published today on SQLPerformance.com: Ten Common Threats to Execution Plan Quality This is related to the subject of my
SQL Server 2012 Service Pack 1 is out today and it fixes an issue that has been around for several versions regarding distributed queries and
A quick and somewhat nuanced tip today… When evaluating sys.dm_io_virtual_file_stats against collected perfmon counter data, be careful not to erroneously invalidate the latency findings
A few weeks ago I was interviewed by Richard Cambell of RunAs Radio: Joe Sack Tunes Queries in SQL Server! We talk about performance tuning,
SQLServerCentral published an article today that I wrote about SQL Server 2012’s execution plan parallel thread usage statistics: SQL Server 2012’s Information on Parallel Thread
SQL Server 2008 execution plans include an optional MemoryGrant attribute in the QueryPlan element – but SQL Server 2012 significantly expands on memory grant related
SQL Server 2012 includes a new RetrievedFromCache attribute in the query execution plan. Let’s say I execute the following query immediately after executing DBCC FREEPROCCACHE:
The MSQL_DQ wait type accumulates while waiting for a distributed query to complete and it is not necessarily indicative of an issue. If MSQL_DQ is
SQL Server 2012 introduces a “NonParallelPlanReason” attribute in the QueryPlan element in a query execution plan. This attribute is not officially documented as of this
I wrote an article for Simple-Talk that was published last Monday: A first look at SQL Server 2012 Availability Group Wait Statistics AlwaysOn Availability Groups
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.