What’s amazing to me is how much we accomplished with AWFUL hardware 10 years ago. I used to work on a 5tb database at Microsoft on a Pentium3… when I got there, users were writing SQL and waiting an hour.. Moving to cubes changed most lookups to sub-second.
One of these days, I’d like to have some benchmarks, SQL Server vs JET.. I’m absolutely certain that we could make SQL Server run faster than Jet simply by using different harddrives for data vs indexes.
Micron Technology today announced a terabyte-class solid-state drive for under $600.
The 2.5-inch 960GB Crucial M500 SSD will be initially priced under $600, Micron said today.
The M500 solid-state drive uses a SATA 6-gigabit-per-second controller to deliver up to 80,000 input/output operations per second (IOPS).
The drive’s sequential read and write speeds reach up to 500 megabytes per second (MB/s) and 400 MB/s, respectively.
Drives in the 2.5-inch form factor will be available in 120GB, 240GB, 480GB and 960GB capacities. The smaller M.2 and mSATA form factors will be available in 120GB, 240GB and 480GB capacities.
The 2.5-inch Crucial M500 SSD is expected to be available for purchase in the first quarter of 2013. The M.2 and mSATA form factors are expected in the second quarter.