DBA Tips: Comparing directory structures using T-SQL, and more...

[SearchDatabase.com]

Title: DBA Tips

November 24, 2004 Published by  SearchDatabase.com DBA Tips NEWS     TOPICS     ITKNOWLEDGE EXCHANGE     TIPS     ASK THE EXPERTS     WEBCASTS     WHITE PAPERS     Issue Sponsored By:   > Computer Associates (CA) IN THIS ISSUE:   >  Comparing directory structures using T-SQL   >  Implementing Oracle's MINUS set operator in T-SQL   >  SQL Server: Listing databases that have not been backed up   >  SQL Server: Identifying external or internal table fragmentation   >  Learning guide: Oracle performance tuning   >  Techno-gadgets for geeks   >  600 tips and scripts Comparing directory structures using T-SQL [Eli Leiba] There are times when SQL Server DBAs want to compare directory structures between different installations. Generally, this is done by using Windows Explorer and manually looking over the directory tree structures in both places. This process is vulnerable to human error. Here, the author suggests a different, automatic way of doing such a comparison. MORE INFO: > Hundreds more SQL Server tips and scripts   Learn from leaders...And become one yourself Hear from industry luminaries on the best practices to manage databases with greater efficiency -- By registering to attend the Computer Associates exclusive webcast series, you'll learn how to apply their knowledge to the management of your databases. Register today and obtain FREE software trials, database posters and white papers!   Implementing Oracle's MINUS set operator in T-SQL [Eli Leiba] This article describes how to implement the MINUS set operator that exists in Oracle SQL but unfortunately not in SQL Server 2000 T-SQL. SQL Server: Listing databases that have not been backed up [Eli Leiba] This article describes how to retrieve a list of all SQL Server databases that have not been backed up in a given hour's range. SQL Server: Identifying external or internal table fragmentation [Eli Leiba] This article describes how to identify tables that are fragmented internally (i.e., fragmentation inside data pages) or externally (ie, extents are fragmented). Learning guide: Oracle performance tuning [Don Burleson] A slow DBMS is not only annoying to users, it can affect your company's bottom line. This exclusive Learning Guide can help newbie and expert DBAs establish a smart approach to performance tuning, use and interpret Oracle's tuning utilities and identify specific problem areas. GADGET GUIDE 2004:  Techno-gadgets for geeks TechTarget's annual Gadgets & Gizmos guide is filled with helpful reviews on some cool electronic gizmos. If you're looking for a stocking stuffer for yourself or a fellow techno-friend, read our helpful reviews to see how our editors made out with these products in the real world. You'll find everything from notebooks to handhelds, mobile phones to mobile offices, tiny digital cameras and portable game systems. FEATURED TOPIC:  600 tips and scripts Looking for that perfect script that will make your life as a DBA or database developer just a tad easier? Well, you've come to the right place. We offer over 600 Oracle, DB2, SQL Server, and SQL tips, free for the taking. Enjoy! Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED] ABOUT THIS E-NEWSLETTER This e-newsletter is published by SearchDatabase.com, a targeted Web site from TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "DBA Tips": Go to unsubscribe: http://searchDatabase.techtarget.com/u?cid=497966&lid=430854&track=NL-94 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: SearchDatabase Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494