You're most welcome. I took a SQL Server 2005 performance tuning and optimization class right before Christmas and many of the lessons were simple little exercises like that... nice to get a chance to exercise them :-)
On Jan 31, 2008 10:03 AM, Erika L. Walker <[EMAIL PROTECTED]> wrote: > got to be CF then .. because like I said, it's a simple select statement. > there's nothing to work on. > I'll go take a looksee in CFAdmin ... > > Thanks! > > On 1/31/08, William Bowen <[EMAIL PROTECTED]> wrote: > > > > Run your SQL in Query Analyzer and see if it times out. > > > > If it doesn't time out then the issue is probably a CF setting. If it > > does time out, then you'll need to work on the query a bit... -- will "If my life weren't funny, it would just be true; and that would just be unacceptable." - Carrie Fisher ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:252832 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
