Tag Archives: sql

Sparse Columns in SQL Server 2008

The April 2010 edition of SQL Server Magazine has an article entitled “Efficient Data Management in SQL Server 2008, Part 1“.  The article introduces a new way to save storage space by using sparse columns.  As described by the author, Don Kiely, sparse columns allow SQL Server to manage storage of data more efficiently if...… read more

A Commercial Temporal RDBMS

The current database technology that most businesses rely upon today is beginning to show its age as new types of transactional applications are required.  The design and formalization of a relational database management system (RDBMS) during the 1970s is widely credited to E. F. Codd, and is based on the relational model.  This model is...… read more