<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Why you shouldn't compress SQL Server data and log files</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx</link><description>Most knowledgable SQL Server DBAs know you shouldn't compress a database's data and log files, but I'll wager that few know the details behind why that's such a bad idea. The general reply might be "Performance" -- and that's correct -- but the assumption</description><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP1 (Build: 61025.2)</generator><item><title>Why you shouldn't compress SQL Server data and log files</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#414544</link><pubDate>Wed, 04 May 2005 10:53:26 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:414544</guid><dc:creator>Vinod Kumar's Blog</dc:creator><description /></item><item><title>re: Why you shouldn't compress SQL Server data and log files</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#416411</link><pubDate>Wed, 11 May 2005 15:08:51 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:416411</guid><dc:creator>YeYan</dc:creator><description>RePost : &lt;a rel="nofollow" target="_new" href="http://www.yeyan.cn/Database/CompressSQLServer.aspx"&gt;http://www.yeyan.cn/Database/CompressSQLServer.aspx&lt;/a&gt;</description></item><item><title>SQL Server 2005 and compressed drives - what you should know?</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#617586</link><pubDate>Mon, 05 Jun 2006 06:12:09 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:617586</guid><dc:creator>SQL, .NET and everything Microsoft</dc:creator><description>&lt;br&gt;You will be surprised to know how many times this topic comes up during discussions with SQL Server...</description></item><item><title>Disk Compression and SQL dbs</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#617604</link><pubDate>Mon, 05 Jun 2006 06:32:09 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:617604</guid><dc:creator>Rod Trent at myITforum.com</dc:creator><description>This is a good summation of the age-old discussion if you should put your SQL dbs on a compressed disk...</description></item><item><title>SQL Server и компрессированные файлы NTFS</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#630628</link><pubDate>Wed, 14 Jun 2006 11:22:01 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:630628</guid><dc:creator>Олег Михайлик</dc:creator><description>Это следует знать! SQL Server 2000 не любит компрессированных файлов БД .mdf и .</description></item><item><title>re: Why you shouldn't compress SQL Server data and log files</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#639145</link><pubDate>Tue, 20 Jun 2006 14:12:28 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:639145</guid><dc:creator>teen lesbian rape</dc:creator><description>Persone los pioneros non rabata. Great...</description></item><item><title>re: Why you shouldn't compress SQL Server data and log files</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#651850</link><pubDate>Fri, 30 Jun 2006 08:41:21 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:651850</guid><dc:creator>rape movies</dc:creator><description>Asaspal. Memrano tu es besta. Amigo.</description></item><item><title>re: Why you shouldn't compress SQL Server data and log files</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#656756</link><pubDate>Wed, 05 Jul 2006 13:18:56 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:656756</guid><dc:creator>rape videos</dc:creator><description>Your article is quite right, thanks.</description></item><item><title>re: Why you shouldn't compress SQL Server data and log files</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#2022050</link><pubDate>Wed, 04 Apr 2007 03:10:50 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:2022050</guid><dc:creator>LT</dc:creator><description>&lt;p&gt;that make sense....but what about if we have a very fast CPU, and a big database.....then it will be a bottle neck on the harddrive speed....so if we compress, will the we fast CPU overcome the speed of harddrive to make it faster&lt;/p&gt;
&lt;p&gt;in some situation the speed of CPU will totally over the speed of the harddrive, that will make everthing faster&lt;/p&gt;
</description></item><item><title>  sql 2005 express at  Stay hungry, Stay foolish</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#2296683</link><pubDate>Fri, 27 Apr 2007 10:37:27 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:2296683</guid><dc:creator>  sql 2005 express at  Stay hungry, Stay foolish</dc:creator><description>&lt;p&gt;PingBack from &lt;a rel="nofollow" target="_new" href="http://www.shawnjohnjr.idv.tw/wp/?p=115"&gt;http://www.shawnjohnjr.idv.tw/wp/?p=115&lt;/a&gt;&lt;/p&gt;
</description></item><item><title>re: Why you shouldn't compress SQL Server data and log files</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#2516404</link><pubDate>Thu, 10 May 2007 07:07:53 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:2516404</guid><dc:creator>Dave Bartlett</dc:creator><description>&lt;p&gt;Superb post, thanks again Ken. Your books are great, the Guru's Guide to T-SQL is always on my desk somewhere.&lt;/p&gt;
</description></item><item><title>SQL Server on Compressed Filesystems. &amp;laquo; Duty Free!! The World Logs here&amp;#8230;</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#9344991</link><pubDate>Tue, 20 Jan 2009 12:49:11 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9344991</guid><dc:creator>SQL Server on Compressed Filesystems. &amp;laquo; Duty Free!! The World Logs here&amp;#8230;</dc:creator><description>&lt;p&gt;PingBack from &lt;a rel="nofollow" target="_new" href="http://honeyvirus.wordpress.com/2009/01/20/sql-server-on-compressed-filesystems/"&gt;http://honeyvirus.wordpress.com/2009/01/20/sql-server-on-compressed-filesystems/&lt;/a&gt;&lt;/p&gt;
</description></item><item><title>Should not compress SQL database??? | keyongtech</title><link>http://blogs.msdn.com/khen1234/archive/2005/04/25/411852.aspx#9364669</link><pubDate>Thu, 22 Jan 2009 11:13:15 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:9364669</guid><dc:creator>Should not compress SQL database??? | keyongtech</dc:creator><description>&lt;p&gt;PingBack from &lt;a rel="nofollow" target="_new" href="http://www.keyongtech.com/49904-should-not-compress-sql-database"&gt;http://www.keyongtech.com/49904-should-not-compress-sql-database&lt;/a&gt;&lt;/p&gt;
</description></item></channel></rss>