On Jan 31, 2008 12:15 PM, William Bowen <[EMAIL PROTECTED]> wrote: > 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 :-) > > Which of course means check your indexes as well... a simply query of 11,000 records, or even 110,000 records...should be instantaneous if your indexes are set up right.
-- Medical language won't ever help to shape this If that mind is just as frail as the frame ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:252833 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5