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: https://stackoverflow.com/questions/67388966/how-to-determine-whether-there-are-any-records-in-a-given-partition-range

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: