SQL Server Table partitioning – DOs and DON’Ts - Margarita Naumova
When do we get improvement in the performance, and when should we better not choosing partitioning but some other optimization techniques instead? Shall we optimize by using partitioning or yet another index?
Speaker: Margarita Naumova https://sqlbits.com/speakers/Margarita_Naumova
Speaker Blog: http://maginaumova.com
Speaker BIO: Magi Naumova is an SQL Server Architect, consultant, trainer, speaker, MCM, MVP, MCT, with more than 15 years of SQL Server experience. She is founder and the leader of Bulgarian SQL UG, CEO of inspirit.bg and Inspir-it.no
http://sqlbits.com/Sessions/SQL_Server_Table_partitioning__DOs_and_DON_Ts
Видео SQL Server Table partitioning – DOs and DON’Ts - Margarita Naumova канала SQLBits
Speaker: Margarita Naumova https://sqlbits.com/speakers/Margarita_Naumova
Speaker Blog: http://maginaumova.com
Speaker BIO: Magi Naumova is an SQL Server Architect, consultant, trainer, speaker, MCM, MVP, MCT, with more than 15 years of SQL Server experience. She is founder and the leader of Bulgarian SQL UG, CEO of inspirit.bg and Inspir-it.no
http://sqlbits.com/Sessions/SQL_Server_Table_partitioning__DOs_and_DON_Ts
Видео SQL Server Table partitioning – DOs and DON’Ts - Margarita Naumova канала SQLBits
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Why Table Partitioning Doesn't Speed Up Query PerformanceCost Management and Analysis of SQL On Demand in Synapse AnalyticsSharding & Database Partitioning | System Design BasicsSQL Server Table Partition - Part 1SQL Server Data Partitioning by Vijay ReddySQL Server interview question :- Explain RowNumber,Partition,Rank and DenseRank ?Administering Microsoft SQL Server 2012: Working with Files and File GroupsSQL Server partitions - How to create and use Sliding Windows - Part IDealing With Big Data - ComputerphileMicrosoft SQL Server Table Partitioning DemonstrationQuerying 100 Billion Rows using SQL, 7 TB in a single tableUnderstanding and using indexes on SQL ServerFoglight for SQL Server OverviewMSSQL - What is Table Partitioning ExplainedExpert Level SQL TutorialStep by Step - Introduction to SQL Server Partitioning - Part 1Oracle to SQL Migration Beyond Migration Assistant by (Amit Bansal)MSSQL - How to use Table Partitioning for Big Data TutorialWhen to use Azure Synapse vs. Azure Databricks?Examples of Range Partition MySQL | List Partition MySQL | Hash Partition MySQL & Key Partition