SQL Server Table partitioning – DOs and DON’Ts

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 http://SQLbits.com/Sessions/SQL_Server_Table_partitioning__DOs_and_DON_Ts Tags: Optimising,Developing,Managing,On-prem,performance,partitioning,indexing,Database engine,optimizing