Elaborate please... I'll swear that MM used to recommend this as a best practice.. I need all the SQL Server performance I can get, If I'm doing something wrong I'd like to correct it..
Thanks sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 14, 2005 11:02 am To: CF-Talk Subject: RE: MS SQL - Cannot Find Stored Procedure Importance: Low > I've always seen it as a "best practice" I've seen no > performance hits. I have to deal with FoxPro tables along > with SQL Server, and this seems to work when the FoxPro guys > make table changes. That's about as far from a best practice as you can get, with MS SQL Server. It's a terrible thing to do if you're using SQL Server, in most cases. There's quite a bit of overhead in creating and destroying database connections unnecessarily. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209411 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54