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

Видео Learn T-SQL With Erik: Partitioning != Performance канала Erik Darling (Erik Darling Data)