InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 13:24:28 GMT20http://www.sqlservercentral.com/Forums/Topic821453-149-1.aspxUnrelated, other than they are both NTFS features.Alternate streams: [url]http://msdn.microsoft.com/en-us/library/ms810604.aspx[/url] (long document)Sparse files: [url]http://msdn.microsoft.com/en-us/library/aa365564%28VS.85%29.aspx[/url] (there's also info on sparse columns in the previous doc)Fri, 20 Nov 2009 05:53:33 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic821453-149-1.aspxAny help pleaseFri, 20 Nov 2009 05:25:04 GMTSubhash-63067http://www.sqlservercentral.com/Forums/Topic821453-149-1.aspxCan somebody help me to understand, [b]is there any difference between "SPARSE FILE" and "Streams", are the same?[/b]"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"Thu, 19 Nov 2009 03:28:38 GMTSubhash-63067