Which Filegroup is that Partition Using? How Many Rows Does It Have?
Category:
tsql-programming
Table Partitioning in SQL Server has a bit of a learning curve. It’s tricky to just figure out how much data you have and where the data is stored.
Tag: metadata
Find the Partitioning Key on an Existing Table with Partition_Ordinal
Category:
indexing
@SQLSista asked a fun question on Twitter recently about how to figure out the partitioning key on an existing table:
Bad Partitioned HEAP predates me. No clustered index, Primary Key on ID column and multiple datetime columns. How to find the partitioning key? #sqlhelp