=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips October 31, 2001 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
_________________________________________________________ ************ STORAGE MANAGEMENT CONFERENCE ************** Storage is mission critical. Are you ready? Apply to attend the FREE Storage Management conference coming to Chicago March 20-22. Seating is limited. Don't get shut out -- qualify early to attend at http://ad.doubleclick.net/clk;3503705;5058249;h?http://www.storagemanagement2002.com IMPORTANT: Unlike any other industry event, the Storage Management conference is the only independent storage event that delivers no vendor sales pitches disguised as content. Apply today! _________________________________________________________ IN THIS ISSUE 1. FEATURES - Tip: Who is low on space? - Tip: Improved performance with database links - Tip: Convert XLS data to a SQL Server table - Three quick bonus tips! - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Featured Topic: "A pig with lipstick"? - Survey: Help us help you - Book: "Instant SQL Server 2000 Applications" by Greg Buczek =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THIS WEEK'S NEW DATABASE TIPS WHO IS LOW ON SPACE? | Michael Vergara http://www.searchDatabase.com/tip/1,289483,sid13_gci778766,00.html This large script summarizes the tablespaces in a Oracle database instance, highlights the one(s) that cannot throw another extent, and details all datafiles in the database. It also creates a script that you can use in an emergency to adjust the next extent parameters of all of the objects that are in danger. IMPROVED PERFORMANCE WITH DATABASE LINKS | Colin Ling http://www.searchDatabase.com/tip/1,289483,sid13_gci778755,00.html If your Oracle database is distributed across a few servers and you need to access the database across these servers, one way to improve performance is through the use of database links. A PL/SQL script that inserts records across multiple servers using database links. CONVERT XLS DATA TO A SQL SERVER TABLE | Geert Vandenbroucke http://www.searchDatabase.com/tip/1,289483,sid13_gci778979,00.html When you import an Excel table into SQL Server you wind up with a table with all the columns from the Excel table as fields and all the rows as records. However, in a RDBMS you normally want a table with three fields: row, col, and value. To do the conversion, Geert created a stored procedure without any cursors. And a few bonus quickies: CHANGING THE DATE AND TIME IN SQL SERVER USING T-SQL | Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci778988,00.html REPLACE NULL VALUES | Akram Tri http://www.searchDatabase.com/tip/1,289483,sid13_gci779000,00.html CONVERTING NUMBERS INTO CHARACTERS | Aluri Ramakrishna http://www.searchDatabase.com/tip/1,289483,sid13_gci778984,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS DISPLAY DETAILED INDEX STATISTICS | Cade Bryant http://www.searchDatabase.com/tip/1,289483,sid13_gci777577,00.html Index tuning in Microsoft SQL Server isn't rocket science...It's much, much harder! Here's a simple stored procedure I created called sp_indexstats that allows you to obtain detailed DBCC SHOW_STATISTICS information on all indexes for a given table. WORKING WITH DELIMITED STRINGS IN T-SQL | Harinatha Reddy Gorla http://www.searchDatabase.com/tip/1,289483,sid13_gci777587,00.html Two examples of how to deal with the problems that you may face while working with strings in T-SQL: Finding the count of words in a comma-delimited string, and parsing the delimited string. USING "INITCAP" IN ORACLE AND SQL SERVER | Paul Webster http://www.searchDatabase.com/tip/1,289483,sid13_gci777599,00.html A well-annotated stored procedure demonstrating how to use the Oracle funciton INITCAP. Showing his versatility, Paul has also written the equivalent stored procedure for SQL Server! CHECK FOR ORACLE AVAILABILITY AND TABLESPACE CAPACITY | Rick Stehno http://www.searchDatabase.com/tip/1,289483,sid13_gci777604,00.html A script that will check if all of Oracle instances are up, if any of the extents have reached their maximum limit, and if any of the tablespaces are running short of freespace. GENERATING MAILING LABELS IN ORACLE | Mark Morseth-Mayer http://www.searchDatabase.com/tip/1,289483,sid13_gci777632,00.html An Oracle script that generates mailing labels and mail merge lists to contact individuals or companies. Easily modifiable for your specific needs. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge: Submit your own tip and win a cool prize: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz773507_cts773500,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= "A PIG WITH LIPSTICK"? | SearchDatabase Featured Topic That memorable line was how one IBM executive recently described Oracle technology. The database wars rage on, indeed. Keep up-to-date with the latest news and analysis about the ongoing DB2 vs. Oracle vs. SQL Server battle inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci554492,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HELP US HELP YOU | SearchDatabase Member Survey Please take a moment today to fill out our new member survey. We are accepting a limited number of responses, and will use the information you provide to continue to tailor searchDatabase to meet your needs. Thanks for participating! Click here to access the survey: http://quicktakeit.com/qto/Default.asp?a=48583&e=548038077X0250210 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THIS WEEK'S FEATURED BOOK | searchDatabase.com Bookstore Title: Instant SQL Server 2000 Applications Author: Greg Buczek The ultimate collection of ready-to-use code and expert techniques! Build robust SQL Server 2000 database applications easily using the pre-built projects packed into this essential resource. Inside, you''ll find step-by-step details for creating several practical tools that use SQL Server 2000 as the back-end. Every application, script, and code snippet is contained on the CD and is cross-referenced and explained in the text, making it easier to find exactly what you''re looking for. Save yourself hundreds of programming hours with this invaluable toolkit. http://www.digitalguru.com/DigitalGuru/product_detail.asp?Catalog%5FName=Books&Category%5Fname=SQL+Server+%28Microsoft%29&Product%5FId=0072133201&partner_id=77 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM CONTACTS TIM DICHIARA, Site Editor ([EMAIL PROTECTED]) >> Send us your original articles and best practices. ED PARRY, News Editor ([EMAIL PROTECTED]) >> Send in your product announcements and poll ideas. GABRIELLE DERUSSY ([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.
