DBA Tips: Reducing locks in SQL Server, PL/SQL tips, and more...

[SearchDatabase.com]

Title: DBA Tips

August 11, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > Computer Associates Unicenter® Database Management Software IN THIS ISSUE:   >  Performing incremental inserts/updates to reduce lock conditions   >  Get SQL Server table structure in XML format   >  The DB2 UDB memory model   >  SQL Server: Beta testers review Yukon's finer points   >  Oracle: PL/SQL tips and scripts   >  Share your DBMS experience with fellow geeks   >  Spotlight on SQL Server   Unicenter® Database Management Software The Right Software allows you to not only manage but master your complex database environment. Simplify the management of your database environment with CA's Unicenter® Database Management software. Regardless of how many databases you run, this comprehensive, and scalable cross-platform solution helps you manage your heterogeneous environment easily and efficiently, freeing you to focus on business-critical projects. To learn more, visit ca.com/udm   Performing incremental inserts/updates to reduce lock conditions [Serdar Yegulalp] Inserts and updates are two of the most common operations in SQL Server that cause locking. Here is a quick overview of these types of locks and how to prevent them. MORE INFO: > Hundreds more SQL Server tips and scripts Get SQL Server table structure in XML format [Baya Pavliashvili] Here is a quick stored procedure in SQL Server 2000 that returns the table structure in XML format. The DB2 UDB memory model [Sylvia Qi & Michael Dang] Learn how DB2 UDB for Linux, UNIX and Windows uses memory, how that memory use varies by platform, and how it affects your applications. SQL Server: Beta testers review Yukon's finer points [SearchDatabase.com] Yukon beta testers tell us what they love -- and lost -- in the newest version of SQL Server 2005. Oracle: PL/SQL tips and scripts [SearchOracle.com] If you need answers to tough SQL and PL/SQL questions, look no further. Here's a collection of technical tips, best practices and how-tos from SearchOracle.com and industry gurus. ASK THE EXPERT:  Share your DBMS experience with fellow geeks ITKnowledge Exchange is our new feature that allows Oracle, DB2, SQL Server, Sybase and MySQL pros to directly help one another solve pressing technical and strategic issues. Try it out! FEATURED TOPIC:  Spotlight on SQL Server Attention SQL Server administrators and developers! Scads of free tips, tutorials, and expert advice about SQL Server tuning, design, security, integration, and much more 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 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494