=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips January 16, 2002
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: Who is logged into the database? - SQL Server Tip: Adding an ORDER BY clause to a view - SQL Server Tip: Convert a string to the proper case - DB2 Tip: Optimize for one row - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Against the Grain: The trouble with SQL...and MySQL...and... - Featured Topic: Database development with Java ___________________________________________________________________ **** Sponsored by Quest Software - Business Runs Better On Us ***** Is a mix of database management tools from different vendors actually hurting your system's performance? Quest Software provides everything you need to improve response time today. Use Quest to detect database bottlenecks; diagnose resource intensive SQL statements, even in storage structures; tune applications, and reorganize database objects online. Join IT leaders worldwide and get Quest Software today! http://ad.doubleclick.net/clk;3798025;5058249;s?http://www.quest.com/landing/searchdb_nzltrspon0110.asp ___________________________________________________________________ __________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WHO IS LOGGED INTO THE DATABASE? | by James Giordano Here is a shell script that will list all the Oracle users that are logged in to all databases on your HP-UX machine. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci790037,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ADDING AN ORDER BY CLAUSE TO A VIEW | by Eli Leiba Microsoft says that you cannot put an ORDER BY clause in the view definition. Well, this is true...unless you use the following trick! >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci795979,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CONVERT A STRING TO THE PROPER CASE | By Anne Bryant This user-defined function takes an input string and converts it to upper and lower case (or proper case) format. It can handle names like O'Brian and McMurray. It also standardizes P.O. Boxes. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci795978,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= OPTIMIZE FOR ONE ROW | By Manuel Vico We published this tip a few months ago but recently received two excellent clarifications--clarifications that are more informative than the original tip! Learn what this clause really does in DB2... >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci556609,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: SIMULATE A THRU_DATE FOR POINT-IN-TIME QUERIES | by Richard Stucke http://www.searchDatabase.com/tip/1,289483,sid13_gci789847,00.html With ROWNUM, you can simulate a thru_date, which can then be used for ranking reports or point-in-time queries. Here's how. RANDOM NUMBERS WITH T-SQL | by Harinatha Reddy Gorla http://www.searchDatabase.com/tip/1,289483,sid13_gci789852,00.html The following T-SQL query batch will show you how to generate random numbers in SQL Server. If the starting number is greater than end number, it will give a custom message and exit from the query batch. QUICK INSERT OR UPDATE OF RECORDS FROM A SECOND TABLE | Eva Zadoyen http://www.searchDatabase.com/tip/1,289483,sid13_gci789823,00.html There may be cases when you need to update an existing record in a table from another table or insert a new record if one doesn't exist. Here is a quick way to do either procedure. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WHEN WILL THEY EVER LEARN? | Fabian Pascal's Against the Grain This month, Fabian trounces MySQL, describes the problems with sub-queries in SQL, and argues that recovery and integrity are database functions that must be built into the DBMS. Read this column and test your relational knowledge! >> CLICK: http://www.searchDatabase.com/tip/1,289483,sid13_gci788645,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE DEVELOPMENT WITH JAVA | SearchDatabase Featured Topic Java continues to build momentum as an enterprise database development language, with Oracle and DB2 coders leading the way. Want to learn more? We have scads of Java, J2EE, JDBC, XML, & SQLJ resources inside.... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci790305,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ ********** FREE CHARTER SUBSCRIPTION TO STORAGE MAGAZINE ********** Storage is now a front and center issue. No longer "just capacity," storage is a critical IT asset that must be managed effectively. Increasingly complex, it's become a huge percentage of your overall IT budget. That's why we created Storage magazine, a new resource to help you set your storage strategy, manage storage effectively, and make key vendor selection and architecture decisions. Subscribe today FREE and as a bonus you get the FREE 42-page Storage Networking special report! Visit http://ad.doubleclick.net/clk;3802184;5058249;k?http://www.storagemagazine.com __________________________________________________________________ ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, ([EMAIL PROTECTED]) >> Submit your original tip here. 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 2002, 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.
