DBA Tips: The DB2 memory model, and more...

[SearchDatabase.com]

Title: DBA Tips

August 05, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > Quest Software IN THIS ISSUE:   >  The DB2 UDB memory model   >  Get SQL Server table structure in XML format   >  Consolidating DB2/390 dataset extents   >  SQL Server: Verifying input to be passed to a SQL statement   >  Oracle: EXPLAIN and understand   >  Share your DBMS experience with your peers   >  MySQL on the rise   SQL Server Performance Baselining, Benchmarking and Monitoring It's difficult to tune a SQL Server without understanding its performance profile. Download Quest Software's new white paper to learn techniques for assessing a baseline performance profile, setting benchmarks under varying workloads, and monitoring for maximum availability and performance of SQL Server 2000. Click here   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. MORE INFO: > Hundreds more DB2 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. Consolidating DB2/390 dataset extents [Nick Nur] You can use SMS on the mainframe to consolidate dataset extents easily and quickly without recovering the tablespace. Here's how. SQL Server: Verifying input to be passed to a SQL statement [Serdar Yegulalp] In SQL Server, data cannot be passed as-is to a SQL statement without some pre-processing. Here's a quick explanation why. Oracle: EXPLAIN and understand [Kimberly Floss] What are some obvious red flags that can show up in EXPLAIN plan output? Guru Kimberly Floss provides some answers. From our a 12-part series on Oracle10g CBO internals and SQL tuning optimization, based on a new book from Rampant Press. ASK THE EXPERT:  Share your DBMS experience with your peers 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:  MySQL on the rise MySQL is a low-cost, open source DBMS that is gaining ground in the enterprise. Learn more with our collection of tech tips, expert advice, and news. 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