Post reply

size field in sys.database_files

  • June 11, 2011 at 4:18 pm

    #241268

    in SELECT 8 from sys.database_files, there is a field called size.

    what unit is it? I mean is it in byte, or kb or other ?

    I read there is a function in a script:

    SELECT *, SizeInMB = CAST(((SIZE * 8.00)/1024.00) AS DECIMAL(18,2)) from sys.database_files

    so waht does size* 8 mean?

  • June 12, 2011 at 3:11 am

    #1337445

    sqlfriends (6/11/2011)

    in SELECT 8 from sys.database_files, there is a field called size.

    what unit is it? I mean is it in byte, or kb or other ?

    Straight from Books Online:

    size

    int

    Current size of the file, in 8-KB pages.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 12, 2011 at 9:56 am

    #1337482

    http://msdn.microsoft.com/en-us/library/ms174397.aspx

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

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