Archives: July 2011
Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head blocker in a blocking chain. That script can be found here. I was looking at the script and thought it looked pretty cool and also wondered why it… Read more
This is just a quick note to remind anybody who may be interested of the upcoming Las Vegas User Group meeting.
As I posted here, we will be learning OLAP for the OLTP pro. This will be presented by Charley the chapter President.
Also note, this meeting is available… Read more
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that post needs revisiting. This is one of my more favorite scripts and I still have more ideas to implement with it. The post/script in question can be found here. Read more
Did you know that your sign may have changed? I didn’t – at least not until reading the meme Monday announcement. Most people probably will see no difference in their astrological sign. However, if you believe that there is a new all powerful 13th sign and if your sign is… Read more
We have had a bit of a lag between meetings for the User Group of Las Vegas. In June, a meeting was scheduled but did not happen. The cause of that was due to being locked out once again by our meeting place. That should not happen this month –… Read more
This past Fourth of July weekend I had the opportunity to do a few different things and thought I would share some experiences. None of these experiences were job related but the lessons from these experiences could be applied to SQL and databases. I will explain that a little bit… Read more
I was reading a blog by Pinal Dave that was about using catalog views to obtain information about stats for the entire database. While reading the blog, I was reminded about an interesting tidbit of information I had seen once upon a time concerning statistics naming in SQL Server.
This… Read more