=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips March 27, 2002
Essential tools and advice for the enterprise DBA: http://searchDatabase.techtarget.com/tips/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ___________________________________________________________________ *************** FREE WINDOWS DECISIONS CONFERENCE ***************** WHO SHOULD ATTEND: IT professionals who want to gain focused expertise on Active Directory, security, licensing, manageability, interoperability and more. Plus strategies to make the smartest Windows technical and purchasing decisions to maximize ROI. WHEN: May 8-10, 2002. WHERE: Hilton Chicago Hotel. HOW: Qualify for FREE attendance directly at http://ad.doubleclick.net/clk;3903337;5058249;m?http://www.windowsdecisions.com/ ___________________________________________________________________ IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Oracle: Exception handling - SQL Server: ODBC IP connection troubleshooting - Oracle: Notify Oracle application users - SQL Server: Execute a statement against a dynamic list - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Expert: Your SQL and Oracle questions answered - Featured Topic: Database design tips & tricks ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE EXCEPTION HANDLING | by Jeffrey Toth Demonstrates how to use nested blocks and exception handlers to control the flow of execution when exceptions are raised. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci811973,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ODBC IP CONNECTION TROUBLESHOOTING | by Tim Fenner A tip about how to resolve MDAC and connection issues in SQL Server 7 & 2000. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci804490,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= NOTIFY ORACLE APPLICATION USERS | by Shankar Govindan Here is a script that spools the Mail ID's of Oracle Application users and mails them whatever you want to notify them about. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci799186,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= EXECUTE A STATEMENT AGAINST A DYNAMIC LIST | by Hector Mejia Need to execute a statement that performs an action validating against a list of values, but the list changes from one run to the other? Or perhaps the list is built dynamically within a stored procedure? Here's how: DECLARE @ProdList as varchar(200) SET @ProdList = "'PROD1','PROD2','PROD3'" EXECUTE ('DELETE FROM tblProducts WHERE ProductID IN (' + @ProdList + ')') >> CLICK for the online version of the tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci809889,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE JAVA APPLICATION PERFORMANCE, PART 2: JDBC DRIVER COMPARISONS | John Carnell, et al. http://www.searchDatabase.com/tip/1,289483,sid13_gci811475,00.html A detailed comparison of the performance differnces between several types of JDBC drivers: the OCI (Type 2) and thin drivers. Three tests were performed. Click above for the results... GENERATE A BAR GRAPH FOR TABLESPACE UTILIZATION | by Shishir Dani http://www.searchDatabase.com/tip/1,289483,sid13_gci809865,00.html Almost all Oracle DBAs need to continually check the status of various tablespaces in the database. Here is a SQL script that will generate a bar graph showing the status of tablespaces in the database. CREATING STANDBY DATABASES IN SQL SERVER | by Krishnan Ramakrishnan http://www.searchDatabase.com/tip/1,289483,sid13_gci809859,00.html It is a common practice to create a replica database for server testing but this can also be done for backup purposes. Using DTS with the option to transfer all objects can be very time-consuming. Generating insert scripts would require a special utility so that the dependencies are managed. The easier way is to do the steps in this tip. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge, submit a tip: win a CENDYNE CD-RW DRIVE http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz805991_cts805990,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered Oracle: Oracle's security features http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid457066_tax285650,00.html Oracle: Performance degradation during online backups http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid457064_tax285650,00.html Oracle: Dates in SQL*Plus: queries vs. display http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid457056_tax285650,00.html SQL Server: Future for triggers http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid457709_tax285648,00.html SQL Server: Identifying exact lock escalation http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid457710_tax285648,00.html Hundreds more free expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE DESIGN TIPS & TRICKS | SearchDatabase Featured Topic A critical goal for both developers and DBAs is to design stable, fast and secure databases. To help you in this endeavor, we present a collection of tips and expert advice about logical and physical design. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci811735,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Submit your original tip here. TIM DICHIARA, Site Editor (mailto:[EMAIL PROTECTED]) >> Send your feedback and original articles. SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) >> Send your White Papers and favorite Web sites. ED PARRY, News Editor (mailto:[EMAIL PROTECTED]) >> Send your product announcements and poll ideas. TOM CLICK, Sales (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002, All Rights Reserved. If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://searchDatabase.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.
