DBA Tips: J2EE best practices, storing images in SQL Server, and more...

[SearchDatabase.com]

Title: DBA Tips

July 08, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ASK THE EXPERTS     TIPS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > SearchDatabase.com Career Center Brought to you in partnership with: IN THIS ISSUE:   >  The Top 10 (more or less) J2EE best practices   >  SQL Server: Avoid using BLOBs to store image data   >  Oracle: Saving time on nightly table rebuilds   >  Composite keys in M:N relationship tables   >  Java and JDBC 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.... MORE INFO: > Featured Topic: Java and JDBC   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   SQL Server: Avoid using BLOBs to store image data [Serdar Yegulalp] As elegant an idea as storing images as BLOBs may sound, it's simply not a very good one, and there are several reasons for this... Oracle: Saving time on nightly table rebuilds [Andrew Kerber] Here is a script that gathers stats on a table using the dbms_stats package. ASK THE EXPERT:  Composite keys in M:N relationship tables Our SQL expert Rudy Limeback answers the question: "What is the general procedure for dealing with M:N relationships encountered during the process of database design? Are composite keys always a straightforward solution?" FEATURED TOPIC:  Java and JDBC No longer the new kid on the block, Java is now an established enterprise database development language, with Oracle and DB2 coders leading the way. We have scads of Java, J2EE, JDBC, and SQLJ resources 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