Monthly Archives: February 2008

HierarchyID in SQL Server 2008

Posted on February 23, 2008 by Clay Lenhart

SQL Server 2008 includes a new HierarchyID datatype!

Posted in SQL Server Development | Tagged | 5 Comments

Advantages of Immutable Data

Posted on February 16, 2008 by Clay Lenhart

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 | 21 Comments

SQL Server Hash Indexes

Posted on February 3, 2008 by Clay Lenhart

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

Posted on February 2, 2008 by Clay Lenhart

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