You can work off the assumption that all of your queries will benefit. While I'm sure they exist, I've never seen a query that wasn't faster using bind variables.
On 8/10/07, Ben Mueller <[EMAIL PROTECTED]> wrote: > > Okay, now I need to do some homework. Are there resources anywhere that > can help tell me what queries would benefit from such things? My knowledge > of SQL is decent, but isn't quite *that* deep. I would think all queries > would benefit from that. > > Ben > > > >> Am I going to see a significant performance increase? For > >> the sake of argument, pretend that sample query I included in > >> my first post is heavily hit. I'm running SQL Server 2000 > >> (soon to upgrade to 2005). > > > >The answer will depend on whether that particular query benefits from a > >generic, reusable execution plan. > > > >Dave Watts, CTO, Fig Leaf Software > >http://www.figleaf.com/ > > > >Fig Leaf Software provides the highest caliber vendor-authorized > >instruction at our training centers in Washington DC, Atlanta, > >Chicago, Baltimore, Northern Virginia, or on-site at your location. > >Visit http://training.figleaf.com/ for more information! > > > >This email has been processed by SmoothZap - www.smoothwall.net > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285981 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
