Steve Jones

DBCC Timewarp

Running SQL Faster

Learn how to make your SQL Server perform better from MVP Gail Shaw.

Insider Insights

Insider rumours and gossip from the murky world of the Database Industry, and from the colourful characters that inhabit it.

Decoding the SQL Server Index Structure

A deep dive into the implementation of indexes in SQL Server 2008 R2. This is information that you must know in order to tune your queries for optimum performance. Partial scans of indexes are now possible!

Busy Work

Run this fun script when you're bored.

Voice of the DBA Podcast

Independence Day

SQL Server

The Concept of Cardinal Reciprocity- A Primer

Too many authors in the field of relational theory have neglected the concept of Cardinal Reciprocity. This can cause a number of subtle problems with database design in terms of its derivability, redundancy, and consistency. . Increasingly, this little-understood aspect of relational theory, that emphasises the cardinality of the attributes of tuples in a relation and the reciprocity with isomorphic foreign key restraints, is becoming a hot forum topic.