SEARCHDATABASE.COM | Database Administrator Tips December 10, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Free white paper! Are commodity servers cost effective? http://searchDatabase.com/r/0,,22311,00.htm?track=NL-94&unisys =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Troubleshooting replications - DB2: Leveraging user-defined distinct types - Oracle: Don Burleson's favorite Oracle10g new features - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough DBMS questions answered - Featured Topic: The challenge of data integration - Survey: Data management spending in 2004 ___________________________________________________________________ ********************** Sponsored by Unisys ************************ Free white paper! Are commodity servers cost effective? Initial investments for commodity servers may seem less expensive than a large system purchase but there are hidden costs. To learn about those costs download a case study on the benefits of scale-up vs. scale-out technology and discover a powerful cost-effective solution from Unisys and Intel. View it today! http://searchDatabase.com/r/0,,22311,00.htm?track=NL-94&unisys ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TROUBLESHOOTING REPLICATIONS | Barrie Sosinsky Here is a quick overview of replication in SQL Server and how to solve common problems. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci911714,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LEVERAGING USER-DEFINED DISTINCT TYPES | Alexander Kuznetsov Did you know that you can protect your SQL from developer mistakes in DB2? You need to use UDDTs -- here's how. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci940590,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DON BURLESON'S FAVORITE ORACLE10G NEW FEATURES | Don Burleson With all of the hoopla surrounding the impending release of Oracle 10g, it is sometimes difficult to differentiate between the truly valuable features and the marginal new features. Guru Don Burleson discusses his favorites in this exclusive article. >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci939890,00.html?track=NL-94 ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: FIND THE PRODUCT OF A FIELD | Vadivel Mohanakrishnan http://www.searchDatabase.com/tip/1,289483,sid13_gci937838,00.html?track=NL-94 There isn't a prebuild function for finding the product of field or set of values in SQL Server. Here is a workaround using a combination of the SUM(), POWER() and LOG10() functions. INDEX COVERING AND QUERY PERFORMANCE | Alexander Kuznetsov http://www.searchDatabase.com/tip/1,289483,sid13_gci939445,00.html?track=NL-94 The DB2 rule of thumb "put the most selective column first in the index definition" is usually sound, but not always. Here is a situation when putting the most selective column last speeds up a query. COMPILE ALL INVALID OBJECTS INCLUDING THOSE WITH SYNTAX ERRORS | by Rastislav Ciganek http://www.searchOracle.com/tip/1,289483,sid41_gci938288,00.html?track=NL-94 Here's how to compile all invalid objects in Oracle, including these with syntax errors. It can by used for specific schemas or for whole databases and has more features than utlrp.sql. MAINTAIN RUNNING NUMBERS | Vadivel Mohanakrishnan http://www.searchDatabase.com/tip/1,289483,sid13_gci937840,00.html?track=NL-94 Here is how to maintain a running number if you need to combine fields from different tables in SQL Server 7 and 2000. DEFINING BUSINESS INTELLIGENCE USERS | Mike Beire http://www.searchDatabase.com/tip/1,289483,sid13_gci938533,00.html?track=NL-94 Users of BI systems can be delineated by application requirements and by skill. Here is how to define who is using your BI systems -- a critical step in enuring the success of your implementation. GENERATE INDEX DDL AUTOMATICALLY | Eric Mao http://www.searchOracle.com/tip/1,289483,sid41_gci938291,00.html?track=NL-94 If you need to drop and recreate indexes, you may find this script useful. It will generate current index DDL for a specific schema, among other functions. BUILD THE RIGHT INDEX | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci937802,00.html?track=NL-94 Indexes are a central performance feature of any database but it's important to create the right kind of index. Here are a few quick index tips for SQL Server 2000. IMPROVING DB2 RECOVERY PERFORMANCE | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci937773,00.html?track=NL-94 By optimizing the use of your buffers and using PARALLELISM properly, you can reduce the time it takes to perform a restore operation in DB2. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html?track=NL-94 Share your knowledge, submit a tip, win a prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html?track=NL-94 ___________________________________________________________________ IMPORTANT LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts SQL: Only one distinct value in a group http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid562503_tax285649,00.html?track=NL-94 SQL: Current and History transactions http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid562504_tax285649,00.html?track=NL-94 SQL: Users, groups, and folders http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid562505_tax285649,00.html?track=NL-94 >> CLICK for other database expert answers... http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html?track=NL-94 >> CLICK for Oracle-related expert answers... http://searchoracle.techtarget.com/ateExperts/0,289622,sid41,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE CHALLENGE OF DATA INTEGRATION | Featured Topic Studies have shown that most modern corporations have from three to ten different DBMS products. Learn more about this complex and growing problem and how integrated systems can provide business value. http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci858799,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATA MANAGEMENT SPENDING IN 2004 | Survey How will you approach your database strategy in 2004? Are you planning on investing in upgrades? Take a few minutes to share your thoughts with this brief survey. http://www.insightexpress.com/s/spen64219 ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIM DICHIARA, Senior Site Editor (mailto:[EMAIL PROTECTED]) ROBYN LORUSSO, Site Editor (mailto:[EMAIL PROTECTED]) SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) ROB WESTERVELT, News Writer (mailto:[EMAIL PROTECTED]) GABRIELLE DERUSSY, Sales (mailto:[EMAIL PROTECTED]) ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com?track=NL-94 TechTarget - The Most Targeted IT Media Copyright 2003, 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?track=NL-94 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."
