Well, March Madness is quickly coming to a close.  I was very happy to see Xavier not go to the Final Four this year.   I am a Huggins fan.  I attended UC during the golden era of our Final Four days.  It's just been bred in me to, and I'll be nice here, "dislike" Xavier.  Think Crosstown Shootout.  If you've had a chance to browse any of my other posts you should realize I'm a nerd.  With that being said I was also in the Pep Band and attend all home games.  Ah, the excitement.

If you also felt the sweet revenge watching UCLA as they wiped the floor with Xavier please feel free to leave a comment.

I attended my second meeting on 03/25/08 and the guest speaker was Chris Barth. Chris gave a great presentation on tuning and troubleshooting queries in SQL Server 2005.

Topics

• Steps in determining when a stored procedure should be tuned.
• Seek or Scan? How to read query plans.
• System tables that will help you determine what transact-sql is performing poorly.
• Overviews of SET statements that will assist in troubleshooting transact-sql.
• The negative performance effects resulting from poor performing update or delete queries and stored procedures.
• Steps for writing better performing queries

This was a really good meeting in regards to what we’re doing with our database. I was able to learn a lot about when and when not to tune queries. The biggest lessons I can take from the meeting is to really know your system tables and think pages.

The Central Ohio Day of .NET is quickly approaching. This years meeting is in Wilmington, OH on 04/19/08. The Central Ohio Day of .NET is a joint venture between the Dayton .NET Developers Group, Central Ohio .NET Developers Group and the Cincinnati .NET Users Group.

Please visit http://cinnug.org/cododn for more information.