May 2007 - Posts

• Performance Impact of Using NTFS Compression with Read-Only Databases

  SQL Server 2005 supports placing read-only filegroups or read-only databases on NTFS compression. In other words, you can compress the database files in a read-only filegroup or a read-only database. This can be a very useful feature if saving disk storage Read More... Posted Friday, May 04, 2007 3:23 AM by Linchi Shea | 2 Comments Filed under: Best Practices, Performance, Storage, Testing