Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: February 2010

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 reasons.  He was playing on the monkey bars, lost his grip and fell.  A natural… Read more

2 comments, 176 reads

Posted in SQL RNNR on 25 February 2010

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 information and ideas to use for this article.  As trivial as it may seem,… Read more

3 comments, 207 reads

Posted in SQL RNNR on 23 February 2010

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 improve performance and use of hardware and software resources.  I am looking to make sure… Read more

2 comments, 201 reads

Posted in SQL RNNR on 21 February 2010

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 set out to try and enlist in the Torino games.  The Vancouver games snuck up… Read more

3 comments, 270 reads

Posted in SQL RNNR on 18 February 2010

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 cell phone buzzing wildly on the nightstand from database or system generated alerts.  There are… Read more

16 comments, 415 reads

Posted in SQL RNNR on 17 February 2010

In Vs. Inner Join

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

0 comments, 215 reads

Posted in SQL RNNR on 16 February 2010

PayPeriod II

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

0 comments, 243 reads

Posted in SQL RNNR on 14 February 2010

Relationships

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

3 comments, 300 reads

Posted in SQL RNNR on 9 February 2010

Log is Filling Up

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

0 comments, 218 reads

Posted in SQL RNNR on 5 February 2010

Key Discovery III

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

6 comments, 399 reads

Posted in SQL RNNR on 2 February 2010