Title: DBA Tips
![]() |
![]() |
![]() |
Issue Sponsored By:
![]() Quest Software
![]()
IN THIS ISSUE:
![]() SQL Server: Guidelines for creating indexes
![]() DB2: Generating XML from SQL data
![]() Oracle: Analyzing all tables in schema
![]() SQL Server: Introduction to SQLXML
![]() DB2 v8 certification: Everything you need to know
![]() Learning guide to SQL
![]() Availability
![]()
![]() |
![]() |
![]() |
![]() |
Optimize Oracle 9i Instance Memory
Download Quest Software's white paper "Optimizing Oracle 9i Instance Memory." Learn how dynamic SGA, automatic SQL execution management and Oracle advisories and their use in resizing can help optimize instance memory management in your environment.
Click here to download. |
![]() |
![]() |
![]() |
![Advice]()
![]()
SQL Server: Guidelines for creating indexes
[Barrie Sosinsky]
A well-performing DBMS minimizes index creation while emphasizing the creation of the "right" mix of indexing. Here are some rules to guide you in your table designs when you are trying to decide what to index.
DB2: Generating XML from SQL data
[SearchDatabase.com]
You are an RPG programmer. You could use the XML parser APIs on the iSeries to learn how to do DOM or SAX parsing to generate XML documents. Good idea? No! Learn how to easily generate XML from SQL without coding using WDSC in DB2/400.
Oracle: Analyzing all tables in schema
[Printaporn Sangdara]
Here is some dynamic SQL that calls the dbms_stats package to analyze all tables (excluding the temporary table) in the caller's schema. This gives better statistics than Oracle's recommended dbms_stats.gather_schema_stats.
SQL Server: Introduction to SQLXML
[Ken Henderson]
This chapter from a new book by Ken Henderson describes how SQLXML technologies are designed and how they fit together from an architectural standpoint. As with the rest of the book, the author's intent here is to get beyond the "how to" and into the "why" behind how SQL Server's technologies work.
DB2 v8 certification: Everything you need to know
[Howard Fosdick]
The whats, whys, and hows of DB2 certification are presented in this detailed article.
Learning guide to SQL
[SearchDatabase.com]
Our crash course in the lingua franca of the database world, the structured query language, including tips, advice, and scripts from the gurus...
![Also on SearchDatabase.com]()
![]()
ASK THE EXPERTS: The effect of normalization on query simplicity
Our SQL expert Rudy Limeback answers the question:
TOPICS: Availability
If you DBAs haven't yet reached the 'five nines' (99.999% uptime) for your mission-critical databases, you'll need the tips, tutorials, webcasts, and news analyses inside...
![]() |
![]() |
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]
|
|
![]() |
![]() |
|
![]() |
|
![]() |
|
