All Articles -> SQL Server Table Design

Implementing Table Inheritance in SQL Server ( 20 February 2008 - Jeff Smith - 22 Comments)

Custom Auto-Generated Sequences with SQL Server ( 24 April 2007 - Jeff Smith - 12 Comments)

The Case for the Surrogate Key ( 9 August 2002 - Bill Graziano - 29 Comments)

Using TABLE Variables ( 7 June 2002 - Bill Graziano - 22 Comments)

More Trees & Hierarchies in SQL ( 1 May 2002 - Rob Volk - 123 Comments)

Default Constraint Names ( 24 January 2001 - Bill Graziano - 2 Comments)

Temporary Tables ( 17 January 2001 - Bill Graziano - 13 Comments)

Denormalize for Performance ( 10 January 2001 - Bill Graziano - 0 Comments)

Estimating the Size of a Table ( 28 December 2000 - Bill Graziano - 0 Comments)

Horizontal partitioning in SQL7 ( 19 December 2000 - Chris Miller - 0 Comments)

Database Normalization And Design Techniques ( 8 September 2000 - Bill Graziano - 0 Comments)

Database Design and Modeling Fundamentals ( 30 June 2000 - Brent Huscher - 4 Comments)