SEARCHDATABASE.COM | Database Administrator Tips November 20, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Top Ten SQL Performance Tips by Sheryl Larsen http://searchDatabase.com/r/0,,7688,00.htm?whitepaper =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Convert BLOB to CLOB - SQL Server: Dangerous ANSI options - Oracle: Script to determine OS PID for timed-out sessions - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: Database security ___________________________________________________________________ ****************** Sponsored by Quest Software ******************** Does your OS/390 or z/OS SQL need a performance boost? Get DB2 expert Sheryl Larsen's first white paper with Quest Software, "Top Ten SQL Performance Tips" and learn tips and tricks on getting the most performance out of your SQL today. Plus, you'll discover how Quest Central(tm) for DB2's SQL tuning module makes it easy to identify poorly designed SQL and apply these tips for improved performance. Download your white paper today! http://searchDatabase.com/r/0,,7688,00.htm?whitepaper ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: CONVERT BLOB TO CLOB | Prashant Dahalkar Here is a small Java program for DB2 7.1 that converts the datatype of a column from BLOB to CLOB. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci860034,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DANGEROUS ANSI OPTIONS | Baya Pavliashvili ANSI options make SQL Server compatible with the SQL 92 ANSI standard -- these options force Transact-SQL to behave much like ANSI SQL. Here are a few tips about ANSI options and how to avoid common pitfalls. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci864562,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SCRIPT TO DETERMINE OS PID FOR TIMED-OUT SESSIONS | Murali Sankar Do you have trouble finding timed-out sessions and killing them? This Oracle 8 script will help you find out the Unix process ID (PID) for the timed-out sessions. You can use this PID to kill the session from the operating system. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci857430,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: FINDING THE CONNECTION PORT IN DB2 | Ranjit Kumar http://www.searchDatabase.com/tip/1,289483,sid13_gci857650,00.html This short tip tells you how to find the client connection port for multiple DB2 instances. SPACE CHECK BEFORE DATA LOAD | Sudhakar Parsi http://www.searchDatabase.com/tip/1,289483,sid13_gci821247,00.html Here's a script to check table space before loading millions of records, which is especially useful in data warehousing situations. USE THE MICROSOFT ENGLISH QUERY TOOL | Barrie Sosinsky http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci849843,00.html If you are a developer, no doubt you have learned to think in SQL, and perhaps to employ a tool to help you compose the more complex SQL statements that arise. Your clients, however, don't think in SQL. For this Microsoft has introduced their Microsoft English Query tool. Here's a quick introduction. 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 prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered SQL: Check the bits of a numeric field http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid502093_tax285649,00.html Oracle: Sequences explained http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501809_tax285650,00.html Database design: Mass updates affecting users http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501793_tax285653,00.html SQL Server: Service only runs from AT service or cmd window http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501378_tax285648,00.html Data warehousing: Installing Informatica and Oracle on same system http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501503_tax288372,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE SECURITY | SearchDatabase.com Featured Topic The need for data security may be obvious, but the path getting there certainly isn't. The collection of technical tips, expert advice, webcasts and analysis inside will help you lock down your Oracle, DB2, or SQL Server databases. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci863539,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. ELLEN O'BRIEN, 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. To unsubscribe from 'DBA Tips,' simply reply to this e-mail with REMOVE (all caps) within the Body or Subject or go to http://searchDatabase.techtarget.com/register, log in to edit your profile, click on the link to Edit email subscriptions, and uncheck the box next to the newsletter you wish to unsubscribe from. When finished, click "Save Changes to My Profile."
