Module 03: Lesson 4 – Columnar storage and batch processing
Lessons Archive
Module 03: Lesson 3 – Data compression and window functions
Module 03: Lesson 2 – Filtered indexes and indexed views
Module 03: Lesson 1 – Bitmap filtered hash joins and table partitioning
Module 02: Lesson 3 – Optimizer hints and plan guides
Module 02: Lesson 2 – Parameterized queries
Module 02: Lesson 1 – Supporting queries with indexes
Module 2: Lesson 5 – Percentage of Total in RLS
Module 01: Lesson 5 – Understanding statistics
Module 4: Lesson 1 – Row-Level Security with Live Connection to SSAS Tabular