SEARCHDATABASE.COM | Database Administrator Tips December 17, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
FREE WHITE PAPER: SCALE UP OR SCALE OUT - AN IDC ANALYSIS http://searchDatabase.com/r/0,,22873,00.htm?track=NL-94&unisys =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Alternate way to find database size - DB2: Using INSTEAD OF triggers - Oracle: Get useful details about a table with one query - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough DBMS questions answered - Featured Topic: Database administration 101 ___________________________________________________________________ *********************** Sponsored by Unisys *********************** FREE WHITE PAPER: SCALE UP OR SCALE OUT - AN IDC ANALYSIS When IT spending is tight, how can you find: TCO advantages in hardware, software, and maintenance? Increased availability and productivity? Find out why TCO is more important than the initial purchase price in a report from industry analyst IDC. Sponsored by Unisys, providers of low-risk, end-to-end consolidation solutions with the Unisys ES7000 servers. Download today! http://searchDatabase.com/r/0,,22873,00.htm?track=NL-94&unisys ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ALTERNATE WAY TO FIND DATABASE SIZE | Robert Oliver Here's a quick SQL Server script that finds the size of the database and separates the log and data file sizes. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci935717,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= USING 'INSTEAD OF' TRIGGERS | Alexander Kuznetsov First introduced in DB2 UDB V8.1, INSTEAD OF triggers are very useful when you need to modify the database structure without changing the applications running against the changed database. Here's an introduction. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci941941,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= GET USEFUL DETAILS ABOUT A TABLE WITH ONE QUERY | Ajay Garg This Oracle script gives a half dozen details about a table structure and dependencies at one go, including comments, keys, constraints, and more. >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci940473,00.html?track=NL-94 ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: SQL INJECTION: WHEN FIREWALLS OFFER NO PROTECTION | D. Litchfield http://www.searchDatabase.com/tip/1,289483,sid13_gci940262,00.html?track=NL-94 A detailed introduction to the basics of SQL injection, including best practices for defending SQL Server against such attacks. JDBC: AN INTRODUCTION | Alexander Kuznetsov http://www.searchDatabase.com/tip/1,289483,sid13_gci940272,00.html?track=NL-94 A detailed introduction to the JDBC API and how to use it for accessing virtually any kind of tabular data. 30 ORACLE TIPS IN 30 MINUTES | Kenny Smith http://searchoracle.techtarget.com/tip/0,289483,sid41_gci940637,00.html?track=NL-94 Brought to you by the IOUG, these quick tips and tricks are designed to make your DBA or developer job easier. Get help with database administration, development, RMAN and more! TROUBLESHOOTING REPLICATIONS | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci911714,00.html?track=NL-94 Here is a quick overview of replication in SQL Server and how to solve common problems. LEVERAGING USER-DEFINED DISTINCT TYPES | Alexander Kuznetsov http://www.searchDatabase.com/tip/1,289483,sid13_gci940590,00.html?track=NL-94 Did you know that you can protect your SQL from developer mistakes in DB2? You need to use UDDTs -- here's how. DON BURLESON'S FAVORITE ORACLE10G NEW FEATURES | Don Burleson http://www.searchOracle.com/tip/1,289483,sid41_gci939890,00.html?track=NL-94 With all of the hoopla surrounding the impending release of Oracle 10g, it is sometimes difficult to differentiate between the truly valuable features and the marginal new features. Guru Don Burleson discusses his favorites in this exclusive article. FIND THE PRODUCT OF A FIELD | Vadivel Mohanakrishnan http://www.searchDatabase.com/tip/1,289483,sid13_gci937838,00.html?track=NL-94 There isn't a prebuild function for finding the product of field or set of values in SQL Server. Here is a workaround using a combination of the SUM(), POWER() and LOG10() functions. INDEX COVERING AND QUERY PERFORMANCE | Alexander Kuznetsov http://www.searchDatabase.com/tip/1,289483,sid13_gci939445,00.html?track=NL-94 The DB2 rule of thumb "put the most selective column first in the index definition" is usually sound, but not always. Here is a situation when putting the most selective column last speeds up a query. COMPILE ALL INVALID OBJECTS INCLUDING THOSE WITH SYNTAX ERRORS | by Rastislav Ciganek http://www.searchOracle.com/tip/1,289483,sid41_gci938288,00.html?track=NL-94 Here's how to compile all invalid objects in Oracle, including these with syntax errors. It can by used for specific schemas or for whole databases and has more features than utlrp.sql. MAINTAIN RUNNING NUMBERS | Vadivel Mohanakrishnan http://www.searchDatabase.com/tip/1,289483,sid13_gci937840,00.html?track=NL-94 Here is how to maintain a running number if you need to combine fields from different tables in SQL Server 7 and 2000. DEFINING BUSINESS INTELLIGENCE USERS | Mike Beire http://www.searchDatabase.com/tip/1,289483,sid13_gci938533,00.html?track=NL-94 Users of BI systems can be delineated by application requirements and by skill. Here is how to define who is using your BI systems -- a critical step in enuring the success of your implementation. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html?track=NL-94 Share your knowledge, submit a tip, win a prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html?track=NL-94 ___________________________________________________________________ IMPORTANT LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts SQL SERVER: UPDATING AND ENHANCING A 6.5 DB | Robidoux and Kadlec http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid566195_tax294863,00.html?track=NL-94 DB2: ERROR -904 ON MVS | Craig Mullins http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid565483_tax285651,00.html?track=NL-94 SQL: LATEST TWO ROWS FOR EACH GROUP | Rudy Limeback http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid564938_tax285649,00.html?track=NL-94 SQL SERVER: INTRODUCTORY TUTORIALS ONLINE | Michael Hotek http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid565467_tax285648,00.html?track=NL-94 >> CLICK for other database expert answers... http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html?track=NL-94 >> CLICK for Oracle-related expert answers... http://searchoracle.techtarget.com/ateExperts/0,289622,sid41,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE ADMINISTRATION 101 | Featured Topic What does the modern enterprise DBA do? In today's environment, the answer is "just about everything." Look inside for tips and advice about the most important job duties of a DBA. http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci845011,00.html?track=NL-94 ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIM DICHIARA, Senior Site Editor (mailto:[EMAIL PROTECTED]) ROBYN LORUSSO, Site Editor (mailto:[EMAIL PROTECTED]) SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) ROB WESTERVELT, News Writer (mailto:[EMAIL PROTECTED]) GABRIELLE DERUSSY, Sales (mailto:[EMAIL PROTECTED]) ::::::::::::::::::::: ABOUT THIS NEWSLETTER :::::::::::::::::::::: 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?track=NL-94 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."
