Archive for January, 2010

How to increase SQL Database Full Backup speed using compression and Solid State Disks (2010-1-15)

The SQL 2008 Database backup compression feature (which was introduced as a SQL2008 Enterprise Edition only feature) will become available in the SQL2008 R2 Standard Edition also ( SQL 2008 R2 Editions).  I’m using the compression feature for quite some time now and really love it; it saves significant amounts of disk space and increases […]

Optimizing SQL In Memory Table Scan processing speed (2010-1-9)

How fast can you can actually read data from a table that is already loaded in memory?  People often assume that, once it’s in memory, it’s as fast as it can get and won’t get any faster ? But how fast is it really ?  Let’s find out! The Math Method If the total table […]

Better Tag Cloud