Parameterized Queries

Previous T-SQL best practices articles have discussed different coding styles that led to slow and fast query executions, and ways to minimize cached plans. This article will be an extension on those concepts, focusing on how the SQL Server optimizer tries to parameterize a query if it can, as well as how you can build your own parameterized query.

Getting rid of SQL Code

Joe becomes intrigued by the way that experts make errors in any area of technology, and suggests that the problem is more that of mindsets than lack of knowledge. He illustrates the point with SQL Development by means of the "Britney Spears, Automobiles and Squids" table, and the tangled Stored procedure, and shows ways of getting rid of both procedural and non-procedural code by adopting a different programming mindset.

How To Get Table Row Counts Quickly And Painlessly

Use sysindexes\DMVs insead of select count(*) to retreive table row counts

group by

Building Code that Promotes Plan Re-usage

This article, the third in the T-SQL Best Practices series, discusses how to write your code to promote cached plan re-usage. Understanding how white space and comments impact whether a plan is cached or an existing plan is re-used can help you minimize the number of plans your application is caching.

Execute T-SQL Scripts in Parallel

Transact-SQL does not have a simple method to launch multiple parallel running scripts. This tool will change the game. It requires SQL Server 2005 or above.

LIKEable Brackets

SQL 2008 T-SQL

Sending multiple rows to the Database from an Application: Part II

In part 2 of this series, Mohd Nizamuddin looks at sending multiple rows to the database from an application using XML.

cast, convert and float!