|
|||||||||||||
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.
Make your iSeries database easy to read
[Search400.com]
This article takes a quick look at making your iSeries database easier for users to read. By creating simple data marts and using SQL views, you can make your production data understandable for user reporting.
SQL Server: Identifying external or internal table fragmentation
[Eli Leiba]
This article describes how to identify tables that are fragmented internally (ie, fragmentation inside data pages) or externally (ie, extents are fragmented).
Oracle: Queries to retrieve table metadata
[Glenn Wiens]
This utility provides a quick view of tables, including their relationships (parent and children tables/columns), indexes and grants.
NEWS ANALYSIS: CA swings at Oracle, SQL Server with Ingres
Computer Associates International Inc. is making its open sourced Ingres DBMS widely available today, pitching its mature features and 64-bit support at Oracle and SQL Server customers.
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.
|
|
||||||||||
|
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=496196&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: |
||||
