If you are overtaking an SQL Server, for me the best way is to using the Script by Brent Ozar… Check this out. Really interessting is to find out: 1. Find all tables that are partitioned 2. See what partition function and scheme the table is using 3. See what column the table is partitioned [...]