DBA Tips: Get SQL Server table structure in XML format, and more...

[SearchDatabase.com]

Title: DBA Tips

July 29, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > SearchDatabase.com Career Center IN THIS ISSUE:   >  Get SQL Server table structure in XML format   >  The Top 10 (more or less) J2EE best practices   >  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   >  DBMS Learning Guides 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. MORE INFO: > Hundreds more SQL Server tips and scripts   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   The Top 10 (more or less) J2EE best practices [Kyle Brown, Keys Botzum and Ruth Willenborg] Much has been written in recent years about J2EE best practices, including books and articles offering insight into how J2EE apps should be written. To provide some guidance, we've compiled a list of the most important of these.... 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 communicate with each to solve pressing technical and strategic issues. Try it out! FEATURED TOPIC:  DBMS Learning Guides Our popular Learning Guides are packed with high quality tutorials, expert advice and tips that will help you get up to speed on the most critical topics in data management. Enjoy! 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