SQL Server Articles
These articles have been written as a guide for database developers and administrators that are starting out with SQL Server. The articles are intended to serve as a quick reference and starting point but are not necessarily comprehensive. The articles are written for SQL Server 2000, 2005 and 2008 with any version differences indicated in the body of the article.
Management Trees:
A simplified example of the creation of a management tree using CTEs for SQL 2005 or SQL 2008.
Naming Conventions:
Naming conventions for use in your SQL Server environment.
SQL Server Snippets
These code snippets and samples are written for SQL Server 2000, 2005 and 2008 with any version differences indicated in the body of the code.
Date and Time:
A few snippets for converting date and time data.