DBA Tips: SQL Server data migration, reorganizing Oracle tables, and more...
SEARCHDATABASE.COM | Database Administrator Tips August 13, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR: Attention Oracle DBAs - Free Data Dictionary http://searchDatabase.com/r/0,,17007,00.htm?questsoftware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Data migration script for static tables - SQL Server: Use the firehose cursor - Oracle: Reorganize a table and release the unused space - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the experts: Your database questions answered - Featured Topic: Data management career tips ___ *** Sponsored by Quest Software *** Is your Oracle database running at full speed? Can you identify bottlenecks and code that needs tuning? Start down the path to Oracle database health today with a free, online Oracle data dictionary compliments of Quest Software. Download your free data dictionary now! http://searchDatabase.com/r/0,,17007,00.htm?questsoftware *** ___ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATA MIGRATION SCRIPT FOR STATIC TABLES | Rajasekhar Sahitala 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. CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci915924,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= USE THE FIREHOSE CURSOR | Barrie Sosinsky SQL Server supports several types of cursors but one read-only, non-scrollable cursor that is specially optimized for fast performance and worthy of note is the firehose cursor. Here's a short introduction. CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci911716,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= A SIMPLE WAY TO REORGANIZE A TABLE AND RELEASE THE UNUSED SPACE This tip from member Debajit Mishra describes a simple solution to better manage the table space and performance during ETL operations in Oracle 9i. CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci918141,00.html NOTE: All Oracle-related tech tips have moved! Click here: http://www.SearchOracle.com/tips ___ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: 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. HOW TO USE RESUMABLE SPACE ALLOCATION IN ORACLE 9I | Sanjay Gupta http://www.searchOracle.com/tip/1,289483,sid41_gci915006,00.html 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. 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
Webcast Alert: Oracle performance tuning, part 1
Performance tuning is an integral factor in running a successful Oracle shop. Our expert series on performance tuning features informative tips on every aspect from disk I/O to SQL. Tune-in to part 1 of the Oracle performance tuning series now: http://searchDatabase.com/r/0,,16844,00.htm TITLE: Oracle performance tuning, part 1 WHEN:AVAILABLE NOW SPEAKER: Don Burleson, Author and Principal of BEI Oracle Consulting SPONSOR: SearchOracle.com http://searchOracle.com/r/0,,16833,00.htm JOIN US TODAY! http://searchDatabase.com/r/0,,16844,00.htm -- TARGETED ORACLE DATABASE NEWSLETTERS -- SearchOracle.com features unbiased database industry news, technical tips, informative webcasts, white papers and more - all designed to help IT pros tackle their toughest database issues with ease. Newsletters are available on a range of topics, including Oracle administration and E-Business Suite - click here for a full list: http://searchOracle.com/r/0,,16833,00.htm ABOUT THIS WEBCAST This three-part webcast series with expert Don Burleson covers various components of Oracle performance tuning, from fundamental tactics to advanced tuning tricks. Part 1 presents an overview of Oracle performance tuning essentials. Part 1 of this webcast series covers: ** How to tune disk I/O ** Influences from the server ** And more! Tune-in to this expert webcast now: http://searchDatabase.com/r/0,,16844,00.htm ABOUT THE SPEAKER Don Burleson has more than 20 years of full-time DBA experience, and has written 14 books, including Oracle high-performance SQL tuning and most recently the Oracle9i UNIX Administration Handbook. He has also published more than 60 articles in national magazines, serves as Editor-in-Chief of Oracle Internals magazine, and is owner of BEI Oracle Consulting. === To subscribe to Oracle Daily News go to: http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?cid=466744em=tid=3417FE=1 Not a SearchOracle.com member? We'll activate your membership with your subscription. === INVITE A COLLEAGUE If you think this webcast would interest your colleagues, simply forward them this invitation. Visit SearchTechTarget.com today for the latest IT news, webcasts, white papers and more from additional IT-specific Web sites within the TechTarget network. http://searchtechtarget.com/?Offer=sttfoot : ABOUT THIS NEWSLETTER :: This newsletter is published by TechTarget, the most targeted IT media. http://www.techtarget.com Copyright 2003 TechTarget. All rights reserved. Unsubscribe from 'Updates on upcoming online events' - Simply Reply to this E-mail with REMOVE 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. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click Save Changes to My Profile.
This week: Whither Sybase?
Title: TechTarget A weekly newsletter published by TechTarget August 11, 2003 Receive this e-mail as text About this e-mail In this Issue From the editor: Whither Sybase? Featured Topic: Data management career tips Expert Technical Advice: New expert advice, forum posts, and tips Site Highlights: * White paper: Enterprise Application integration * Product and Vendor Guide * OracleWorld: Sept. 7-11, San Francisco From the Editor: by Tim DiChiara, Senior Site Editor Although their iAnywhere products dominate the mobile database landscape, Sybase remains stuck in the single digits in overall DBMS market share. Lately, they have been refocusing their efforts on enterprise integration and web services. Is this a good move, or the beginning of the end? In other words, whither Sybase? As a Computer Weekly story pointed out last week, Sybase continues to release new versions of its DBMS Adaptive Server Enterprise (ASE) -- version 12.5.1 will ship this autumn. However, are these releases attracting any new customers or are they really meant for its legacy install base? Sybase fans: now is your time to speak out. E-mail me at [EMAIL PROTECTED] and convince me that Sybase is still a worthy DBMS for the enterprise and that we should increase our Sybase coverage. Do you think Sybase is technically superior to Oracle, DB2, and SQL Server? It was once known for its super-high performance -- is that still the case? How can Sybase increase its paltry 2% market share: find a vertical market niche, implement some sort of technical revolution, or what? Or do you think that Sybase has been doomed ever since they sold their soul to Microsoft back in 1987? For more background information about Sybase, check out our news and technical advice sections. Till next time, Tim DiChiara, Editor Featured Topic: Data management career tips by Tim DiChiara, Senior Site Editor Even in this dour economy, database administrators and developers continue to be in high demand -- and continue to be highly paid. The collection of tips and advice inside will guide you along the path to becoming a database guru. Read more about this topic Expert Technical Advice: Featured Expert Mike Lampa, CEO, BAG, Inc. Category: Data warehousing and Business Intelligence Mike is co-founder and CEO of BAG, a Texas-based business intelligence consultancy. He has over 21 years experience in strategic planning, program management, and designing, building and supporting data warehouse and operational data store implementations. Intricately involved in the daily activities of BAG, Mr. Lampa can often be found building data and process models to aid in improved operations efficiency and decision support automation for clients. View answers This Week: In the forums AS/400 DB2 V5R1 migration tools Member "Rama" is wondering if there are any tools to migrate data and schema definitions from AS/400 DB2 V5R1 to Oracle 9i? Oracle Migration Workbench apparently doesn't work. Go to our "DB2 Tech Forum" forum if you can help. Offshore job migration Members have been duking it out on the topic of outsourcing IT work overseas -- there have been almost 60 posts in the past week. Check out the very lively debate and let's hear your (civil) thoughts! Go to our "DBA Water Cooler" forum. Tip of the Week: Fast Guide: Becoming an Oracle Certified Professional Whether you're an Oracle newbie or a self-proclaimed guru, getting an Oracle Certified Professional seal of approval may be your key to staying afloat in a tough economy. So why not begin your journey today? This fast guide is designed to give you expert advice on where to begin your certification studies, passing the final exam and putting your certification into effect in the workplace. Read complete tip Site Highlights White paper: Evoke reveals the meaning of enterprise data This white paper examines how data profiling at the beginning of data warehousing and Enterprise Application integration projects will greatly reduce the risk of project failure along with saving companies time, money and frustrations. Click here to download now SearchDatabase.com Product & Vendor Guide Looking for a data
