Tag Archives: SQL Server 2008

Want To Upgrade?

Introduction I have seen several posts lately asking about ROI/Justifications etc about upgrades. There are LOTS of posts on this topic, and some really great documentation from Microsoft that covers this topic at great length. This post does not really add anything to those, other than distilling some of the key points from the Microsoft […]

Leave a Comment Continue Reading →

Warehouse Design Tip / Partitioning

Introduction This topic seems so simple, and so obvious to me, and do not mean to insult anyone’s intelligence.  However, it is shocking to me the number of people that I have talked to (running large databases) that are not taking advantage  of one of the best performance, and manageability enhancements out there!  Think about […]

1 Comment Continue Reading →

T-SQL Tuesday #006: Configure Filestream Storage for BLOBS

Introduction This is my post for the monthly TSQL Tuesday Blogging event.  With the release of SQL Server 2008, among the many new features was one that at first I took little notice of, FILESTREAM storage options. It did not take long to realize that this new feature has some powerful storage capabilities. You can […]

Leave a Comment Continue Reading →

Data Warehouse – AutoShrink how-to

Introduction Space management is always a challenge in any system, however, in systems that are designed to grow-grow and grow, it seems to be a particularly big challenge as to how best manage space.  This post will give you an overview how to set the auto-shrink correctly to allow for even distribution of data within […]

Leave a Comment Continue Reading →

Warehouse Design Tip -Schema’s

Data Warehouse design tip, and example for the use of schemas. The ability to override a description in a dimension.

1 Comment Continue Reading →

Help – My disk performance VI

Part VI in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers additional monitoring, and wraps ups some leftovers from this series.

4 Comments Continue Reading →

Help – My disk performance V

Part V in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers basic monitoring.

4 Comments Continue Reading →

Help — My disk performance IV

Part IV in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers database filegroups and files.

7 Comments Continue Reading →

Help – My disk performance III

Part III in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers database partitioning and compression.

2 Comments Continue Reading →

Help – My disk performance II

Part II in a series of discussions about configuring a Data Warehouse for optimal disk performance. This part covers physical connection, and LUN layout on a SAN.

Leave a Comment Continue Reading →