27. January 2008 19:24
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.
7. January 2008 22:06
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...