Best Practices for Query Parameterization

By Guest Authors on 24 January 2007 | 0 Comments | Tags: Query Tuning

More goodness from the SQL Programmability & API Development Team Blog. This time they cover best practices for writing "parameterizable" queries. The cover writing SQL on both the client and server-side queries. A very, very good post. Follow the link to Best Practices for Query Parameterization...

Discuss this article: 0 Comments so far. Print this Article.

If you like this article you can sign up for our weekly newsletter. There's an opt-out link at the bottom of each newsletter so it's easy to unsubscribe at any time.

Email Address:

Related Articles

What I Wish Developers Knew About SQL Server (Presentation) (11 October 2007)

Avoid enclosing Indexed Columns in a Function in the WHERE clause (12 September 2007)

Introduction to Parameterization in SQL Server (7 August 2007)

Query Parameterization and Plan Cache (23 January 2007)

Analyzing and Optimizing T-SQL Query Performance on Microsoft SQL Server using SET and DBCC (PDF) (25 July 2002)

Five Ways to Rev up Your SQL Performance (27 June 2002)

Other Recent Forum Posts

select Distinct not working like mysql. (4 Replies)

PowerBuilder to SpatiaLite (0 Replies)

SQL ISSUE (1 Reply)

Executing several SQL scripts from a bat file (2 Replies)

Joining 3 tables with the 3rd as optional (1 Reply)

How to get rows containing value in comma seprated (4 Replies)

add one day to the current date (1 Reply)

Calculating Growth rate (2 Replies)

Subscribe to SQLTeam.com

Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

SQL Server Resources

Advertise on SQLTeam.com

SQL Server Books

SQLTeam.com Newsletter

Contact Us

About the Site