The mystery of incorrect filegroup size
Recently, there was a question that why the SQL Server DMVs were reflecting incorrect information with respect to the size of the indexes, files and filegroups. The following data supported the question:
SELECT TOP 50 OBJECT_NAME(p.object_id) AS table_name,
i.[name] AS index_name,
f.name AS
Submit a review:
Login required.