January, 2010 | Henk's tech blog - Part 2

Archive for January, 2010

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

Category: Backup & Restore, SQL 2008 R2, Storage: SAN & SSD | Tags: Backup, Buffercount, Compression, DBCC TRACEON (3213, DBCC TRACEON (3605, Maxtransfersize, Restore, Solid State, SQL2008R2 | 13 Comments

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)

Category: SQL 2008 R2 | Tags: Memory, Page lookups, SQL, SQL2008R2, Table Scan | 4 Comments

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