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:
http://sqlfool.com/2010/01/index-defrag-script-updates-beta-testers-needed/
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