SEARCHDATABASE.COM | Database Administrator Tips November 24, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSORS:
FREE WHITE PAPER ON DATA RECOVERY BEST PRACTICES http://searchDatabase.com/r/0,,21670,00.htm?track=NL-94&lumigent Free White Paper! Discover the hidden costs of commodity servers http://searchDatabase.com/r/0,,21671,00.htm?track=NL-94&unisys =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Maintain running numbers - DB2: Defining business intelligence users - Oracle: Generate index DDL automatically - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Featured Topic: XML and the DBMS ___________________________________________________________________ ************** Sponsored by Lumigent Technologies ***************** Planning for data recovery is about more than just making sure your database is backed up. There are many things to consider. In his paper, Stephen Wynkoop, MVP and Founder SSWUG, discusses the best approaches to a solid data recovery solution. Download it today, compliments of Lumigent Technologies: http://searchDatabase.com/r/0,,21670,00.htm?track=NL-94&lumigent ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MAINTAIN RUNNING NUMBERS | Vadivel Mohanakrishnan Here is how to maintain a running number if you need to combine fields from different tables in SQL Server 7 and 2000. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci937840,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DEFINING BUSINESS INTELLIGENCE USERS | Mike Beire 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci938533,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= GENERATE INDEX DDL AUTOMATICALLY | Eric Mao If you need to drop and recreate Oracle indexes, you may find this script useful. 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. >> CLICK for the tip... http://www.searchOracle.com/tip/1,289483,sid41_gci938291,00.html?track=NL-94 ___________________________________________________________________ ********************** Sponsored by Unisys ************************ Free White Paper! Discover the hidden costs of commodity servers. Do commodity servers really save money in the long run? Applications, servers and other needs associated with a scale-out approach may actually cost more than a large system. Download the free white paper, "The True Cost of Commodity Servers," and receive a case study on the benefits of scale-up vs. scale-out technology. Courtesy of Unisys and Intel. Click here: http://searchDatabase.com/r/0,,21671,00.htm?track=NL-94&unisys ******************************************************************* ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: 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. IDENTIFY TABLES HAVING FKS ON A GIVEN TABLE'S PK | Daniel Clamage http://www.searchOracle.com/tip/1,289483,sid41_gci935718,00.html?track=NL-94 DBAs frequently need to know what tables have foreign keys on a specified table's primary key. This Oracle stored procedure displays them. NUMBER OF BUSINESS DAYS BETWEEN TWO DATES | Murthy Chamarthi http://www.searchDatabase.com/tip/1,289483,sid13_gci867507,00.html?track=NL-94 This short SQL Server procedure is useful to get the number of working days between the two dates given. It can be used to find answers to many questions such as the number of working days of an employee in an organisation. DB2 EXCEPTION HANDLING | Paul Yip et al. http://www.searchDatabase.com/tip/1,289483,sid13_gci936196,00.html?track=NL-94 This chapter from the recent book "DB2 SQL Procedural Language for Linux, UNIX, and Windows" will describe the various types of DB2 condition handlers and techniques of how and when to use them. DISABLE/ENABLE FK CONSTRAINTS AGAINST A SPECIFIED PARENT TABLE http://www.searchOracle.com/tip/1,289483,sid41_gci935719,00.html?track=NL-94 Sometimes you want to truncate a table that has foreign keys in other tables pointing to the primary key of the table to be truncated. But you can't truncate a table that has foreign keys pointing to its primary key, even if the child tables are empty! This stored procedure from member Daniel Clamage simplifies the task of disabling/enabling foreign key constraints against the specified parent table. FIND THE SPACE OCCUPIED BY ALL TABLES AND INDEXES | Parthasarathy Mandayam http://www.searchDatabase.com/tip/1,289483,sid13_gci912794,00.html?track=NL-94 Here's an undocumented method to find the space occupied by all tables and indexes in a SQL Server 2000 database. DATA MANIPULATION IN DB2 UDB | Dwaine Snow and Tom Phan http://www.searchDatabase.com/tip/1,289483,sid13_gci935161,00.html?track=NL-94 This chapter from the new book "Advanced DBA Certification Guide and Reference for DB2 Universal Database v8" focuses on the creation, management, and monitoring of buffer pools in DB2 UDB Version 8 to provide optimal performance for the database. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= XML and the DBMS | SearchDatabase.com Featured Topic XML began as a simple markup language for defining and sharing documents containing structured data. Then came query features and database integration. Our tips and advice will help you understand and use XML with your DBMS... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci761146,00.html?track=NL-94 ___________________________________________________________________ *********************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."
