DBA Tips: Implementing Oracle's MINUS set operator in T-SQL, and more...

[SearchDatabase.com]

Title: DBA Tips

Free White Paper: Why Build? When you can Buy! Many business demands involve high volumes of data such as e-commerce initiatives, application integration and compliance requirements. Integration software exists yet many organizations are unsure if they should rely on a "store bought" package instead of developing applications in-house. Learn about "build versus buy" considerations of an organization faced with the need for an integration application. Click here.

DB2 logging strategies
[Roger Sanders]
Two very different logging strategies, known as circular logging and archival logging, are available in DB2. But according to this short article, a hybrid method called infinite active logging might work best.

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).

Understanding Oracle editions and options
[Don Burleson]
Guru Don Burleson's guide to understanding the bewildering array of features and options in the various editions of the Oracle DBMS.



GADGET GUIDE 2004:  Just in time for the holiday season!
TechTarget's annual Gadgets & Gizmos guide is filled with helpful reviews on some of the coolest products available. 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:  Ask the SQL expert
Our expert Rudy Limeback has been in the database field for 25 years and he knows his SQL. Browse his 350+ answers to your tough SQL questions.

	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=496582&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