=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips January 9, 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: Simulate a thru_date for point-in-time queries - SQL Server Tip: Random numbers with T-SQL - SQL Server Tip: Quick insert or update from a second table - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Against the Grain: The trouble with SQL...and MySQL...and... - Featured Topic: Upgrading to Oracle 9i ___________________________________________________________________ ***** STORAGE MANAGEMENT CONFERENCE | Hosted by searchStorage ***** Find out how attendees specifically benefited from our previous storage event, and why you can't miss out on our Storage Management conference coming to Chicago March 20-22. Visit our home page to view streaming video clips AND our new speakers! http://ad.doubleclick.net/clk;3775842;5058249;u?http://www.storagemanagement2002.com ___________________________________________________________________ __________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SIMULATE A THRU_DATE FOR POINT-IN-TIME QUERIES | by Richard Stucke With ROWNUM, you can simulate a thru_date, which can then be used for ranking reports or point-in-time queries. Here's how. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci789847,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= RANDOM NUMBERS WITH T-SQL | by Harinatha Reddy Gorla 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci789852,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= QUICK INSERT OR UPDATE OF RECORDS FROM A SECOND TABLE | Eva Zadoyen 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci789823,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS FUNCTION-BASED INDEXES | by Hemant Mangukiya http://www.searchDatabase.com/tip/1,289483,sid13_gci788630,00.html Function-based indexes provide an efficient mechanism for evaluating statements that contain functions in their WHERE clauses. A function-based index can be created to materialize computational-intensive expressions in the index, so that the Oracle server does not need to compute the value of the expression when processing SELECT and DELETE statements. Here are some examples... USING SYSTEM TABLES TO YOUR ADVANTAGE | by Baya Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci788629,00.html Need to work with SQL Server data tables that are not familiar to you? Have to compare database tables in the production environment with their counterparts on development, quality assurance or testing servers? If any of these describes your job responsibilities, you need to learn the architecture of the SQL Server system tables and how to query them effectively. In this article Baya shows you how to use some of the most frequently accessed system tables: sysobjects, syscolumns and sysindexes. He also shows you several examples of how these tables can help you do your job. NUMBER OF RECORDS IN EACH TABLE? | by Parthasarathy Mandayam http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci786057,00.html Here's a quick way to find the number of records in each table of a SQL Server database. Use the sp_msforeachtable stored procedure to iterate thru each table, or use the alternative syntax proposed by another member. 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= UPGRADING TO ORACLE 9i | SearchDatabase Featured Topic Migrating to Oracle 9i or still considering whether or not to make the move? Tom Kyte, a top Oracle expert, was live on searchDatabase this Tuesday and outlined the coolest new features. Listen to the archived version and check out more great Oracle 9i resources inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci789155,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************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.
