Why Table Partitioning Doesn't Speed Up Query Performance
Learn why SQL Server's table partitioning feature doesn't make your queries faster-- and may even make them slower.
In this 20 minute video, I'll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won't solve your query performance problems.
Articles discussed are by Gail Shaw, Remus Rusanu, and the SQL Customer Advisory Team (SQLCAT). Get URLs to each article here: http://www.littlekendra.com/2016/05/03/why-table-partitioning-doesnt-speed-up-query-performance-video/
Видео Why Table Partitioning Doesn't Speed Up Query Performance канала Kendra Little
In this 20 minute video, I'll show you my favorite articles, bugs, and whitepapers online to explain where table partitioning shines and why you might want to implement it, even though it won't solve your query performance problems.
Articles discussed are by Gail Shaw, Remus Rusanu, and the SQL Customer Advisory Team (SQLCAT). Get URLs to each article here: http://www.littlekendra.com/2016/05/03/why-table-partitioning-doesnt-speed-up-query-performance-video/
Видео Why Table Partitioning Doesn't Speed Up Query Performance канала Kendra Little
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Clustered vs. Nonclustered Index Structures in SQL Server](https://i.ytimg.com/vi/ITcOiLSfVJQ/default.jpg)
![Step by Step - Introduction to SQL Server Partitioning - Part 1](https://i.ytimg.com/vi/AsXZlkklHbQ/default.jpg)
![Brent Ozar_Watch Brent Tune Queries](https://i.ytimg.com/vi/uwGCPtga06U/default.jpg)
![What is Database Sharding?](https://i.ytimg.com/vi/5faMjKuB9bc/default.jpg)
![Data Warehouse 13 Table Partition Switching](https://i.ytimg.com/vi/wOnYTU9bL48/default.jpg)
![How to Make Inserts, Updates, and Deletes Faster: Databases for Developers: Performance #8](https://i.ytimg.com/vi/4qia05LZOwU/default.jpg)
![What's that Garbage in My Execution Plan? (Dear SQL DBA Episode 27)](https://i.ytimg.com/vi/8Kc7fPpjc4E/default.jpg)
![023 Hash Partition based on the hash key](https://i.ytimg.com/vi/GhM2uK1mpJI/default.jpg)
![SQL Database Fundamentals - Video Columnstore Indexes](https://i.ytimg.com/vi/aqRPAYF0L20/default.jpg)
![How can I speed up a query if an index cannot help?](https://i.ytimg.com/vi/s8m_R9_NtTI/default.jpg)
![Working with Very Large Tables Like a Pro in SQL Server 2016 Part 1](https://i.ytimg.com/vi/NKtwMOU_KnI/default.jpg)
![Should You Rebuild or Reorganize Large Indexes? (Dear SQL DBA Episode 19)](https://i.ytimg.com/vi/fu6DGsDYnKI/default.jpg)
![Differences between Clustered vs Nonclustered Indexes in SQL Server](https://i.ytimg.com/vi/xeoLwQmTO4o/default.jpg)
![SQL Server Table Partition - Part 1](https://i.ytimg.com/vi/3c_VGh8FtZc/default.jpg)
![PostgresOpen 2019 PostgreSQL Partitioning](https://i.ytimg.com/vi/JWQVDKw1HVk/default.jpg)
![Advanced MySQL Slow Query Logging. Part 3: fine-tuning the logging process](https://i.ytimg.com/vi/f6fiy_dVYxw/default.jpg)
![SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headache](https://i.ytimg.com/vi/bS0q1nBP3As/default.jpg)
![Does SQL table join order matter?](https://i.ytimg.com/vi/iIzdAJxedwE/default.jpg)
![Optimizing SQL Performance](https://i.ytimg.com/vi/VCJTVk4xZIs/default.jpg)
![Examples of Range Partition MySQL | List Partition MySQL | Hash Partition MySQL & Key Partition](https://i.ytimg.com/vi/3m9X0-9sCU0/default.jpg)