Monthly Archives: February 2008

HierarchyID in SQL Server 2008

SQL Server 2008 includes a new HierarchyID datatype!

Posted in SQL Server Development | Tagged | 5 Comments

Advantages of Immutable Data

I was reading about two of Google’s internal programs, Bigtable and Google File System, and how they handle a large amounts of data so that the processing is distributed (Bigtable) and the data is replicated (Google File System). One thing … Continue reading

Posted in Architecture | Tagged | 20 Comments

SQL Server Hash Indexes

There are two problems with indexes on large nvarchar columns: You will likely hit the 900 byte limit in your index Indexing large data isn’t efficient anyway. A neat feature of SQL Server is the CHECKSUM() function which hashes your … Continue reading

Posted in SQL Server Development | 7 Comments

“Including” Columns in an Index

A neat feature in SQL Server 2005 is the ability to “include” columns in an index. These included columns are not in the main part of the index, but are additional information in the index. For example, lets say you … Continue reading

Posted in SQL Server Development | 7 Comments