Control Flow vs. Data Flow Demo
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
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
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
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
I had a recent consulting engagement where a query had unpredictable performance on an isolated test environment. I had two initial questions: – What were
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:
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.