reading
You Should Read
archives
- September 2004
- October 2004
- November 2004
- December 2004
- January 2005
- April 2005
- May 2005
- June 2005
- July 2005
- August 2005
- September 2005
- October 2005
- November 2005
- December 2005
- January 2006
- February 2006
- March 2006
- April 2006
- May 2006
- June 2006
- July 2006
- August 2006
- September 2006
blogs I read
- Caspian Arts
- Coding Horror
- ComputerZen
- Joel On Software
- Knowing.net
- MSBuild Team Blog
- Rob Howard
- ScottGu
- Scott On Writting
- Signal vs. Noise
- SimpleBits Articles
Tuesday, January 17, 2006
Article of the Week 10
Title
Tips on Optimizing SQL Server Database Design
Author
Uknown
Description
This week's article is intended to get the database optimization juices flowing. Probably not a lot of new ideas in here, but it was a great refresher for me.
In my case, it reminded me that I may want to denormalize some of the Results Case specific data that I get by using a SELECT statement with 13 joins (ouch). I should take some time to review and refactor some of the more complex stored procs to see where there is room for improvement.