Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Comment review: RANKX performance - Unplugged #3

SQLBI
120K subscribers
6K views 4 years ago #unplugged
We read all the comments and sometimes... we have to fix our articles! In this video, we compare the performance of an alternate measure suggested by a reader and.. will it be faster than the original one? You must watch the video to discover it! Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged ...more
...more
These chapters are auto-generated

Introduction

0:00

Article

0:27

Starting point

2:45

Running the query

3:30

Running the query without slicer

5:46

Defining the measure

6:24

Optimization

7:05

Decision

8:37

Calculation

10:06

Checking the code

10:32

Initial performance

15:34

Comparison

16:00

Join

18:09

Semijoin

19:06

Zerobased index

19:26

Total calculation

22:37

Current name

24:06

Server timings

25:09

Analyzing the query

27:09

Analyzing the calculation

28:04

The cut

29:44

Analysis

30:04

Customer and Customer Name

31:03

Optimized execution

32:58

Customer name

33:24

Optimizing

34:18

Format

35:53

Table expression

36:31

Constant values

38:44

Lookup table

44:52

Filter current value

48:53

Final rank

49:58

Advanced benchmark

51:26

Minimum value

52:46

Optimize the code

54:42
Comment review: RANKX performance - Unplugged #3
128Likes
6,093Views
2021Jan 23
We read all the comments and sometimes... we have to fix our articles! In this video, we compare the performance of an alternate measure suggested by a reader and.. will it be faster than the original one? You must watch the video to discover it! Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged

Follow along using the transcript.

SQLBI

120K subscribers