December 2007 - Posts

• Exists Vs. Count(*) - The battle never ends...

  I am still amazed at how many of the database applications written today still disregard some basic rules of thumb when it comes to accessing the data. One in particular is the use of COUNT(*) to check to see if there are any rows that Read More... Posted Saturday, December 15, 2007 9:27 PM by Andrew Kelly | 14 Comments Filed under: Documentation, Delevoper, Tips & Tricks

• Vista's Perfmon Reports

  A short while back I had to buy a new laptop and one of the choices I had to make was whether to run Vista or XP. While that is the subject for a whole different blog post the short answer is I decided to go with Vista Ultimate. I knew a lot of Read More... Posted Friday, December 14, 2007 10:48 PM by Andrew Kelly | 0 Comments