Partitioning is a database design technique when data is split across multiple tables or databases but is logically still one table. This technique is proper when dealing with large tables, as it can ...
SELECT t.name AS TableName, s.name AS SchemaName, COUNT(DISTINCT p.partition_number) AS PartitionCount, SUM(p.rows) AS TotalRows, -- Total sizes CAST(SUM(a.total_pages) * 8.0 / 1024 AS DECIMAL(10,2)) ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results