The following commands will clear any cached query plans in SQL 2005. This will allow you to better troubleshoot errors related to query plan generation.

The importance of well formatted code can be appreciated by any seasoned professional.  This is transient across any language I've dealt with, including SQL.  Visual Studio has functionality for auto-formatting your XHTML, C#, and VB.NET code (CTRL+K, CTRL+D), but SQL Management Studio, a derivative of Visual Studio, doesn't have such a luxury for SQL/TSQL code.

Instant SQL Formatter does have a functional online formatter for neatening up your SQL script for free.  Additionally, for a price, you can download an add-in to Visual Studio, or SQL Management Studio for embedded functionality.More...