How do I tune a SQL statement that isn't getting partition pruning

Описание: Partitioning is possibly one of the most powerful tools at your disposal when managing large volumes of data and improving the performance of queries that would otherwise scan and filter lots and lots of data.
However, it can be tricky to determine why it isn't helping when you thought it should. This video demonstrates how you can tell if you are getting the benefits of partition pruning and shares the solutions for the common scenarios where pruning is prevented from happening.