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 […]
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. […]
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. […]
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 […]
Tweet, Tweet, Tweetilly Deet
Social networking and the time crunch.