I’ve been interested in exploring what changes may be coming through in SQL Azure (Windows Azure – “SQL Database” now) around query execution cost models
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
This post shows a few examples of Sort related SpillToTempDb execution plan warnings and the associated SpillLevel attribute. This blog post is based on
Let’s say you are querying a partitioned table and you would like to see which partitions were accessed by looking at the graphical execution plan:
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.