Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Streams VS Sparse File Expand / Collapse
Author
Message
Posted Thursday, November 19, 2009 3:28 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 7, 2013 11:45 AM
Points: 169, Visits: 282
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
Post #821453
Posted Friday, November 20, 2009 5:25 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 7, 2013 11:45 AM
Points: 169, Visits: 282
Any help please


subban
Post #822275
Posted Friday, November 20, 2009 5:53 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:50 AM
Points: 40,403, Visits: 36,842
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 2008, MVP
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

Post #822296
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse