DBA Tips: Using lock hints in SQL Server, and more...

[SearchDatabase.com]

Title: DBA Tips

May 19, 2004 Published by  SearchDatabase.com DBA Tips Issue Sponsored By: SearchDatabase.com Career Center IN THIS ISSUE: When -- and when not -- to use lock hints in SQL Server 7 and 2000 Oracle: Optimize your undo parameters Users get the buzz on 'Stinger' Good planning, service packs help avoid DB2 outages Featured Topic: The relational model SearchDatabase.com Career Center 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! Click Here When -- and when not -- to use lock hints in SQL Server 7 and 2000 [Serdar Yegulalp] 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. MORE INFO: Hundreds more SQL Server tips and scripts Oracle: Optimize your undo parameters [Marco Gilbert] Here is a script that will help you optimize your resources when working with UNDO. Users get the buzz on 'Stinger' [SearchDatabase.com] 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 [SearchDatabase.com] 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. ASK THE EXPERTS: Ask the Expert: Find the highest value in each row Our SQL expert Rudy Limeback answes a question about finding the highest value in each row. TOPICS: Featured Topic: The relational model 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 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] 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. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "DBA Tips": Go to unsubscribe: http://searchDatabase.techtarget.com/u?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 MemberServices 117 Kendrick Street, Suite 800 Needham, MA 02494