Hard disks have become so huge that less than $200 will now buy you a 500GB external drive in a store. Still, flash drives are catching up in size whilst providing far better access speeds and power usage. (Dell are charging $800 for a 32GB Flash Drive for my laptop – enough to be usable)
Today, major SQL Server installations [...]
Archive for January 7th, 2008
Database Flash Memory Storage
January 7, 2008SQL Server 2005 Table Partitioning – Links
January 7, 2008Table partitions have new and improved functionality in SQL Server 2005, and it is now actually very easy to define them.
A simple take is that partitions enable you spread table data over multiple locations.
In one scenario, your application may have 10 years worth of data in a ‘Sales’ table. If you create a partition for [...]
