SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: January 2010

SQLFool IDX Defrag Scripts

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:


Read more

0 comments, 895 reads

Posted in SQL RNNR on 26 January 2010

Tweeting – I took the Dive.

In a previous post, I questioned how much Twitter could really do for me.  After some comments made, and some other blog posts that I have read – I decided to take the dive.

Andy Warren and Glenn Berry, both blogged about their twitter experiences after my last… Read more

1 comments, 596 reads

Posted in SQL RNNR on 26 January 2010

Indexes Out the Window II

In Part I, I discussed some of the peculiarities and troubleshooting done in relation to a peculiar execution plan.  In this post, I will discuss some of what I did to further tune the query.

First, a little more background into the design of this query.  This query uses… Read more

2 comments, 829 reads

Posted in SQL RNNR on 26 January 2010

Indexes Out the Window

I ran into a peculiarly puzzling situation with a query I have been tuning of late.  The query runs some aggregations and performs a range scan based on a date value passed to the query.  The primary target for this query is to be consumed by reporting services.  The query… Read more

6 comments, 1,067 reads

Posted in SQL RNNR on 23 January 2010

PayPeriod Matching

Recently I was asked to alter a report to pull different more meaningful data.  The particular report was pulling data from the datawarehouse.  It had been recently modified to use a stored procedure (and subsequently improved performance 10 fold).  Due to this change, the report started showing differently.  The report… Read more

0 comments, 979 reads

Posted in SQL RNNR on 21 January 2010

Tweet, Tweet, Tweetilly Deet

In a day and age when information abounds and social networking is the only way to communicate (a bit of an exaggeration, I know), it seems to be a rarity when one does not conform.  I just happen to be one of those rarities.

I don’t find the need currently… Read more

4 comments, 509 reads

Posted in SQL RNNR on 19 January 2010

Leaving on a Jet Plane

Ok, so it’s not until November – but I am leaving on a Jet Plane nonetheless.  It will have been four years since the last time I attended PASS Summit.  This year, my ticket is already punched.

Missing this Conference each of the last few years has stung quite a… Read more

3 comments, 542 reads

Posted in SQL RNNR on 18 January 2010

Presentations – Lessons Learned

This will be a very short entry.  I just wanted to share a few things  I learned very quickly while prepping for my most recent presentation for SSSOLV (Las Vegas PASS).

First, while doing the slides and testing the SQL, it dawned on me that I could probably… Read more

0 comments, 847 reads

Posted in SQL RNNR on 15 January 2010

TSQL Tuesday – But I was Late

I was late to the game having discovered the Blog Post the day after entries were allowed.  Despite that, I will trackback to the Adam Machanics Blog Post.  I read the rules and fully understand that it will only count for me having done the exercise and my own… Read more

2 comments, 820 reads

Posted in SQL RNNR on 14 January 2010

Primary Key Discovery II

In Part I, I discussed a couple of scripts that could be used to help discover some vital information about all of the PKs in the database very quickly.  I also delved into a performance analysis of the two queries.

The scripts presented showed a very basic discovery of… Read more

1 comments, 621 reads

Posted in SQL RNNR on 13 January 2010

Professional Communications

This past week I had the opportunity to have lunch with a vendor at his clients’ site.  As a part of the lunch there is the usual dog and pony show.  Vendors are trying to get you to buy their product after-all.

After this rendez-vous, I have had the opportunity… Read more

3 comments, 501 reads

Posted in SQL RNNR on 10 January 2010

Goals For 2010

Like a lemming in the DBA community, I too am going to post my 2010 goals.  I am looking to create goals that are measurable.

1.  Start a BLOG (that was a goal at the start of the year, and I jumped right on it).

I wanted to realistically try… Read more

0 comments, 445 reads

Posted in SQL RNNR on 8 January 2010

SSC Syndication

Steve Jones at SqlServerCentral.com has created a Blog for me over there at SqlServerCentral.com.  I will be syndicated there and hopefully increase the Blog exposure a little bit.  This being a new adventure (the whole Blog idea), this is a good move for me at this time.  Through Blogging, I… Read more

0 comments, 591 reads

Posted in SQL RNNR on 7 January 2010

Primary Key Discovery

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, but I wanted to know the DataType for each of the Primary Keys.

I began… Read more

0 comments, 686 reads

Posted in SQL RNNR on 5 January 2010

Users Group Participation

I have been pondering over my local PASS chapter and participation.  And more specifically about why I should participate, and to what level should I participate.

Is attendance enough, or should participation include something more?  What are some of the pros and cons of participating in the User Group?

One… Read more

0 comments, 971 reads

Posted in SQL RNNR on 4 January 2010