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…

Planning ahead… Deprecation


Spending a little time planning and researching can often extend a products economically sustainable lifespan by a substantial amount. Let’s take a quick look at this from a SQL perspective in this fictional example: Project A comes along and you need to maximise the lifespan of the application and provide a clear upgrade path to…

New SQL Blog – Optimise Optimize Optimise


Love query optimisation? The SQL Server Query Processor team have started a new blog “Tips, Tricks, and Advice from the SQL Server Query Processing Team”. They also link to an old blog I hadn’t come across before which appears to have a ton of information! It’s going to be a late night! On a side…