=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips February 6, 2002
Essential tools and advice for the enterprise DBA: http://searchDatabase.techtarget.com/tips/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Troubleshooting locking conflicts - SQL Server: Automatically formatting your T-SQL code - Oracle: Total record count per schema - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Expert: Oracle, SQL Server, DB2 questions answered - New Fabian: MySQL, views, and the relational model - Featured Topic: Data security ___________________________________________________________________ ************** FREE SUBSCRIPTION TO STORAGE MAGAZINE ************** Storage is now a front and center issue. No longer "just capacity," storage is a critical IT asset that must be managed effectively. Increasingly complex, it's become a huge percentage of your overall IT budget. That's why we created Storage magazine, a new resource to help you set your storage strategy, manage storage effectively, and make key vendor selection and architecture decisions. Subscribe today FREE and as a bonus you get the FREE 42-page Storage Networking special report! Visit http://ad.doubleclick.net/clk;3802184;5058249;k?http://www.storagemagazine.com __________________________________________________________________ __________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TROUBLESHOOTING LOCKING CONFLICTS | by Baya Pavliashvili Troubleshooting locking problems in SQL Server is one of those events that DBA's would much rather avoid; alas, most have to it do at one point or another. In fact, understanding database transactions and locking is what differentiates many beginners from the real pros. This article is an overview of potential locking problems, what causes them, how to detect and resolve them. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci800525,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= AUTOMATICALLY FORMATTING YOUR T-SQL CODE | by Cade Bryant It is good business practice to format your T-SQL code in order to make it more readable to others. The accepted standard includes capitalizing keywords, applying indentations before certain clauses, using appropriate spacing, and others. However, many developers find it inconvenient to be format-conscious while trying to code. Here's a way to accomplish this quickly and easily. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci800526,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TOTAL RECORD COUNT PER SCHEMA | by Rohit Sinha This Oracle script counts the number of records in all tables in a particular schema in a particular instance. It prompts for USER and INSTANCE. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci799183,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: FREE CODE: VIEWS A DATABASE, TRANSACTS CUSTOM SQL STATEMENTS http://www.searchDatabase.com/tip/1,289483,sid13_gci799193,00.html This is a simple, free program that views a database and transacts custom SQL statements in SQL Server 2000. The SQL-VB connection established here is often the foundation of front-end applications. This project uses ADO programming techniques. ENCRYPTING A STRING TO A VARBINARY(128) | by Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci799191,00.html This Oracle code is useful when encrypting sensitive data (like passwords) into a varbinary. The PWDENCRYPT and PWDCOMPARE functions are used to encrypt and compare DATA passwords not visible anywhere in the database. WHICH INDEXES REQUIRE A RE-BUILD? | by Danny Mohar http://www.searchDatabase.com/tip/1,289483,sid13_gci798208,00.html This Oracle script is used to determine which indexes require a re-build to assist with system performance. A ratio of 10-20% deleted lf rows to lf rows may be candidates. The script will attempt to use dynamic SQL to execute the DDL commands required to execute the analyze table commands directly. The script will then re-build the indexes above a specified level of deleted rows. 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: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's toughest database questions answered DB2: Listing rows using current date, Part II http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid432119_tax285651,00.html SQL: Key factors for successful SQL http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid424593_tax285649,00.html Oracle: What is a petabyte? http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid431961_tax285650,00.html SQL Server: DTS error converting varchar to numeric http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid431626_tax285648,00.html Data Warehousing: Metadata management stategy for a bank, Part 1 http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid407871_tax288371,00.html Dozens more expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WHEN WILL THEY EVER LEARN? PART II | Against the Grain Fabian Pascal continues his examination of MySQL and why views (virtual tables) are essential to the relational model. A memorable quote: "IMS is a DBMS, but it's a hierarchic, not a relational one. Oracle is not a truly and fully relational DBMS, only a SQL one. MySQL is essentially a file manager." Ouch! >> CLICK for the full column... http://www.searchdatabase.com/tip/1,289483,sid13_gci799976,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATA SECURITY | SearchDatabase Featured Topic For obvious reasons, data security tops everbody's IT priority list for 2002. Check out our collection of database security tips and ask expert Shaku Atre your tough data warehouse security questions on Feb. 5 at 1 pm EST. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci799971,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ ***** STORAGE MANAGEMENT CONFERENCE | Hosted by searchStorage ***** Ask questions and hear directly from EMC Executive Chairman Michael Ruettgers, who joins our March 20-22 Storage Management conference in Chicago. Also speaking are Giga Information Group's Bob Zimmerman; prolific storage author and speaker, Jon William Toigo; Storage Group founder W. Curtis Preston; BMC's CEO Bob Beauchamp; VERITAS CEO Gary Bloom; and many more. Don't miss out! Qualify for FREE attendance today: http://ad.doubleclick.net/clk;3829700;5058249;n?http://www.storagemanagement2002.com/html/registration.htm ___________________________________________________________________ ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Submit your original tip here. TIM DICHIARA, Site Editor (mailto:[EMAIL PROTECTED]) >> Feedback and original articles. ED PARRY, News Editor (mailto:[EMAIL PROTECTED]) >> Product announcements and poll ideas. 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 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.
