SEARCHDATABASE.COM | Database Administrator Tips January 29, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Free database whitepapers http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: DATE data type - SQL Server: Determine the number of rows in a table - Oracle: Hot backup and recover with Perl II - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the experts: Your database questions answered - Featured Topic: Data mining for fun and profit ___________________________________________________________________ ****************** Free database whitepapers ********************** Download the key papers you need today to make better-informed decisions. Targeted categories include data analysis and business intelligence, data security, data storage, database-Web integration, and more. Click here to access the free SearchDatabase.com white papers section: http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: DB2'S DATE DATA TYPE | Peter Gulutzan and Trudy Pelzer This article describes how IBM implements the DATE data type for DB2 and discusses what calendar is used, what the JULIAN_DAY function really does, why date arithmetic is random, how to calculate birthdays, and how to find month ends using DB2. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci876846,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DETERMINE THE NUMBER OF ROWS IN A TABLE | Andrew Novick If you don't require an exact answer, it isn't necessary use a SELECT count(*) query on the rows in a table to get the row count. SQL Server keeps the row count in sysindexes and it can be retrieved there. Here's how. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci876060,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= UPDATED: HOT BACKUP AND RECOVERY WITH PERL | Frank Pantaleo This extensive script is useful for Oracle DBAs who want to use Perl for doing hot backups. Now updated with bug fixes, code cleanup and add more verbose messages. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci857677,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: CREATE A CLUSTERED INDEX ON A PRIMARY KEY | Prashant Dahalkar http://www.searchDatabase.com/tip/1,289483,sid13_gci875345,00.html Here is a way to create a table with clustered index on a composite primary key in DB2 UDB v7.1. TOP 10 SQL SERVER SECURITY BLUNDERS | Jan Stafford http://www.searchDatabase.com/tip/1,289483,sid13_gci874688,00.html An industry veteran shares the worst SQL Server security mistakes to avoid. Ignore these at your peril! BROWSING OS FILES FROM TOAD OR SQL*PLUS | Jim Leask http://www.searchDatabase.com/tip/1,289483,sid13_gci874425,00.html This tip describes the process required to browse operating system (OS) files from a PC application like TOAD or SQL*PLUS. This process will be useful for browsing the Oracle alert log when access via the OS is restricted. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts SQL: Basic three-table join with a condition http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid512243_tax285649,00.html Oracle: Resolving the ORA-01034 error http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511841_tax285650,00.html SQL Server: MySQL versus SQL Server for Web site http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511679_tax285648,00.html DB2: Tuning an access path using QMF http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511546_tax285651,00.html Oracle: Mutating table error with on delete cascade trigger http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511686_tax289342,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATA MINING FOR FUN AND PROFIT | SearchDatabase.com Featured Topic Data mining and other business intelligence technologies are hot. With database size growing exponentially, they are also essential for the modern enterprise. Inside is our collection of BI news, tips, & expert advice... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci815307,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 ::::::::::::::::::::: 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."
