What if we could create a numbers table without IO?  What if we could perform several different kinds of queries without IO?  Itzik Ben Gan proposed a cascading CTE solution that does this sort of thing. This article shows that method in use to help improve certain IO conditions.

Worst Thing to Do to your DBA

Recently Andy Warren Blogged about things that could drive your DBA mad.  There was a lot of feedback on SQLServerCentral about various things that could be done to drive the DBA nuts.  Well, I have […]

Index your FK

A few months ago I read an article from about some Foreign Key gotchas.  Since that article, I have seen several people asking about whether a foreign key should be indexed or not.  I have […]