=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips January 2, 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: Function-based indexes - SQL Server Tip: Using system tables to your advantage - SQL Server Tip: Number of records in each table - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Live Expert Q&A: Tom Kyte on Oracle 9i - Featured Topic: Data storage in 2002 ___________________________________________________________________ ****************** SPONSORED BY: OraKnowledge ********************* Obtain your Oracle9i Oracle Certified Associate (OCA) in only 2 weeks. No Travel Expense, No Time Away from the Office. Live, Online Instruction Using Virtual Classroom Technology!! Using our proven "Syllabus for Success", our OCP Instructor will guide you through every objective on each of the DBA exams. We have Weekday, Evening, and Weekend eBoot Camps, as well as a convenient Payment Plan available. http://ad.doubleclick.net/clk;3775571;5058249;t?http://www.oraknowledge.com/ebootcamp.htm __________________________________________________________________ __________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FUNCTION-BASED INDEXES | by Hemant Mangukiya 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... >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci788630,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= USING SYSTEM TABLES TO YOUR ADVANTAGE | by Baya Pavliashvili 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci788629,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= NUMBER OF RECORDS IN EACH TABLE? | Parthasarathy Mandayam 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, like this: sp_msforeachtable 'select count(*) from ?' =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS SEARCHING FOR SPECIFIC COLUMN VALUES | by Karen Porter http://www.searchDatabase.com/tip/1,289483,sid13_gci787162,00.html 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... COMPLEX GROUPING OF STRINGS IN T-SQL | by Harinatha Reddy Gorla http://www.searchDatabase.com/tip/1,289483,sid13_gci786045,00.html 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. CREATE FORMATTED REPORT FILES | by Matt Harper http://www.searchDatabase.com/tip/1,289483,sid13_gci786052,00.html 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. 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATA STORAGE IN 2002 | SearchDatabase Featured Topic One of the most important functions of a DBA in 2002 will be storage management: the backup and recovery of business-critical data. But how do you keep up with new technologies such as SAN and NAS? The answers you need are inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci757776,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.
