SEARCHDATABASE.COM | Database Administrator Tips September 10, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Attention DB2 DBAs - Free DB2 System Catalog http://searchDatabase.com/r/0,,17904,00.htm?questsoftware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Paging results using T-SQL - DB2: Improving buffer performance - Oracle: Analytical processing with Oracle SQL - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcast: Protecting your database from hack attacks - Ask the experts: Your toughest DBMS questions answered - Featured Topic: OracleWorld 2003 ___________________________________________________________________ ****************** Sponsored by Quest Software ******************** Tired of having to reference cumbersome manuals every time you need to look up information about your DB2 catalogs? Get with the times and download Quest Software's free electronic desktop catalog poster of DB2 UDB V8. http://searchDatabase.com/r/0,,17904,00.htm?questsoftware ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PAGING RESULTS USING T-SQL | Stephen Loschiavo This SQL allows a page of results to be extracted from your SQL Server database so that only the single page of results is sent to the web server, thus reducing bandwidth requirements and memory requirements on the web server. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci921778,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IMPROVING BUFFER PERFORMANCE | Barrie Sosinsky Here is how you can improve DB2 buffer performance with prefetching, the process by which pages of data pages are read and stored in memory in advance of their use by a query. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci925894,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ANALYTICAL PROCESSING WITH ORACLE SQL | John Palinski This chapter from the book "Oracle SQL and PL/SQL Handbook" will show you how analytic functions like ROLLUP and CUBE are ideally suited for computing values across multidimensions. >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci922290,00.html >> NOTE: All Oracle-related tech tips have moved! Click here: http://www.SearchOracle.com/tips ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: CHECK THE ISOLATION LEVEL OF ANY SQL SERVER SPID | Paul Wehland http://www.searchDatabase.com/tip/1,289483,sid13_gci920866,00.html How do you check the isolation level of other users (i.e., other SPIDs)? DBCC USEROPTIONS cannot do it. The way aound this is to use the undocumented DBCC PSS command.... USING THE RUN STATISTICS UTILITY | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci921669,00.html A short overview of DB2's Run Statistics utility, which is used to collect information about the organization of your table structures. INSERT STATEMENT GENERATOR | Ravi Nookala http://www.searchOracle.com/tip/1,289483,sid41_gci920868,00.html This Oracle script generates INSERT statements from an existing table that can be used as a backup or source script for future data loads. DATA MIGRATION SCRIPT FOR STATIC TABLES | Rajasekhar Sahitala http://www.searchDatabase.com/tip/1,289483,sid13_gci915924,00.html Suppose that you have an application in which you have a table containing static data and you need this data whenever you recreate the database. Using this SQL Server script, you can create a batch of insert statements that you can keep in your database creation script and start using the database after the database creation without reloading any data. A SIMPLE WAY TO REORGANIZE A TABLE AND RELEASE THE UNUSED SPACE http://www.searchOracle.com/tip/1,289483,sid41_gci918141,00.html This tip from member Debajit Mishra describes a simple solution to better manage the table space and performance during ETL operations in Oracle 9i. RESEEDING IDENTITIES IN SQL SERVER | Baya Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci913732,00.html 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. JDBC: DATABASE PROGRAMMING WITH J2EE | Art Taylor http://www.searchDatabase.com/tip/1,289483,sid13_gci917202,00.html 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. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PROTECTING YOUR DATABASE FROM HACK ATTACKS | Free Webcast TITLE: Protecting your database from hack attacks SPEAKER: Aaron Newman, CTO of Application Security Inc. WHEN: Available now! Aaron Newman presents key tips and expert advice on database security. In this webcast, he looks at the database from a hacker's perspective, common security flaws and generic attacks, attacks specific to Oracle, Microsoft SQL Server and Sybase, and SQL injection and buffer overflow attacks. >> CLICK to listen now... http://searchDatabase.com/r/0,,17713,00.htm =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts Data warehousing: MI, CI and BI http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid548310_tax288372,00.html SQL Server: Quickest way to purge all data http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid548330_tax285648,00.html SQL: Creating DDL to drop tables http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid548576_tax285649,00.html DB2: -305 after call to SP that selects from two subsystems http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid548742_tax285651,00.html SQL Server: Trying to copy new DLL over old one http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid548269_tax285648,00.html >> CLICK for other database expert answers... http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html >> CLICK for Oracle-related expert answers... http://searchoracle.techtarget.com/ateExperts/0,289622,sid41,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLEWORLD 2003 | SearchDatabase.com Featured Topic Travel budget cut? San Francisco too far away? Just plain forgot? If you aren't going to OracleWorld this week, we have the latest news, exclusive analysis, expert advice, and product announcements from the show. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci862113,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************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 MOREY, 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. 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."
