Is this a shameless plug by a cloaked www.disc.com employee???? I think so!!! <grin>
Attn everyone: Feel free to ask questions that I am able to answer! Until then, I will just keep reading all the messages that come through. :) -----Original Message----- From: Zachary Bowling [mailto:zbowling@;direct-alliance.com] Sent: Thursday, November 14, 2002 2:07 PM To: SQL Subject: Omnidex Has anyone ever used, or do you currently use Omnidex by Disc Networks? www.disc.com If so, what are your feelings on the product? -----Original Message----- From: [EMAIL PROTECTED] [mailto:mdinowit@;houseoffusion.com] Sent: Sunday, November 10, 2002 5:37 PM To: SQL Subject: SP creation I was looking at the SQL 2k stored procedure wizard and noticed that it does not have anything for select. I was under the impression that a select based stored procedure would be quicker than a non-stored procedure version. Was I wrong? Is there a different way to set them up with the wizard? Should views be used? What's the threshold of savings when using stored procedures? (I've used them in the past with earlier versions of SQL but I'm unsure of any changes in 2k and efficiency) Thanks Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Get the mailserver that powers this list at http://www.coolfusion.com
