About Collations in SQL Server
This post will be fore the purpose of documenting all my findings regarding Collations in SQL Server, including changing the collation on an…
Read MoreCategory: Design
Some database design guidelines and best practices
Below are some best practices known within the SQL Server database community use when designing tables. 1. All data columns should be properly…
Read More
Why using GUIDs as Primary Keys on a Clustered Index (Table) is not a good idea and some alternative approaches
Here is a great blog post by Kimberly Tripp on why using GUIDs as a PRIMARY KEY on a CLUSTERED index is a…
Read More
Why use of VARCHAR(MAX) should be avoided
Here is a good blog post on a comparison of VARCHAR(MAX) versus VARCHAR(N): Performance comparison of varchar(max) vs. varchar(N) Views – 2097
Read More
SQL Server Index Design Best Practices
This post is consisted of mostly direct quotes from the article posted at the bottom of the page. I put them here to…
Read More
Primary Key Best Practices
I follow a few rules: 1. Primary keys should be as small as necessary. Prefer a numeric type because numeric types are stored…
Read More