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/Margarit...

http://SQLbits.com/Sessions/SQL_Serve...
Tags: Optimising,Developing,Managing,Onprem,performance,partitioning,indexing,Database engine,optimizing