=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Developer Tips February 13, 2002
Essential tools and advice for the enterprise database developer: http://searchDatabase.techtarget.com/tips/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE DEVELOPER TIPS - SQL: Converting an adjacency list model to a nested set - SQL Server: Automatically formatting your T-SQL code - SQL Server/VB: View a database, transact custom SQL statements - Oracle: Oracle alert log miner in C - 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: DBMS reviews & comparisons ___________________________________________________________________ ********************** Sponsored by: Sybase *********************** Learn More About the Market Leading Embedded Database There's an art to hiding genius in plain sight. And we've hidden a lot. SQL Anywhere(R) Studio 8.0 is self-tuning, self-administering and always ready to serve. For a free download or evaluation CD click here. http://ad.doubleclick.net/clk;3830722;6845045;i?http://www.ianywhere.com/hiddenonline ___________________________________________________________________ ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CONVERTING AN ADJACENCY LIST MODEL TO A NESTED SET | by Joe Celko One way of representing trees in SQL is to show them as nested sets. Since SQL is a set-oriented language, this is a better model than the usual adjacency list approach you see in most text books. Here is a detailed article, with sample code, about converting between the two models. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci801943,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, especially if they have a lot of code to type and limited time. Here's a quick and easy way to accomplish this. >> CLICK for the full tip... http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci800526,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FREE CODE: VIEW A DATABASE, TRANSACT CUSTOM SQL STATEMENTS This is a simple, free program (with source code) 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci799193,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE ALERT LOG MINER | by Bill Robillard This is an extensive C program that extracts lines from the Oracle alert log for a specified date (or date range). The lines extracted depend on the entries in a 'pattern' file. Included is the syntax and an example of a pattern file and a sample command. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci801900,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TROUBLESHOOTING LOCKING CONFLICTS | by Baya Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci800525,00.html 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. TOTAL RECORD COUNT PER SCHEMA | by Rohit Sinha http://www.searchDatabase.com/tip/1,289483,sid13_gci799183,00.html **JANUARY TIP CONTEST PRIZE WINNER!** 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. 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 COMPAQ DISK-ON-KEY! http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html ___________________________________________________________________ ***********QUALIFY TO ATTEND OUR FREE WINDOWS CONFERENCE ********** Don't miss our Windows Decisions conference May 8-10 at the Hilton Chicago Hotel. Attend and discover: ** How to succeed with Active Directory ** Hidden tactics to lower your TCO ** Best practices for Windows 2000 systems management ** End-to-end network administration strategies ** How to solve your top 10 Windows interoperability problems ** Much more... View full session info and apply today for FREE attendance at http://ad.doubleclick.net/clk;3903337;5058249;m?http://www.windowsdecisions.com/ ___________________________________________________________________ ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's toughest database questions answered DB2: Clustering explained http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid447727_tax285651,00.html SQL: Listing data from multiple rows http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid445917_tax285649,00.html Oracle: Adding capacity to existing tablespace http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid447733_tax285650,00.html SQL Server: Migrating to SQL Server from Access http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid446666_tax285648,00.html Object-oriented databases: Web sites and downloads OORDBMS http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid446630_tax288550,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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DBMS REVIEWS & COMPARISONS | SearchDatabase Featured Topic One of the most common requests we at searchDatabase receive is for independent product reviews. We aim to please, so here is a collection of 100+ Oracle, SQL Server, and DB2 reviews, comparisons, and analyses... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci801069,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,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. ED PARRY, 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. 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.
