Inside the Optimizer: Constructing a Plan - Part 4
The final part in a series by Paul White exploring the internals of query optimization. Learn how
2010-09-16
5,573 reads
Paul White
- Twitter: @https://www.x.com/SQL_Kiwi
- Website: https://www.sql.kiwi
Inside the Optimizer: Constructing a Plan - Part 3
Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.
2010-09-14
6,463 reads
Inside the Optimizer: Constructing a Plan - Part 2
How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.
2010-09-09
7,837 reads
Inside the Optimizer: Constructing a Plan - Part 1
Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.
2010-09-07
12,888 reads
Optimising Server-Side Paging - Part II
The second part of this series compares four methods of obtaining the total number of rows in a paged data set.
2010-05-24
19,051 reads
2010-05-04
3,298 reads
Optimising Server-Side Paging - Part I
This article by Paul White presents an optimisation for paging through a wide data set.
2010-04-26
27,852 reads
2010-04-07
4,057 reads
Blogs
Distance Metrics for Semantic Similarity Searches in SQL Server 2025
Next up in my series talking about The Burrito Bot is diving into the...
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers