SEARCHDATABASE.COM | Database Administrator Tips May 15, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Master today's most popular database and put yourself in demand! http://searchDatabase.com/r/0,,3328,00.htm?OracleProfLibrary =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Using the checksum function to increase performance - SQL Server: Quick way to find space used by each table - Oracle: Dynamically change NLS_LANG - Oracle: Identify missing FK indexes - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Poll: Who will win the battle for DBMS market share? - Ask the Expert: Your toughest database questions answered - Featured Topic: Spotlight on DB2 ___________________________________________________________________ ************** Sponsored by: Computer Books Direct **************** Master today's most popular database and put yourself in demand! The Oracle 9i Professional Library - a 3-volume, 1-CD-ROM set - a $169.97 value - can be yours for $9.99, with membership in Computer Books Direct! This insider's library will give you the most up-to-date security tips for your Oracle database as well as the latest information on the newest Oracle 9i tools! Click for details! http://searchDatabase.com/r/0,,3328,00.htm?OracleProfLibrary ___________________________________________________________________ ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= USING THE CHECKSUM FUNCTION TO INCREASE PERFORMANCE | Eli Leiba Suppose you have a SQL Server table with a relatively long string and you want to search on it. An index is not an ideal solution since it will be very big. Here is Eli's suggestion, which works with SQL Server 2000 only... >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci821254,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= QUICK WAY TO FIND SPACE USED BY EACH TABLE | Parthasarathy Mandayam Here is a quick way to find the disk space used by each table in a SQL Server database. Simply enter the command: sp_msforeachtable 'sp_spaceused "?"' The ? serves as a placeholder for each table name. >> CLICK for the online version of the tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci821478,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DYNAMICALLY CHANGE NLS_LANG | Ofer Harel When you have Oracle databases with different nls_lang's, you need to change your registry parameters when switching between DBs. Here is a simple way to open SQLPlus window to a database with a particular nls_lang without the need to change the registry. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci821256,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IDENTIFY MISSING FK INDEXES | Prince Kumar Here is an Oracle script that identifies missing foreign key indexes and automatically creates appropriate ones. >> CLICK for the online version of the tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci821251,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CHANGING SA PASSWORDS | Ray Higdon http://www.searchDatabase.com/tip/1,289483,sid13_gci820913,00.html Ever try and change your SQL Server SA password only to get an "Error 21776"? Here's how to fix this problem. A FRIENDLIER VERSION OF SP_LOCK | Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci820929,00.html This SQL Server stored procedure generates more readable output from the system sp_lock procedure. CHANGE THE FONT IN THE SQL*PLUS GUI | Sameer Wadhwa http://www.searchDatabase.com/tip/1,289483,sid13_gci820934,00.html Here's how to change the font and font size in the Oracle SQL*Plus GUI on Windows NT via altering the registry. RBS MONITOR TO CATCH ORA-1555 ERRORS | Ofer Harel http://www.searchDatabase.com/tip/1,289483,sid13_gci820605,00.html One of the most vexing errors in Oracle is "ORA-1555: snapshot too old: rollback segment number 9 with name "R07" too small." What causes this error? Oracle fails to return a consistent set of results (often called a snapshot) for a long-running query. This occurs because not enough information remains in the rollback segments to reconstruct the older data. Here are more details about the error and how you can fix or prevents. CHECK DIGIT FUNCTION | Michael Kleiser http://www.searchDatabase.com/tip/1,289483,sid13_gci819995,00.html It is a good idea to have a check digit in Oracle ID columns, especially if values are entered manually. Here is a check function to use... COPY THE STRUCTURE OF A TABLE | Urmila Verma http://www.searchDatabase.com/tip/1,289483,sid13_gci820927,00.html Here is a simple Oracle tip showing how to create a table with exactly the same structure as an existing table but without any records. 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 SAMSUNG DVD/MP3 PLAYER: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz805991_cts805990,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WHO WILL WIN THE BATTLE FOR DATABASE MARKET SHARE? | Poll IBM has apparently dethroned Oracle in the battle for DBMS market share. Who do you think will ultimately be victorious? Vote in our poll and let your voice be heard. >> CLICK to vote... http://searchdatabase.techtarget.com/poll/1,289525,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered Oracle: Moving data: Pro*C, SQL or PL/SQL? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid466678_tax285650,00.html SQL: Oracle's START WITH...CONNECT BY in T-SQL http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid467488_tax289340,00.html Data warehousing: Email list, information about data warehousing http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid466968_tax288371,00.html DB2: Determining what version of DB2 is running http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid467443_tax285651,00.html Database design: Designing a databse to keep track of servers http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid467464_tax285653,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SPOTLIGHT ON DB2 | SearchDatabase Featured Topic DB2 is IBM's fast-growing, multi-platform, Web-ready relational database management system. DB2 newbies and gurus alike will benefit from our collection of free tips, tutorials, news analyses, Webcasts and expert advice inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci822745,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."
