Monthly Archives: May 2011

Dropping a Row

Posted on May 10, 2011 by way0utwest

In a scalability discussion, I saw this comment: Companies like Google or FaceBook manage a lot of data, but it’s not held the same degree of scrutiny. For example, if FaceBook dropped 1 out of 1,000 random guestbook posts, would … Continue reading →

Posted in Editorial | Tagged | Comments Off on Dropping a Row

T-SQL Tuesday #18 – My CTE

Posted on May 10, 2011 by way0utwest

It’s time for T-SQL Tuesday again, and it’s number 18. Hard to believe it’s been a year and a half since Adam Machanic (blog | @AdamMachanic) thought of the idea. I’ve participated in most and it’s something I look forward … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Tiered Storage

Posted on May 9, 2011 by way0utwest

One of the things that I saw demonstrated at my very first PDC conference in 1998 was the addition of Hierarchical Storage Management to Windows servers. This was in the Windows NT 4 era, and I was investigating a variety … Continue reading →

Posted in Editorial | Tagged | Comments Off on Tiered Storage

An Impressive SQL Server

Posted on May 6, 2011 by way0utwest

Recently I heard about one SQL Server with 1TB of RAM and another one that was handling over 10,000 transactions a second. I read a note about a 1.1PB database, built on SQL Server to hold data from telescopes. That … Continue reading →

Posted in Editorial | Tagged | Comments Off on An Impressive SQL Server