How to determine whether there are any records in a given Partition Range

Given a SQL Server Partition Function, with multiple ranges, used by multiple tables/indexes, I want to identify which ranges (and whether the 2nd range, in particular) do or don't contain data anywhere in the database.

How can I do that?

Read more here:

Content Attribution

This content was originally published by Brondahl at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: