Query partitions with boundaries
Check what partitions are you using in the database. Super-useful script to quickly list all partitioned tables with information about file groups, partition schemas and partition functions.
HINT: Add where clause...