SEARCHDATABASE.COM | Database Administrator Tips February 11, 2004 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Register for IOUG Live! 2004 - The Education Conference for Oracle Users http://searchDatabase.com/r/0,,24801,00.htm?track=NL-94&ioug =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: UDF for getting a column list for INSERT statements - Pros vs. cons of independent consulting - Oracle: Tracing a session by SID - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough DBMS questions answered - Featured Topic: SQL Server tips and scripts ___________________________________________________________________ ************** SPONSORED BY: IOUG **************** Attend Live! 2004, April 18 - 22 in Toronto, Ontario, Canada. Learn all things Oracle, from cutting edge solutions to trusted tips and techniques from world-renown Oracle professionals covering such topics as Oracle9i, Oracle10g, OEM, tuning and more. Attend networking events, an exhibit hall and optional University Seminars to help you maximize your Oracle investment. Register at http://searchDatabase.com/r/0,,24801,00.htm?track=NL-94&ioug ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= UDF FOR GETTING A COLUMN LIST FOR INSERT STATEMENTS | Baya Pavliashvili 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci951169,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PROS VS. CONS OF INDEPENDENT CONSULTING | Peter Buxbaum Thinking of getting rich being your own boss? Be careful -- becoming an independent contractor is not as easy as you might think. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci951045,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TRACING AN ORACLE SESSION BY SID | Adinath Kamode 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. >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci935720,00.html?track=NL-94 ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: A QUICK 'UNION ALL' TRICK | Dipak Padhy http://www.searchDatabase.com/tip/1,289483,sid13_gci827176,00.html?track=NL-94 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 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 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 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. TERMINATING 11I CONCURRENT REQUESTS | Bob Schreiber http://searchoracle.techtarget.com/tip/1,289483,sid41_gci945160,00.html?track=NL-94 This script is useful for finding the SID and serial number for a specific Oracle 11i concurrent request that has been terminated in the applications, but has not been cleaned up by PMON. HOW TO WORK WITH DEFERRED CONSTRAINTS | Daniel Clamage http://www.searchOracle.com/tip/1,289483,sid41_gci941869,00.html?track=NL-94 Here is how to defer a unique key constraint in Oracle until the end of a transaction in order to temporarily have two key values the same. LEVERAGING YOUR ORACLE 9I SKILLS TO LEARN DB2 UDB V8 | Suita Gupta http://www.searchDatabase.com/tip/1,289483,sid13_gci945589,00.html?track=NL-94 If you're a database specialist interested in growing your DB2 Universal Database skills, there's a good chance that you've already developed database skills with another relational database product somewhere along the way. This detailed article shows you how to use your current knowledge of Oracle 9i to quickly gain skills in DB2 UDB for Linux, UNIX, and Windows Version 8. WORKING WITH ORACLE10G'S NEW GLOBAL TEMPORARY TABLE FEATURES http://www.searchOracle.com/tip/1,289483,sid41_gci944420,00.html?track=NL-94 Oracle Database 10g extends the features of global temporary tables to permit VARRAY and nested table columns. This tip will explain how to use these new features. Contributed by author Kevin Owens. DROP USER DATABASES WITHOUT USING NORMAL SYNTAX | Rudy Setiadi http://www.searchDatabase.com/tip/1,289483,sid13_gci931561,00.html?track=NL-94 When you restore a SQL Server database to another server or PC, sometimes the sysusers table is not consistent and users can't be dropped from the database. Here's how to drop user databases if they can't be dropped using normal syntax like sp_dropuser. SQL SERVER SIZE MAINTENANCE | Baya Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci944134,00.html?track=NL-94 Database size maintenance is among the "boring" tasks that DBAs have to perform. However, if you allow your databases to grow without ever managing their size you're very likely to get in trouble. Here's a quick introduction to the topic. CREATE PROCEDURES AND COMPILE DDL SCRIPTS ON THE FLY | M. Huffine http://www.searchOracle.com/tip/1,289483,sid41_gci940477,00.html?track=NL-94 This Oracle procedure creates views, procedures, functions, and packages, and update, delete, and insert statements and compiles them. This provides developers with a means to call a procedure to create and compile all DDL scripts on the fly and see the output errors when executing stored DDL. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts SQL Server: Selecting columns without specifying column name http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid571681_tax294863,00.html?track=NL-94 SQL Server: Replicating SQL Server over the Internet, part 1 http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid571412_tax294863,00.html?track=NL-94 SQL Server: Importing an Oracle text file into SQL Server 2000, part 1 http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid571416_tax294863,00.html?track=NL-94 Data warehousing: The relationship between dimensions http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid572666_tax288372,00.html?track=NL-94 Sybase on Linux http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid570114_tax294910,00.html?track=NL-94 >> CLICK for other database expert answers... http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html?track=NL-94 >> CLICK for Oracle-related expert answers... http://searchoracle.techtarget.com/ateExperts/0,289622,sid41,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL SERVER TIPS AND SCRIPTS | Featured Topic Attention SQL Server administrators and developers! Scads of free tips, tutorials, and expert advice about SQL Server tuning, design, security, integration, and much more inside... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci769983,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 :::::::::::::::::::::: 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=476788&lid=430854&track=NL-94 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
