Ask the Experts: Three rules of thumb for triggers

[Search390.com]

Title: Ask The Experts

October 21, 2004 Published by  Search390.com Ask The Experts NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > KnowledgeStorm IN THIS ISSUE:   >  Three rules of thumb for triggers   >  What authority non-DBAs need to create triggers   >  DBA duties   >  How important is database management?   >  DB2 performance tuning Three rules of thumb for triggers [Search390.com] A Search390.com user asked: We have had a lot of discussions about triggers. Some say it's better to write the code in an application program and some say it's better with a trigger. If we should use either one, when should we use it? Some say -- don't use AFTER-triggers or not on high transaction applications. Is that true? Click here to see the answer.   KnowledgeStorm One of the best research tools for new product purchasing is right at your fingertips. Visit the Search390.com Product and Vendor Guide, powered by KnowledgeStorm, to compare specific hardware and software solutions. Don't jump from one vendor site to the next -- do all your comparisons all in one place. You can also receive quotes directly Click Here   What authority non-DBAs need to create triggers [Search390.com] A Search390.com user asked: What authority would a non-DBA need to create a DB2 trigger? We are using Endevor and processors to create triggers. We were successful in creating stored procedures and thought triggers required similar authorization. Click here to see the answer. DBA duties [Search390.com] A Search390.com user asked: What is the role of a DBA? Click here to see the answer. How important is database management? [Search390.com] A Search390.com user asked: Four questions: How important is the database management system on the firm, how do you maintain the database management system, how often do you upgrade an information system, and how does an information system work? Click here to see the answer. FEATURED TOPIC:  DB2 performance tuning Getting the best performance out of DB2 isn't easy but with some proper tuning and some planning, any mainframe shop can have their database purring like a kitten. TIP:  Big changes in store for systems management technology, culture Systems management will soon become much more tied to business functions. But data center culture has to change, too, to incorporate and more fully use the tools that are already available and to begin negotiating with end users about the service levels they can realistically expect. ITKNOWLEDGE EXCHANGE:  Help us beta test this new feature ITKnowledge Exchange is a place where storage professionals can share ideas, expertise and get difficult technical questions answered by other IT pros. Better than a forum or a listserv, it provides the opportunity to collaborate with groups and individual experts who share similar areas of IT expertise. This new feature is currently in beta. Sign up today and help us make it a success! Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED] Free E-Newsletters! Select e-newsletters you would like to receive via e-mail! Search390: Today's News Not a Member? We'll activate your membership with your subscription. ABOUT THIS E-NEWSLETTER This e-newsletter is published by Search390.com, a targeted Web site from TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "Ask The Experts": Go to unsubscribe: http://search390.techtarget.com/u?track=NL-16 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: Search390 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494