Do you really need a GUID in your Database Design?

One of the database design practices that I have seen more and more frequently in recent years is the use of GUIDs for primary keys.  Unless you are implementing merge replication, this is rarely useful and can be both a … Read More

Tips on Designing Clustered Indexes for your SQL Server Tables

In relational databases, a clustered index is an index that determines the organization of records in a table.  This is as opposed to non-clustered indexes, which exist separate from the table data and contain a reference to the row of … Read More