SEARCHDATABASE.COM | Database Administrator Tips March 17, 2004 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Is Database Contention Affecting the Performance of Your SQL Server Environment? http://searchDatabase.com/r/0,,26352,00.htm?track=NL-94&ad=478535&questsoftware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Planning for Windows Server 2003 - DB2 version 8 certification: Everything you need to know - Oracle: Find unnecessary duplicate indexes on a table - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough DBMS questions answered - Featured Topic: The gurus speak ___________________________________________________________________ **************** SPONSORED BY: Quest Software ********************* Download Quest Software's new white paper "SQL Server Contention: Diagnosing and Resolving Blocking Problems" to help you get a solid strategy for diagnosing and resolving SQL Server contention issues. This white paper discusses the business impact of blocking and how to take a methodical approach to detect, diagnose and resolve blocking problems before users are affected. Download the white paper at http://searchDatabase.com/r/0,,26352,00.htm?track=NL-94&ad=478535&questsoftware ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIP: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PLANNING FOR WINDOWS SERVER 2003 | Johanna Ambrosio Large companies with numerous remote nodes will benefit the most from a rapid upgrade to Windows Server 2003. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci955254,00.html?track=NL-94&ad=478535 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DB2 V8 CERTIFICATION: EVERYTHING YOU NEED TO KNOW | H. Fosdick The whats, whys, and hows of DB2 certification are presented in this detailed article. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci947041,00.html?track=NL-94&ad=478535 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FIND UNNECESSARY DUPLICATE INDEXES ON A TABLE | Cassio Ferrari This Oracle script will generate a drop index script which can be used to drop redundant indexes on all tables except those owned by user SYS and SYSTEM. >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci938740,00.html?track=NL-94&ad=478535 ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: FACE-OFF: ORACLE VS. SQL SERVER | Tim DiChiara & Robyn Lorusso http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci953120,00.html?track=NL-94&ad=478535 Our crash course in the lingua franca of the database world, the structured query language, including tips, advice, and scripts from the gurus... LEARNING GUIDE TO SQL http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci950920,00.html?track=NL-94&ad=478535 Our crash course in the lingua franca of the database world, the structured query language, including tips, advice, and scripts from the gurus... FREEWARE PROFILER FOR SQL SERVER | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci952237,00.html?track=NL-94&ad=478535 SQLcheck is a cool freeware goodie that you can use to monitor a wide range of parameters in your SQL Server databases. INSTALLING AND CONFIGURING DB2 V8 | Peter Buxbaum http://www.searchDatabase.com/tip/1,289483,sid13_gci931151,00.html?track=NL-94&ad=478535 Although the DB2 UDB V8 documentation covers the installation and configuration of DB2 servers and clients, this book chapter provides more detailed instructions on installing the server. FIND AND RELEASE LOCKED OBJECTS | Vijay Kaushik http://www.searchOracle.com/tip/1,289483,sid41_gci930268,00.html?track=NL-94&ad=478535 This Oracle script will find which tables in a schema are locked and which session has locked it. UDF FOR GETTING A COLUMN LIST FOR INSERT STATEMENTS | Baya Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci951169,00.html?track=NL-94&ad=478535 If you've ever been in a SQL Server environment where you're unfamiliar with the database schema, you know how tedious it is to write stored procedures that populate tables using the INSERT statement. Here's a solution to make your life easier. TRACING AN ORACLE SESSION BY SID | Adinath Kamode http://www.searchOracle.com/tip/1,289483,sid41_gci935720,00.html?track=NL-94&ad=478535 This quick script accepts the Oracle session ID as a parameter and will show you what SQL statement is running and what the session is waiting for. A QUICK 'UNION ALL' TRICK | Dipak Padhy http://www.searchDatabase.com/tip/1,289483,sid13_gci827176,00.html?track=NL-94&ad=478535 Let's say that you have two SQL Server tables that have columns of the datatype TEXT and you need all DISTINCT records that are linked or not linked to child tables. What do you do? USING SEQUENCE OBJECTS | Craig Mulllins http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid569117_tax285651,00.html?track=NL-94&ad=478535 A great new feature of DB2 V8 is sequence objects, a separate structure that generates sequential numbers. Here's how to use it to prevent an online program from updating a serial number table to the same value that a batch program is going to use. FIRST IMPRESSIONS OF 10G | Rob Westervelt http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci949726,00.html?track=NL-94&ad=478535 After getting their hands on the latest Oracle database, DBAs and IT managers are raving about its newest features. LEVERAGE YOUR SQL SERVER 2000 SKILLS TO LEARN DB2 UDB V8 | R. Chong http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci947038,00.html?track=NL-94&ad=478535 In the IT world today, we are constantly bombarded with new information -- new software products, new versions, new features. Leveraging your current knowledge is one way to keep up with this constant change. The author shows you how you can use your current knowledge of SQL Server 2000 to quickly gain skills in DB2 UDB for Linux, UNIX, and Windows Version 8. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html?track=NL-94&ad=478535 Share your knowledge, submit a tip, win a prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html?track=NL-94&ad=478535 ___________________________________________________________________ IMPORTANT LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts SQL: First and last date of the current month http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid577104_tax285649,00.html?track=NL-94&ad=478535 SQL: What is a correlated subquery? http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid577106_tax285649,00.html?track=NL-94&ad=478535 SQL: Counting only some rows in a GROUP BY http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid577107_tax285649,00.html?track=NL-94&ad=478535 DB2: Altering temporary tables http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid577501_tax285651,00.html?track=NL-94&ad=478535 DB2: Coding VALUES clause to absorb composite key between two other keys http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid577502_tax285651,00.html?track=NL-94&ad=478535 >> CLICK for other database expert answers... http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html?track=NL-94&ad=478535 >> CLICK for Oracle-related expert answers... http://searchoracle.techtarget.com/ateExperts/0,289622,sid41,00.html?track=NL-94&ad=478535 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE GURUS SPEAK | Featured Topic Our webcasts are quality presentations by top database experts, complete with slides, audio streaming, and answers to audience questions. Here are your all-time favorites... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci841220,00.html?track=NL-94&ad=478535 ___________________________________________________________________ *********************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 :::::::::::::::::::::: This e-newsletter is published by SearchDatabase.com, a targeted Web site from TechTarget, the most targeted IT media and events company. TechTarget offers magazines, Web sites, e-newsletters, Webcasts and conferences for enterprise IT professionals. Copyright 2004 TechTarget. All rights reserved. _____________________________________________________________________ To unsubscribe from "Database Administrator Tips": Go to unsubscribe: http://SearchDatabase.com/u?cid=478535&lid=430854&track=NL-94&ad=478535 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact us: SearchDatabase Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494
