Reading Execution Plans, Part 4: Processing Data
‹ Previous Section So now we have some data, and we've combined it with other tables. However, sometimes we need to compute new columns based on data from other columns,
Reading Execution Plans, Part 3: Joining Data
‹ Previous Section Now that we've got some data, it would be nice to connect data together from multiple tables. The way this is done is through one of three
Reading Execution Plans, Part 2: Retrieving Data
‹ Previous Section Now that we have our execution plan, let's talk about data. And we're going to start at the opposite place from how we start reading execution plan,
Reading Execution Plans, Part 1: Introduction
I want to start off with a quote I read on Reddit a while ago, which I think is a very appropriate introduction to what we're going to talk about:
SQL - Multiple Independent Auto-Increments
Say that you need to have a table with independent incrementing values based on a separate in-table key. For example, you may be operating a sales system, and the business