SEARCHDATABASE.COM | Database Administrator Tips March 26, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR: Data Center Futures: Apply for free admission http://datacenterfutures.techtarget.com/?Offer=DCFnewsdb =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Is your SQL optimized? - SQL Server: Finding the nth maximal value - Oracle: Determine used and free space in a tablespace - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcasts: Business intelligence with SQL Server, and more - Ask the experts: Your database questions answered - Featured Topic: Open source databases ___________________________________________________________________ **************** Sponsored by Data Center Futures ***************** DATA CENTER FUTURES - HILTON CHICAGO HOTEL - JUNE 4-6. Gain FREE admission to the only independent conference available today that helps you build the most scalable and reliable data center for tomorrow. Plan now to achieve a core technology foundation with a full understanding of networking, security, storage, systems management and more. Discover full benefits on our conference Web site and apply for FREE admission today: http://datacenterfutures.techtarget.com/?Offer=DCFnewsdb ___________________________________________________________________ ___________________________________________________________________ THIS WEEK'S TIPS: IS YOUR SQL OPTIMIZED? | David Quigley This is a useful tip to help DBAs figure out if certain DB2 SQL has been optimized. It gives information in text and graphic form that shows how it's accessing tables and indexes. It also shows all the objects used in the plan and information about those objects such as tablesize, number of records, and more. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci870113,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FINDING THE NTH MAXIMAL VALUE | Eli Leiba This extension to the MAX T-SQL function gets a tablename, column and integer (N) as parameters and finds the Nth largest value of a column in a specific table. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci880140,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DETERMINE USED AND FREE SPACE IN A TABLESPACE | S. Sunitha This small Oracle script can be executed as a script file from the SQL*Plus prompt and reports the total size, used space, free space and percentage of used and free space in all the tablespaces in a database. Very useful for DBAs! >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci887383,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: FORCE OFF APPLICATIONS CONNECTED TO A SPECIFIC DATABASE | Dan Tuck http://www.searchDatabase.com/tip/1,289483,sid13_gci886750,00.html This DB2 script quickly generates a command to force off applications connected to a specific database. The DB2 command "force application all" is too wide in its effect. This tip provides the needed command for a specific database. PLANNING YOUR UPGRADE TO DB2 V7.1 | Jim Schesvold and John Irwin http://www.searchDatabase.com/tip/1,289483,sid13_gci881912,00.html In simple outline form, here are some tips and guidelines if you're considering upgrading to DB2 v.7.1 from versions 4, 5, or 6. AUTOMATE SCHEDULED BACKUPS FOR ALL DATABASES | Mike Weaver http://www.searchDatabase.com/tip/1,289483,sid13_gci867516,00.html This SQL Server script will 1) go through all databases on a single server and create a device for each database and 2) schedule a single job with a task for each database to be backed up to a local directory of your choice. It is very useful if want to make complete scheduled backups of all your databases on a single server and you need to know that the devices and scheduled tasks have been created correctly and uniformly. PREDICTING THE FUTURE OF SPACE USAGE | Predrag Radovic http://www.searchDatabase.com/tip/1,289483,sid13_gci845031,00.html This Oracle query will answer the following questions: 1) Is there enough space in my tablespaces to allocate the next N extents related to the tables that have less than M% of free space left? and 2) What percentage and amount of space will I be left with in case such allocations occur? ESTIMATE OR MONITOR THE TIME TO BUILD AN INDEX | Ravinder Bhalla http://www.searchDatabase.com/tip/1,289483,sid13_gci886902,00.html With the help of the following Oracle code, you can monitor the progress of indexing or estimate the time to do a "create index" of a large table. RANDOM NUMBER BETWEEN TWO INTEGERS | Siva Val http://www.searchDatabase.com/tip/1,289483,sid13_gci886755,00.html Though Oracle provides an internal function to generate random numbers, there is no function that gives a random number between any two given integers. This quick script solves that problem. 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 LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FREE WEBCASTS | SearchDatabase.com >> Business intelligence with SQL Server http://searchDatabase.com/r/0,,10507,00.htm Microsoft's Bill Baker discusses best practices for implementing a SQL Server business intelligence solution on heterogeneous database systems. >> Impossible data warehouse situations http://searchdatabase.com/r/0,,10092,00.htm Experts Chuck Kelley and Sid Adelman discuss their personal experiences about the realities of data warehousing not covered in basic texts. >> Business intelligence: From inception to implementation http://searchDatabase.com/r/0,,10861,00.htm Listen and learn as author Shaku Atre discusses the different the major components of BI application development, the vendor landscape, and the six steps of a BI implementation. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts DB2: Altering the size of a column http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid523296_tax285651,00.html Oracle: Separating county and state field into two columns http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid523131_tax289342,00.html SQL Server: Seeing how many rows affected by update http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid523145_tax285648,00.html SQL: Count males and females as well as total http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid521854_tax285649,00.html Oracle: Oracle 9iAS with Apache versus IIS http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid523171_tax285650,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= OPEN SOURCE DATABASES | SearchDatabase.com Featured Topic Free, open source DBMSs such as MySQL and PostgreSQL have found significant niches in enterprise IT. Learn more with the collection of news, expert advice, and tech tips inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci887422,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** 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 2003, All Rights Reserved. ___________________________________________________________________ :::::::::::::::::::: ABOUT THIS NEWSLETTER ::::::::::::::::::::: Published by TechTarget (http://www.techtarget.com) 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, 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."
