Learn T-SQL With Erik: Partitioning != Performance

## Summary In this video, I dive into the intricacies of partitioning in SQL Server, specifically focusing on rowstore indexes. I begin by laying out the key caveats upfront to ensure viewers understand that partitioning is primarily a data management feature, not a query performance enhancer. I share my excitement about the new SQL Server performance monitoring tool I've developed, which is free, open-source, and designed to help you gain insights into SQL Server performance without any pesky email signups or telemetry. Throughout the video, I illustrate how partitioning can sometimes lead to unexpected performance issues, especially when dealing with local variables, functions, and non-aligned indexes. I also highlight the importance of maintaining aligned indexes for optimal performance and discuss strategies for working around partitioning limitations, such as using cross-apply and partition functions. By the end of the video, viewers will have a better understanding of when and how to effectively use partitioning in their SQL Server environments. ## Chapters - **00:00:00** - Introduction - **00:01:32** - Course Information - **00:02:19** - Personal Appearances - **00:03:17** - Upcoming Events - **00:04:11** - Data Management Feature - **00:05:01** - Table Partitioning - **00:05:58** - Batch Mode Limitations - **00:06:33** - Query Execution - **00:07:02** - Indexing Issues - **00:08:04** - Column Wrapping - **00:09:01** - Query Plan Analysis - **00:10:22** - Non-Aligned Indexes - **00:11:03** - Index Optimization - **00:12:19** - Query Performance - **00:13:15** - Time Comparison - **00:14:00** - Query Rewriting - **00:15:02** - Partitioning Challenges - **00:16:00** - Data Swapping - **00:16:45** - Conclusion - **00:17:06** - Next Video ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🕵️‍♂️ FREE SQL SERVER MONITORING & Plan Analysis ━━━━━━━━━━━━━━━━━━━━━━━━━━ https://github.com/erikdarlingdata/PerformanceMonitor https://github.com/erikdarlingdata/PerformanceStudio ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 TRAINING & COURSES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Get AI-Ready With Erik https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY SQL Server Performance Engineering Course https://training.erikdarling.com/sql-server-performance-engineering?coupon=ENGINEERING Learn T-SQL with Erik https://training.erikdarling.com/learn-t-sql-with-erik?coupon=ADVANCEDTSQL Everything Bundle: https://training.erikdarling.com/?coupon=SPRINGCLEANING ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ CONSULTING & SERVICES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Need SQL Server performance help? https://training.erikdarling.com/sqlconsulting ━━━━━━━━━━━━━━━━━━━━━━━━━━ 💬 CONNECT ━━━━━━━━━━━━━━━━━━━━━━━━━━ Ask questions at Office Hours https://erikdarling.com/officehours/ Become a channel member https://www.youtube.com/@ErikDarlingData/join