1 DBA's Professional Blog
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.
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 […]
I really must thank Steve for his editorial on FizzBuzz. It seemed like a really good topic to do some testing and comparison. Then the comments started rolling in on the topic. This provided more […]
PayPeriod Matching lesson learned.
Paul Randal transaction script.
Recursively traverse system views to build a Hierarchical Perspective into the database.
I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts. Right now she is looking for Beta testers. Anybody that is interested could find more info at: http://sqlfool.com/2010/01/index-defrag-script-updates-beta-testers-needed/
Primary Key discovery and beyond.
As a part of my DB documentation process for a large database, I needed a method to quickly show me all of the Primary Keys in the database. Not only did I want the PKs, […]