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 […]
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 […]
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 […]
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 […]
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.
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.
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.
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.
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.
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.