SearchDatabase.com: DBA Tips May 19, 2004 ___________________________________
ISSUE SPONSORED BY: SearchDatabase.com Career Center ___________________________________ IN THIS ISSUE: -- When -- and when not -- to use lock hints in SQL Server -- Oracle: Optimize your undo parameters -- DB2: Users get the buzz on 'Stinger' -- Good planning, service packs help avoid DB2 outages -- Featured Topic: The relational model ::::::::::::::::::::::::: SPONSOR ::::::::::::::::::::::::: How does your salary compare to those of your peers? Visit SearchDatabase.com's Career Center powered by Dice and take our salary survey. Find training, certification, resume resources and over 27,000 IT job openings to search through. Register now and access a host of career resources! http://ttarget.adbureau.net/adclick/CID=00004dba0000000000000000/acc_random=981725040/site=searchdatabase/area=em.41/aamsz=1x1/position=1/keyword=C483154 :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ___________________________________ THIS WEEK'S TIPS: WHEN -- AND WHEN NOT -- TO USE LOCK HINTS IN SQL SERVER 7 AND 2000 | Serdar Yegulalp http://www.searchDatabase.com/tip/1,289483,sid13_gci965641,00.html?track=NL-94&ad=483154 Lock hinting is a function in SQL Server that allows the author of a SQL query to indicate how locking should be implemented when the query is run. Here is a brief introduction. ORACLE: OPTIMIZE YOUR UNDO PARAMETERS | Marco Gilbert http://www.searchOracle.com/tip/1,289483,sid41_gci961669,00.html?track=NL-94&ad=483154 Here is a script that will help you optimize your resources when working with UNDO. USERS GET THE BUZZ ON 'STINGER' | SearchDatabase.com http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci965279,00.html?track=NL-94&ad=483154 IBM has unveiled more technical details of the next version of its DB2 Universal Database, code named "Stinger." By automating features deep within the DBMS, Big Blue is giving DBAs time to work on more meaningful projects, according to the lead architect. GOOD PLANNING, SERVICE PACKS HELP AVOID DB2 OUTAGES http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci964709,00.html?track=NL-94&ad=483154 Most companies have trouble keeping up with service packs, but a DB2 engineer says you should apply updates several times a year in order to eliminate costly downtime. ___________________________________ ALSO ON SEARCHDATABASE.COM: ASK THE EXPERT: FIND THE HIGHEST VALUE IN EACH ROW http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid587914_tax285649,00.html?track=NL-94&ad=483154 Our SQL expert Rudy Limeback answes a question about finding the highest value in each row. FEATURED TOPIC: THE RELATIONAL MODEL http://www.searchdatabase.com/featuredTopic/0,290042,sid13_gci779242,00.html?track=NL-94&ad=483154 Ted Codd's groundbreaking application of logic and set theory to data management lives on. Go back to basics with our collection of relational model tutorials, columns, and advice inside... ___________________________________ CONTACT US: For sales inquiries, please contact us at: mailto:[EMAIL PROTECTED] For feedback about any of our articles or to send us your article ideas, please contact us at: mailto:[EMAIL PROTECTED] ___________________________________ ABOUT THIS E-NEWSLETTER: This e-newsletter is published by SearchDatabase.com, a targeted Web site from TechTarget, the most targeted IT media and events company. TechTarget offers magazines, Web sites, e-newsletters, Webcasts and conferences for enterprise IT professionals. Copyright 2004 TechTarget. All rights reserved. _____________________________________________________________________ To unsubscribe from "DBA Tips": Go to unsubscribe: http://SearchDatabase.com/u?cid=483154&lid=430854&track=NL-94 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: SearchDatabase Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494
