Download my SQL Server Database Coding Standards and Guidelines complete list as a PDF, the whole series in one file, made because readers asked for it.
SQL SERVER – Database Coding Standards and Guidelines Part 2
Database Coding Standards and Guidelines Part 2: skip SELECT *, use SET NOCOUNT ON, prefer CTEs over temp tables, avoid cursors, and more query tips.
SQL SERVER – Database Coding Standards and Guidelines Part 1
Database Coding Standards and Guidelines Part 1: naming rules for tables, stored procedures, triggers, indexes, primary keys and foreign keys.
SQL SERVER – Database Coding Standards and Guidelines Introduction
Coding Standards and Guidelines Introduction: after my interview questions series, readers asked for coding standards, so I kept this set short and practical.
SQL SERVER – 64 bit Architecture and White Paper
A Microsoft white paper on the 64 bit architecture of SQL Server 2005: more addressable memory, better parallelism and the key differences from 32-bit.
SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007)
SQL Server 2005 Samples gave learners AdventureWorks and the smaller AdventureWorksLT. Why they mattered and where to find sample databases today.
SQL SERVER – Primary Key Constraints and Unique Key Constraints
Primary Key and Unique Key both enforce uniqueness, but they differ in the index they create and in NULL handling. Here are the differences and the scripts.