SEARCHDATABASE.COM | Database Administrator Tips July 31, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Free Oracle white papers http://searchoracle.techtarget.com/whitepapers/0,293835,sid41,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Reseeding identities in SQL Server - JDBC: Database programming with J2EE - Oracle: How to use resumable space allocation in Oracle 9i - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the experts: Your database questions answered - Featured Topic: Database administration 101 - News analysis: Original coverage from SearchDatabase.com ___________________________________________________________________ ******************** Free Oracle white papers ******************* Download the key papers you need today to make better-informed decisions. Targeted categories include: E-Business Suite, Data analysis and Business Intelligence, Security, Storage Management, Integration, and more. Click here to access the free white papers: http://searchoracle.techtarget.com/whitepapers/0,293835,sid41,00.html ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= RESEEDING IDENTITIES IN SQL SERVER | Baya Pavliashvili Reseeding identities in IDENTITY columns are commonly used as primary keys for SQL Server tables. Here are some tips about reseeding identities and some pitfalls to avoid. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci913732,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= JDBC: DATABASE PROGRAMMING WITH J2EE | Art Taylor As a registered member of SearchDatabase.com, you're entitled to a complimentary copy of Chapter 1 from "JDBC: Database programming with J2EE" written by Art Taylor and published by Prentice Hall PTR. This chapter focuses on JDBC design, how Java works with relational databases, the JDBC API and more. >> CLICK to download the chapter... http://www.searchDatabase.com/tip/1,289483,sid13_gci917202,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HOW TO USE RESUMABLE SPACE ALLOCATION IN ORACLE 9I | Sanjay Gupta This tip discuss how to use a new feature in Oracle 9i called Resuamable Space Allocation. Before 9i, it was not possible to suspend a session when some space-related problem occured, so as a result, whole transactions got rolled back and you had to start your work all over again. >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci915006,00.html >> NOTE: All Oracle-related tech tips have moved! Click here: http://www.SearchOracle.com/tips ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: GENERATING A DATABASE POPULATION ROUTINE | Baya Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci913717,00.html Here is a SQL Server script that will populate your data model with data and stress test it prior to making it available to users. CHECK ALL ACTIVE PROCESSES, THE LATEST SQL, AND THE SQL HIT RATIO http://www.searchOracle.com/tip/1,289483,sid41_gci913363,00.html This quick script from member Rajesh George is useful for Oracle DBAs in the process of tuning and identifying slow SQL. It will provide information about the currently active sessions, the latest SQL, as well as the hit ratio. CREATING SERIAL NUMBER COLUMNS | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci914811,00.html Auto-incrementing columns are important when you need serial numbers or key fields for joins. In DB2 for versions 7 and later you can add the IDENTITY clause to the CREATE TABLE statement to create such a column. Here's how. SPLIT DELIMITER-SEPARATED LISTS | Andrew Novick http://www.searchDatabase.com/tip/1,289483,sid13_gci911718,00.html Creating and parsing lists of items in a string is a frequent request. Here's a SQL Server UDF that shows you how to do it. TOP 20 DB2 PERFORMANCE MYTHS | Richard A. Yevich & Susan Lawson http://www.searchDatabase.com/tip/1,289483,sid13_gci910646,00.html Think you know DB2 performance tuning? Think again! Yevich and Lawson debunk some commonly-held beliefs about DB2 performance. BUILD A SERVLET-BASED APP THAT EXECUTES SQL AGAINST A DATABASE http://searchoracle.techtarget.com/tip/1,289483,sid41_gci913448,00.html This tutorial by Joel Murach will show you how to use a Java servlet, JSP, and a static Java class to interactively execute any standard SQL statement against any database. 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 Expert DB2: Additional VSAM clusters when 2 GB limit reached? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid542943_tax285651,00.html SQL Server: Passing a column name as a parameter to a SP http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid541962_tax285648,00.html Data warehousing: Strengths and weaknesses of OLAPInsider http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid542916_tax288372,00.html DB2: Getting time stamp of date when field entered http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid542944_tax285651,00.html SQL Server: Shrinking log file smaller than its original size http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid542633_tax285648,00.html More database expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html Oracle database and application suite expert answers here: http://searchoracle.techtarget.com/ateExperts/0,289622,sid41,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE ADMINISTRATION 101 | SearchDatabase.com Featured Topic What does the modern enterprise DBA do? In today's challenging multi-DBMS environments, the answer is "just about everything." Inside is a collection of tutorials and expert advice about the most important job duties of a DBA... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci845011,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= NEWS ANALYSIS | SearchDatabase.com >> ORACLE/LINUX INTEREST HIGH, SPENDING FLAT http://www.searchoracle.com/originalContent/0,289142,sid41_gci916662,00.html Gartner Research says Oracle customers have been slow to adopt Linux, but one former MySQL customer says the Oracle/Linux combination saved his assets. >> IBM BOOSTS LINUX OFFERINGS http://www.searchdatabase.com/originalContent/0,289142,sid13_gci916969,00.html IBM today unveiled its new DB2 Integrated Cluster Environment (ICE) for Linux and bragged that it can do more and scale higher than Oracle's Linux offering. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ___________________________________________________________________ *********************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]) TOM CLICK, Sales (mailto:[EMAIL PROTECTED]) CLARK MORLEY, Sales (mailto:[EMAIL PROTECTED]) ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. ___________________________________________________________________ ::::::::::::::::::::: ABOUT THIS NEWSLETTER :::::::::::::::::::::: This newsletter is published by TechTarget, the most targeted IT media. http://www.techtarget.com Copyright 2003 TechTarget. 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."
