SEARCHDATABASE.COM | Database Administrator Tips May 28, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Quest Software - Attention Oracle DBAs http://searchDatabase.com/r/0,,14686,00.htm?questsoftware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Script to grant permissions - Oracle: PL/SQL control structures: Best practices - DB2: Denormalization of DB2 tables - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the experts: Your database questions answered - Featured Topic: Oracle applications ___________________________________________________________________ ***************** Sponsored by Quest Software ********************* Is your Oracle database running at full speed? Can you identify bottlenecks and code that needs tuning? Find out how Quest Software can help with a Database Health Check. Learn more by attending a free live demo of Quest Central for Oracle. Register today and get a free online Oracle data dictionary: http://searchDatabase.com/r/0,,14686,00.htm?questsoftware ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SCRIPT TO GRANT PERMISSIONS | Parthasarathy Mandayam Here's a simple SQL Server script that can be customized to quickly grant permissions to various users on all tables or stored procedures. Using this script, the author was able to reduce the time taken to grant permissions during installation from 30 minutes to 1 second! >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci901507,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PL/SQL CONTROL STRUCTURES: BEST PRACTICES | Steven Feuerstein Here are several best practices you should take into account when you work with IF, FOR, WHILE, and GOTO statements in PL/SQL. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci901507,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DENORMALIZATION OF DB2 TABLES | Craig Mullins Speeding the retrieval of data from DB2 tables is a frequent requirement for DBAs and performance analysts. One way to accomplish this is to denormalize DB2 tables. However, it should be undertaken only when a completely normalized design will not perform optimally. Consider these issues before denormalizing... >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci903045,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: INTRODUCTION TO ORACLE DESIGN | Dave Ensor & Ian Stevenson http://www.searchDatabase.com/tip/1,289483,sid13_gci903329,00.html Covers what database design is, the various alternative methods and approaches, planning the design phase, and much more. PL/SQL: WHAT, WHEN, AND WHERE | Bill Pribyl & Steven Feuerstein http://www.searchDatabase.com/tip/1,289483,sid13_gci902939,00.html What the Procedural Language/Structured Query Language (PL/SQL) really is, what it is good for, and how it fits into the world. RECURSIVE SQL | Bernard Zver http://www.searchDatabase.com/tip/1,289483,sid13_gci901154,00.html An example of how to use recursive SQL for "bill of material" applications on mainframe DB2 platforms. BASIC DB2 BUFFERING AND MEMORY GUIDELINES | Craig Mullins http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci899983,00.html One of the most important areas for tuning DB2 subsystem performance is memory usage. DB2 for z/OS uses memory for buffer pools, the EDM pool, RID pool and sort pools to cache data and structures in memory. The better memory is allocated to these structures, the better DB2 will perform... COMPARE TWO SQL SERVER TABLES | Preethiviraj Kulasingham http://www.searchDatabase.com/tip/1,289483,sid13_gci857642,00.html May's tip contest winner! This large SQL Server stored procedure compares the data in two tables and reports the differences. 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 prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html ___________________________________________________________________ IMPORTANT LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts SQL Server: Alternative to DMP for differential backups http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid534344_tax292506,00.html Oracle: Tablespace still has 80% usage after large deletion http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid533553_tax285650,00.html DB2: Dynamic Singleton Select in Cobol program http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid534348_tax285651,00.html SQL: Optimizing a COUNT query http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid534351_tax285649,00.html Oracle: SYS versus SYSTEM users http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid533502_tax289342,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE APPLICATIONS | SearchDatabase.com Featured Topic The E-Business Suite is Oracle's fast-growing set of business applications built on an open architecture. Learn more with the latest news, analysis and advice inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci903740,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 your feedback and original articles. SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) >> Send your White Papers and favorite Web sites. ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) >> Send your product announcements and poll ideas. TOM CLICK, Sales (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 2003, All Rights Reserved. ___________________________________________________________________ :::::::::::::::::::: ABOUT THIS NEWSLETTER ::::::::::::::::::::: Published by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. To unsubscribe from 'DBA Tips,' simply reply to this e-mail with REMOVE (all caps) within the Body or Subject or go to http://searchDatabase.techtarget.com/register, log in to edit your profile, click on the link to Edit email subscriptions, and uncheck the box next to the newsletter you wish to unsubscribe from. When finished, click "Save Changes to My Profile."
