Archives: January 2010
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:
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.
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
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
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
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
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
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
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
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
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
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
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
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
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