=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips December 19, 2001
Essential tools and advice for the enterprise DBA: http://searchDatabase.techtarget.com/tips/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Oracle Tip: Searching for specific column values - SQL Server Tip: Complex grouping of strings in T-SQL - SQL Server Tip: Create formatted report files - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Live Expert Q&A: Tom Kyte on Oracle 9i - Featured Topic: Top ten technical tips of 2001 - Win a XBox! - New newsletter: Oracle tips ___________________________________________________________________ ********************* SPONSORED BY: Syncsort ********************** Get your FREE 2002 SyncSort Calendar and start off 2002 organized and in order. Our renowned calendar is sorted alphabetically on one side for your amusement, and in the traditional way on the other for your use and to illustrate the power of data manipulation. SyncSort slashes database load time by up to 90%. See the difference SyncSort makes for yourself: click on http://www.syncsort.com/tgbc10 __________________________________________________________________ __________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHING FOR SPECIFIC COLUMN VALUES | by Karen Porter Ever needed to find a value within an Oracle table when you don't know what table or column_name holds the value? Here is some dynamic SQL used to accomplish this objective... >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci787162,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= COMPLEX GROUPING OF STRINGS IN T-SQL | by Harinatha Reddy Gorla This tip will show you how to group strings based on one or more IDs. This type of string manipulation is usually done in the front-end rather doing it in the back-end. Here, you will see how to accomplish the same functionality with T-SQL. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci786045,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CREATE FORMATTED REPORT FILES | by Matt Harper This lengthy script allows you to create formatted report files that can be distributed to a reporting system by using stored procedures and ISQL. These can then be scheduled as a job to run monthly or even daily. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci786052,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS FIX CORE ADVANCED REPLICATION PROBLEMS | by Kevin Nicholson http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci785890,00.html This impressive Oracle script -- created in the Bourne Shell on HP-UX 11.0 -- is intended to analyze, report and fix problems associated with Core Advanced Replication. It is an interactive script that can fix and report the status of advanced replication on a one-way basis. The list of replication directions you can fix is dynamically updated depending on how many databases you have in your repgroup. READ A TEXT FILE FROM THE WINDOWS SYSTEM | by Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci785887,00.html Here's a quick script that will read a text file from Windows into SQL Server. HOW TO GENERATE DYNAMIC RUNSTATS STATEMENTS | by Raul Gonzalez http://www.searchDatabase.com/tip/1,289483,sid13_gci784886,00.html Here is a handy trick to dynamically generate RUNSTATS STMTS using the SQL CONCAT and STRIP functions in DB2. 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 PHILIPS CD/MP3 PLAYER! http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz785186_cts785185,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LIVE EXPERT Q&A | Upgrading to Oracle 9i Who: Tom Kyte When: January 8, 2002 at 1:00 PM EST (18:00 GMT) Tom Kyte's best-selling book "Expert one on one: Oracle" has been called "perhaps the best book about Oracle products ever put out." Take advantage of Tom's knowledge and experience by getting answers to your 9i features and migration questions. >> CLICK: http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TOP TEN TECHNICAL TIPS OF 2001 | SearchDatabase Featured Topic Drum roll, please... Here are the top 10 Oracle, DB2, & SQL Server DBA and developer tips of 2001 submitted by searchDatabase members, as you ranked them. Think you can do better? Submit your own tip today! >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci786256,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WIN AN XBOX -- HELP YOUR PEERS Tell your peers about the valuable tech tips, industry news, and expert advice you get from searchDatabase -- and an XBox Video Game System could be yours. Click here for info on how to win: http://searchdatabase.techtarget.com/referFriendContest/1,290949,sid13,00.html?promo_code=xbox =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FREE NEWSLETTER | Oracle Tips A brand-new, free monthly newsletter for Oracle DBA's and developers, chock full of advice and scripts from the experts and the Oracle community. To subscribe, just log in to your account and check off 'Oracle Tips' in the Tips & Columns section. >> SUBSCRIBE: http://searchdatabase.techtarget.com/register/1,,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, ([EMAIL PROTECTED]) >> Ideas for new tip content. TIM DICHIARA, Site Editor ([EMAIL PROTECTED]) >> Feedback and original articles. ED PARRY, News Editor ([EMAIL PROTECTED]) >> Product announcements and poll ideas. TOM CLICK ([EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2001, All Rights Reserved. If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://searchDatabase.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.
