Tag Archives: sql server

Learn to Use Filegroups

Posted on May 12, 2011 by way0utwest

In SQL Server, filegroups are a management technique that I don’t see many people using. It’s amazing how many people ask questions about filegroups on the discussion forums, often unsure of how they fit into a well architected SQL Server. … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Learn to Use Filegroups

The Poor Soul

Posted on May 11, 2011 by way0utwest

I recently had someone post this after I made a comment about someone taking responsibility for their database server. “So Steve, what would you recommend then for those poor souls?  As being one of them it drives me nuts to … Continue reading →

Posted in Editorial | Tagged , | Comments Off on The Poor Soul

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

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