I Just had an article published at SQLServercentral on troubleshooting the cause of log growths. At the conclusion of that article I had a reference to my blog with the expectation of having had time […]
Category: News
IO IO IO
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 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 […]
DBA MD
I just had the opportunity to spend some time with my four year old son at the doctor’s office. It was a painful experience, for my son as well as myself – but for different […]
Why All The Fuzz?
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 […]
I’m givin’ ‘er all she’s got!
Or am I? As I proceed down the path on a consolidation project, I have taken time to pause and ponder the approach. One driving goal is to shrink our footprint. Another goal is to […]
May I help you?
With the Vancouver games underway, I have been reflecting on the 2002 Winter Olympic Games. Those were the greatest winter games ever. With or without the Figure Skating scandal. Upon completion of those games, I […]
DBA.Sleep(8hrs)
I have been pondering recently what helps me to sleep at night. Or, conversely, what prevents me from sleeping at night. This is different than the calls in the middle of the night or the […]
In Vs. Inner Join
This is tightly related to another of my forays into tuning some slowly/poorly performing processes.