SEARCHDATABASE.COM | Database Administrator Tips November 6, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
FREE SQL Server tool from Lumigent http://searchDatabase.com/r/0,,7264,00.htm?lumigent =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Optimizing database performance, part 3 - DB2: Extracting the complete DDL from DB2 6 databases - SQL Server: Errors upgrading from SQL Server 7 to 2000 - Oracle: Hot backup and recovery with PERL - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcast: SQL Server security best practices - Ask the Experts: Your tough database questions answered - Featured Topic: Relational fundamentals ___________________________________________________________________ ************** Sponsored by Lumigent Technologies **************** Monitor changes to table schema, dropped tables, and more with real-time alerts. Without triggers or performance impact. Download FREE Schema Alert now. Check out Log Explorer for data analysis and recovery for SQL Server - and now for Oracle8i. Identify the source of any data change. Keep your database online while recovering lost data. Salvage dropped or truncated tables. http://searchDatabase.com/r/0,,7264,00.htm?lumigent ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: OPTIMIZING DATABASE PERFORMANCE, PART 3: COMPRESSION & PAGE SIZE Craig Mullins concludes his series about the techniques for optimizing the performance of any database. In part 3, he discusses techniques such as fill factor management, compression, file placement, page/block size, and more. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci861319,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= EXTRACTING COMPLETE DDL FROM DB2 6 DATABASES | Sudhakar Parsi You may often need to get DDL statements for various DB2 database objects in order to recreate them on another server. For example, while setting up test systems, DBAs usually try to create a copy of the production database on test servers. Here's how to do it on DB2 v6. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci857622,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= UPGRADING FROM SQL SERVER 7.0 TO 2000 | Rhys Kerrigan Here's how to address the following error while upgrading to SQL Server 2000: "The Ordinal 105 could not be located in the dll Opens60.dll" >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci861379,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci857677,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: OPTIMIZING DATABASE PERFORMANCE, PART 2: DENORMALIZATION AND CLUSTERING http://www.searchDatabase.com/tip/1,289483,sid13_gci857336,00.html Craig Mullins continues his series about techniques for optimizing the performance of any database. In part two, he discusses denormalization, clustering, page splitting, and interleaving data. CONVERTING A DB2 DATE TO SQL SERVER | Douglas Seward http://www.searchDatabase.com/tip/1,289483,sid13_gci857672,00.html SQL Server 7 crashes when trying to process a view of DB2 tables where some of the date fields are initialized with the value '0001-01-01'. Here's a work around... FINDING NULLS IN ANY TABLE | Saritha Rani http://www.searchDatabase.com/tip/1,289483,sid13_gci857662,00.html These SQL scripts quickly show the number of rows with NULLs in each column. 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 MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered Database design: Tool to migrate from Oracle 8i to SQL Server http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid500271_tax285653,00.html Oracle: Triggers not working after export from user X to user Y http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid500257_tax289342,00.html SQL Server: How does ROWLOCK work? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid500272_tax292506,00.html Data warehousing: When to build the data warehouse http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid500007_tax288372,00.html Oracle: Paging without running a query a second time? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid500221_tax285650,00.html DB2: Cluster ratio explained http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid498950_tax285651,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL SERVER SECURITY BEST PRACTICES | Free Webcast When: Nov 13, 2002 at 01:00 PM EST (18:00 GMT) Speakers: James Hamilton, SQL Server Architect & Girish Chander, Program Manager for Security, SQL Server Team, Microsoft Microsoft's SQL Server security architect James Hamilton and security guru Girish Chander share best practices for locking down your SQL Server database. >> CLICK here to pre-register... http://searchdatabase.techtarget.com/webcasts/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= RELATIONAL FUNDAMENTALS | SearchDatabase.com Featured Topic Sure, you know your way around a particular DBMS. But how much do you know about the theory that started it all: Codd's relational model? Go back to basics with our collection of tutorials, columns, and advice inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci779242,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:tips@;searchDatabase.com) >> Submit your original tip here. TIM DICHIARA, Site Editor (mailto:tdichiara@;techtarget.com) >> Send your feedback and original articles. SARA CUSHMAN, Assistant Editor (mailto:scushman@;techtarget.com) >> Send your White Papers and favorite Web sites. ELLEN O'BRIEN, News Editor (mailto:eobrien@;techtarget.com) >> Send your product announcements and poll ideas. TOM CLICK, Sales (mailto:tclick@;techtarget.com) >> 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."
