=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Ask the Experts February 26, 2002
Top experts answer your toughest database questions: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= __________________________________________________________________ IN THIS ISSUE: 1. EXPERT ANSWERS OF THE WEEK - Oracle: Checking table updates with auditing - SQL Server: Capturing recordsets generated by SP's - DB2: Clustering explained - SQL: How does 'where exists' work? - And more: SQL, database design, data warehousing 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Live Expert Q&A: Don Burleson on Oracle 9i tuning - Featured Topic: Tuning Oracle ___________________________________________________________________ ******* STORAGE MAGAZINE EDITORIAL HIGHLIGHTS: March issue ******** Here's a preview of our March topics: ** Strategies to manage the explosion of customer data ** Why storage professionals are hot ** How to Make NAS Work with Microsoft Exchange ** A guide to secure SANS ** How September 11 changed disaster recovery FREE 42-page storage networking special report with your FREE subscription. Subscribe today at: http://ad.doubleclick.net/clk;3802184;5058249;k?http://www.storagemagazine.com ___________________________________________________________________ ___________________________________________________________________ EXPERT ANSWERS OF THE WEEK: ORACLE: CHECKING TABLE UPDATES WITH AUDITING | Brian Peasland Question: How can I check which table is updated/inserted by which machine/user at what time? Click here to read Brian's answer: http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid450331_tax285650,00.html SQL SERVER: CAPTURING RECORDSETS GENERATED BY SP'S | Bianca Blount Question: Is there a possibility to "capture" the recordsets generated by the call of a stored procedure into something -- temporary table, cursors, or something else? I don't want to change anything in that stored procedure! Click here to read Bianca's answer: http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid448726_tax285648,00.html DB2: CLUSTERING EXPLAINED | Craig Mullins Question: What is clustering, and is it worthwhile? Click here to read Craig's answer: http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid447727_tax285651,00.html SQL: HOW DOES 'WHERE EXISTS' WORK? | Rudy Limeback Question: How does WHERE EXISTS (SELECT NULL FROM xyz blah) work? I have seen this in many places but do not understand the logic. Can you please explain with a simple demo table? Click here to read Rudy's answer: http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid450341_tax285649,00.html DB DESIGN: CAN THERE BE TOO MANY COLUMNS IN AN INDEX? | Pat Phelan Question: Is there such a thing as having too many columns in an index? Click here to read Pat's answer: http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid448142_tax285653,00.html DW ETL: ENGINE-BASED VS. CODE-GENERATING TOOLS | Ian Abramson Question: Why would you choose an engine-based ETL tool only? Code-generating tools are supposed to be faster. You may not want a tool that generates legacy code like COBOL for some obvious reasons, but code-generating tools can achieve a much faster load throughout, as the data does not have to go through the engine bottleneck. Read Ian's response here: http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid448528_tax288369,00.html DW IMPLEMENTATION: CHOOSING A DBMS AND OS | Mike Lampa Question: I'm looking for a checklist that would help determine the most appropriate DBMS for either a data warehouse, data mart or OLTP application. Would there be a similar checklist for the most appropriate OS and hardware platform? Click here for Mike's answer: http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid448415_tax288372,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DOZENS MORE QUESTIONS ANSWERED: Oracle: http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_tax285650,00.html SQL Server: http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_tax285648,00.html DB2: http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_tax285651,00.html SQL: http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_tax285649,00.html Database design: http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_tax285653,00.html Object-oriented databases: http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_tax288550,00.html Data warehousing ETL: http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_tax288369,00.html Data warehousing metadata: http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_tax288371,00.html Data warehousing implementation: http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_tax288372,00.html __________________________________________________________________ IMPORTANT ANNOUNCEMENTS AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LIVE EXPERT Q&A | Self-tuning in Oracle 9i Who: Don Burleson When: February 27, 2002 at 12:30 PM EST (17:30 GMT) THIS WEEK: Join renowned Oracle guru Don Burleson, author of "Oracle High Performance SQL Tuning" and many more books, in this discussion about tuning Oracle 9i to achieve maximum performance. Learn about disk I/O and RAM tuning and ask Don your toughest questions! >> CLICK: http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TUNING ORACLE | SearchDatabase Featured Topic A slow database is not only annoying to users, it can also affect your company's bottom line. This collection of Oracle tuning tips and advice will help you achieve maximal speed and reliability for your Oracle system. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci803739,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ ******************** SEARCHDATABASE CONTACTS ********************** TIM DICHIARA, Site Editor (mailto:[EMAIL PROTECTED]) >> Send in your original articles and tech tips. SARA CUSHMAN, Assistant Site Editor (mailto:[EMAIL PROTECTED]) >> Send in your feedback and questions for experts. ED PARRY, News Editor (mailto:[EMAIL PROTECTED]) >> Send in your product announcements and press releases. TOM CLICK (mailto:[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 do not wish to receive this newsletter, simply visit http://searchDatabase.techtarget.com/register and adjust your subscriptions accordingly. Please allow 24 hours for your request to be processed.
