T-SQL Static Analysis 2005 & 2008 — Analysis and Review


In October 2007 I wrote a review on the T-SQL Static Analysis feature provided in the Visual Studio Team Edition for Database Professionals Power Tools. In February this year Microsoft released Version 2 of the Power Tools, Visual Studio┬« Team System 2008 Database Edition Power Tools (available here). For Static Analysis, Version 2 provides very…

T-SQL Static Analysis — Analysis and Review


In the middle of August 07, Microsoft released the Visual Studio Team Edition for Database Professionals Power Tools (available here). T-SQL Static Analysis is one of the features in this first release. There are fourteen rules that it currently uses when scanning SQL code. They fall into three categories: Microsoft.Design SR0001 – Avoid SELECT *…

The rise of TOP, and fall of ROWCOUNT


In SQL Server 2005, TOP has gained a few new capabilities. SELECT TOP (scalar expression | variable | subquery) [PERCENT] *FROM    aTable TOP can also be used in DML statements. Previously you may have used ROWCOUNT to limit the affected data, but apparently from Katmai (next version of SQL Server) ROWCOUNT will have no affect…

SQL Query Analyzer 2005


No such thing unfortunately. If you have moved to SQL server 2005, your world of Enterprise Manager and SQL Query Analyzer has been replaced with SQL Server Management Studio (SSMS). This is a great new IDE, but now I need to go through several clicks just to write a query… Start SSMS (Click: 1), Let’s…