Streams VS Sparse File

  • Can somebody help me to understand, is there any difference between "SPARSE FILE" and "Streams", are the same?

    "SQL Server 2005 uses sparse files for snapshot database files and online DBCC operations against files stored on NTFS volumes."

    "SQL Server 2005 online DBCC checks are based on the database snapshot technology by using transient, secondary file streams to store point-in-time images of data pages when the DBCC is in progress"


    subban

  • Any help please


    subban

  • Unrelated, other than they are both NTFS features.

    Alternate streams: http://msdn.microsoft.com/en-us/library/ms810604.aspx (long document)

    Sparse files: http://msdn.microsoft.com/en-us/library/aa365564%28VS.85%29.aspx (there's also info on sparse columns in the previous doc)

    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

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

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