Archives: February 2010
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 reasons. He was playing on the monkey bars, lost his grip and fell. A natural… Read more
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 information and ideas to use for this article. As trivial as it may seem,… Read more
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 improve performance and use of hardware and software resources. I am looking to make sure… Read more
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 set out to try and enlist in the Torino games. The Vancouver games snuck up… Read more
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 cell phone buzzing wildly on the nightstand from database or system generated alerts. There are… Read more
This is tightly related to another of my forays into tuning some slowly/poorly performing processes. This process came across my desk due to some reporting inaccuracies. The report is derived from data in a downstream process that is based on the data provided from this top level process. More precisely,… Read more
I recently blogged about a solution I had decided to use in order to solve a problem related to PayPeriod Matching. The result needed to meet a few requirements. One of those requirements was to arrive at the results without the use of a Table. I did not want… Read more
This month Rob Farley is hosting TSQL-Tuesday #3. The topic is Relationships and he has left it wide open for interpretation so long as it can be tied to the theme and SQL Server.
At first my thought was to republish one of the articles in my series on… Read more
Today I ran across Paul Randal’s latest post showing how to find open transactions and such. This is a nice little script and would prove very useful in certain circumstances. An obvious circumstance would in trying to find what is causing the transaction log to fill or even grow. Paul… Read more
In Part I and Part II of the series, I discussed documenting and discovering Primary Keys and Clustered Indexes. In this article I will show how to document table relationships from a hierarchical standpoint. The type of documentation I will demonstrate in this article will prove insightful and useful –… Read more