SEARCHDATABASE.COM | Database Administrator Tips May 1, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Master today's most popular database and put yourself in demand! http://searchDatabase.com/r/0,,2989,00.htm?OracleProfLibrary =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Scheduling jobs to run daily - Oracle: Allow a user to kill certain sessions - Oracle: Grant and create user in one step - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Expert: SQL Server, DB2, & Oracle questions answered - Featured Topic: Business intelligence ___________________________________________________________________ ************** Sponsored by: Computer Books Direct **************** Master today's most popular database and put yourself in demand! The Oracle 9i Professional Library - a 3-volume, 1-CD-ROM set - a $169.97 value - can be yours for $9.99, with membership in Computer Books Direct! This insider's library will give you the most up-to-date security tips for your Oracle database as well as the latest information on the newest Oracle 9i tools! Click for details! http://searchDatabase.com/r/0,,2989,00.htm?OracleProfLibrary ___________________________________________________________________ ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SCHEDULING JOBS TO RUN DAILY, WITH EXCEPTIONS | Luigi Visintin Here is a very simple way to schedule a job to run daily (or any other time interval) and not run on a specific day (a local holiday, for example). >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci820608,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ALLOW A USER TO KILL CERTAIN SESSIONS | Kevin Nicholson This procedure will allow you to give a user the ability to kill any session other than SYS, SYSTEM, DBSNMP, REPADMIN, OUTLN and the background processes without giving them the alter system privilege. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci809855,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= GRANT AND CREATE USER IN ONE STEP | Sameer Wadhwa Most of the time, you probably create a user with a CREATE USER command and then give grants. This is a two-step process. Here's how to do it in one step. Suppose you want to create a user SAMDBA and give the CONNECT and RESOURCE grants to it. You can simply do as follows: GRANT CONNECT,RESOURCE to SAMDBA IDENTIFIED BY SAMPASS This command will create a USER SAMDBA and also give a grants to it. >> CLICK for the online version of the tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci813646,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MIGRATING DATABASES FROM DEVELOPMENT TO PRODUCTION | B. Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci814958,00.html An extensive SQL Server script that compares tables, indexes and constraints on two servers and generates a comprehensive report of differences. CREATING A TABLE WITH THE AS SELECT CLAUSE | Will Chaster http://www.searchDatabase.com/tip/1,289483,sid13_gci809876,00.html Here's how to create and name an Oracle table with the AS SELECT clause. DATABASE STARTUP/SHUTDOWN UNIX SCRIPT | David Busfield http://www.searchDatabase.com/tip/1,289483,sid13_gci809875,00.html If you have multiple databases active at one time, this Oracle Unix script will come in handy. It will start or shut down a particular database via crontab. SQL PERFORMANCE COST TAKEOUT TIP | Tom McGannon http://www.searchDatabase.com/tip/1,289483,sid13_gci816005,00.html One easy cost-saving step is to check high cost DB2 plan explains for index access with no matching columns, and then check the application code to see if the host variable field size and the column size are the same for the first column on the index. DB2 will not match columns on the index if the field sizes are different. A simple fix that can save big bucks! 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 SAMSUNG DVD/MP3 PLAYER! http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz805991_cts805990,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered Database design: Table design: go across or go down? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid464184_tax285653,00.html SQL Server: Scheduling jobs to run on alternate Saturdays http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid464253_tax289343,00.html SQL: Retrieving last row inserted http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid464176_tax285649,00.html Oracle: UNION of two Oracle 8i views with CLOBs http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid464606_tax285650,00.html DB2: Static vs. dynamic SQL use http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid464565_tax285651,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html Hundreds more free expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL SERVER AND .NET | SearchDatabase Featured Topic Microsoft is pinning its hopes for domination of the enterprise on integrating its .NET platform -- C#, VB.NET, ADO.NET, etc. -- with SQL Server. Check out our free Webcast on this topic on Tuesday and more .NET info and tips inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci819576,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Submit your original tip here. 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 2002, 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."
