I Smell a Parameter!

re: I Smell a Parameter!

GilM — Sun, 02 Apr 2006 04:02:55 GMT

Good stuff!

This might be a good chance to lead into a discussion of plan guides, for users of third-party apps (like Siebel) that generate queries dynamically and don't allow adding hints directly to them; but still suffer with these problems of atypical parameters used in plan caching.

re: I Smell a Parameter!

Ayende Rahien — Thu, 06 Apr 2006 12:46:13 GMT

Can SQL Server get the parameter data from the a parametrized query as well?
That is, if I issue a parameterized query from ADO.Net, willit be able to optimize the plan based on the parameter value?

re: I Smell a Parameter!

bartduncan — Tue, 18 Apr 2006 04:46:21 GMT

Yes, parameterized queries can be sniffed just like stored procs.

IFNULL (location_id, 99) = COALESCE(@my_location_id, IFNULL(location_id, 99))

Tony Rogerson's ramblings — Wed, 17 May 2006 11:13:02 GMT

Hopefully this will put to bed the lobby that recommends you use COALESCE for queries that have optional...

Query Processing -- introduction to the blog!

Tips, Tricks, and Advice from the SQL Server Query Processing Team — Tue, 26 Sep 2006 03:52:19 GMT

Since we’re starting a new blog for the whole query processing team, we think it’s appropriate to start...

Compilation Time Issues in OLTP Applications When Upgrading to SQL 2005

Tips, Tricks, and Advice from the SQL Server Query Processing Team — Thu, 28 Sep 2006 00:45:32 GMT

I've helped a lot of people upgrade their SQL 2000 applications to SQL 2005.&nbsp;&nbsp;While many of...

Compilation Time Issues in OLTP Applications When Upgrading to SQL 2005

Tips, Tricks, and Advice from the SQL Server Query Processing Team — Fri, 13 Oct 2006 00:45:52 GMT

I've helped a lot of people upgrade their SQL 2000 applications to SQL 2005. While many of these upgrades

4.0 Query Parameterization

SQL Programmability & API Development Team Blog — Thu, 18 Jan 2007 21:56:10 GMT

Using parameters or parameter markers in queries increases the ability of SQL Server to reuse compiled

Elegant Code » SQL Parameter Sniffing and what to do about it

Elegant Code » SQL Parameter Sniffing and what to do about it — Sat, 17 May 2008 19:53:53 GMT

PingBack from http://elegantcode.com/2008/05/17/sql-parameter-sniffing-and-what-to-do-about-it/

Poor performance from Application « Motherofallgeeks’s Blog

Poor performance from Application « Motherofallgeeks’s Blog — Mon, 01 Dec 2008 06:20:53 GMT

PingBack from http://motherofallgeeks.com/2008/12/01/poor-performance-from-application/

OPTIMIZE FOR UNKNOWN - How could that possibly make any sense???

Conor vs. SQL — Fri, 16 Jan 2009 18:55:12 GMT

Yes, I'm alive. I have been chatting with my wife about the times I need to "go dark" - in this case,

Wierd performance problem. | keyongtech

Wierd performance problem. | keyongtech — Thu, 22 Jan 2009 06:31:53 GMT

PingBack from http://www.keyongtech.com/400015-wierd-performance-problem

DotNetBob on SQL » Blog Archive » Forced Pamareterization Pros and Cons

Wed, 18 Feb 2009 18:25:49 GMT

PingBack from http://sql.dotnetbob.com/?p=55

Conor vs. Dynamic SQL vs. Procedures vs. Plan Quality for Parameterized Queries

Conor vs. SQL — Thu, 04 Jun 2009 01:39:28 GMT

I received a question from a customer today about query plan choice for a parameterized query - specifically