[2k5] sp_spaceused.data와 sys.dm_db_index_physical_stats.page_count 용량 비교

1. /**********************************************************************************************
   -- Title : [2k5] sp_spaceused.data와 sys.dm_db_index_physical_stats.page_count 용량 비교
   -- Reference : feelanet.com
   -- Key word : sp_spaceused sys.dm_db_index_physical_stats page_count
   **********************************************************************************************/
   USE Tempdb;
   GO
   
   SELECT
    ContactID, NameStyle, Title, FirstName, MiddleName, --nvarchar
    Suffix,
    EmailAddress,
    CAST ('' AS VARBINARY(512)) AS EmailCert,
    CAST ('' AS VARBINARY(512)) AS EmailSym,
    CAST ('' AS VARBINARY(512)) AS EmailAsym,
    CAST ('' AS VARBINARY(512)) AS EmailPassPh,
    EmailPromotion, Phone, PasswordHash, PasswordSalt, rowguid, ModifiedDate
   INTO contact
   FROM adventureWorks.Person.Contact;
   GO
   
   EXEC SP_SPACEUSED contact;
   /*
   name        rows        reserved           data               index_size         unused
   contact     19972       4368 KB            4352 KB            8 KB               8 KB
   */
   GO
   
   SELECT page_count
   FROM sys.dm_db_index_physical_stats(db_id(), object_id('contact'), NULL, NULL, DEFAULT);
   --544
   GO
   
   /*
   -- 결론  
   -- 544 * 8K = 4352 K = sp_spaceused.data
   -- 즉, sys.dm_db_index_physical_stats.page_count * 8k = sp_spaceused.data
   */