Post reply

T-SQL / Space Used only from the DataFile

  • June 4, 2007 at 9:23 am

    #68571

    How can i obtain with T-Sql the size of the useage only form the DataFile - including the size for keys. Should deliver the same size like Enterprise Manager \ view Taskpad

    Thanks in advance

    Jürgen

  • June 4, 2007 at 12:00 pm

    #710681

    You can use DBCC SHOWFILESTATS

    The column UsedExtents will give you the information you're looking for. Since there are 64K in an extent, the calculation for used space for data in MB will be:

    UsedExtents * 64/1024

    -mr

  • June 4, 2007 at 11:55 pm

    #710787

    GREAT answer - thank you very much

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply