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.
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 […]
A few months ago I read an article from SQLServerCentral.com 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 […]