There are quite a few different ways that you’re likely to see windows functions evidence themselves within your execution plan. Let’s take a look at one example. Windows Function For our example, I’ve got a pretty simple query: Nothing to it really. What kind of execution plan does this generate? Here’s the plan with runtime […]
The post Exploring Windows Function Execution Plans appeared first on Grant Fritchey.