by John E. Simpson – Before getting into this month’s questions, I wanted to discuss a change in this column’s standard operating procedures. In the nearly three years that I’ve been writing “XML Q&A,” all questions I’ve answered have been drawn from a single source: the O’Reilly Network XML Forum.
Author: SSWUG Research
Extreme XML: Producing Multiple Outputs from an XSL Transformation
Oleg Tkachenko explains how you can postprocess XSL transformation results into multiple documents using the XslTransform and XmlTextWriter classes.
DB2 UDB: The cure for the common RAC attack
Make sure that when you are evaluating the cost of an Oracle RAC solution, you include the software costs, not just the hardware cost differences. It’s likely that any potential difference in hardware costs will be overshadowed by the increased costs for the Oracle database and the additional Oracle
It All Depends on the CONTEXT: Using Oracle’s SYS_CONTEXT Function
by Jim Czuprynski – The SYS_CONTEXT function is the recommended replacement method for obtaining information about users and environment variables instead of the deprecated USERENV function. This versatile function has been expanded in Oracle 9i to provide a plethora of information about the Oracle
MAXdbt Launches Application Performance Management Suite
MAXdbt, a provider of Application and Database Monitoring, Database Administration, and Development software tools, has announced its new Application Performance Management Suite. The Suite includes End-End Software’s, an end to end application monitor and MGA EagleEye, a SQL Performance Monitor and
Use XSL-FO for page breaks and tables
by Benoît Marchal – The Formatting Objects (FO) standard offers powerful properties for controlling the layout of printed documents. This tip shows you how to control the insertion of page breaks for better-looking documents. I’ll present a standard method that works with commercial FO renderers, an
Reporting Bad SQL Code in DB2
Poorly written SQL code can cause database slowdown. Marin Komadina explains how to collect and identify slow-running SQL statements.
DB2 Enterprise Server Edition for Linux – V8.1
IBM’s DB2 V8.1 for Linux provides new levels of information integration. DB2 UDB V8.1 marks the next stage in the evolution of relational database providing for new levels of information integration within your e-infrastructure. DB2 UDB V8.1 allows you to access any information, from any application
Importing and Indexing Microsoft Word Documents Using SQL Server
Q. I want to import Microsoft Word documents into SQL Server and then index the documents so I can use them in relational queries. How can I import and index the documents? A. SQL Server allows you to import Word documents in several ways. Let’s look at the most common methods.
Is a Temporary Table Really Necessary?
You will find articles on this site as well as others advising you to avoid the use of temporary tables to maximize the performance of your queries. I agree with the articles, but would like to add that sometimes you cannot avoid the use of a temporary table.