This article explains how to stop an asynchronous job in PowerShell.
This article explains how to check the installed version of PowerShell.
This article explains how to uninstall an application in PowerShell.
In How Can Query Plans Help Us? we looked at how query plans can be made to help us troubleshoot a runaway query. Then in Are Query Plans All We Need? we looked at other tools we need to keep ready in our performance tuning utility belt. With that in mind, it is now time to understand how we can capture query plans to begin with.
So Where Do We Start?
To understand how we can capture query plans, we must first understand what types of query plans are there to capture. Luckily, there is only two of them.
In How Can Query Plans Help Us?, we looked at the nature of T-SQL and then at some of the benefits that understanding query plans can bring us. But are query plans a silver bullet? Can we overcome all optimization challenges with query plans only or are there other tools we need on our utility belt?