(graz) I spend a lot of my time reading through trace files. I’ve started writing a utility called ClearTrace to make this process easier. It summarizes the performance of stored procedures and SQL statements much like Read80Trace does. It has both a GUI and command line version and handes traces fo
Author: SSWUG Research
Table Partitioning in DB2 Viper
(Chris Eaton) As you may be aware, there are several technologies in DB2 v8.2 (and prior releases) that allow you to break up your data into smaller “chunks” to enable greater parallelism for queries, allow for partition elimination in queries and in general help improve performance. For example, Mu
FIX: A query may run more slowly against SQL Server 2000 post-SP3 hotfix build 8.00.0988 than a query that you run against SQL Server 2000 post-SP3 hotfix builds that are earlier than build 8.00.0988
When you run a query against Microsoft SQL Server 2000 post-Service Pack 3 (SP3) hotfix build 8.00.0988, the query may run more slowly than a query that you run against SQL Server 2000 post-SP3 hotfix builds that are earlier than build 8.00.0988.
MySQL, today’s contender
(Ian Gilfillan) In May 2003, I wrote an article entitled MySQL–Yesterday’s Toy, Tomorrow’s Contender. I followed it up a year later with MySQL, Still tomorrow’s contender? Two years have now passed, and, since it is May once again, I thought it is time to follow up and see where MySQL stands today.
Methods for Transforming data to a XML file
(Lalitha Venkatasubramanian) This articles mentions different ways to tranform data to XML file.
Format EXPLAIN PLAN results easily with Oracle’s DBMS_XPLAN
(Bob Watkins) When you need to troubleshoot inefficient SQL, one of the most important diagnostics tools at your disposal is the output of the EXPLAIN PLAN command. Find out how Oracle’s DBMS_XPLAN functions can help you tune your SQL statements.
What’s Up With dbms_stats?
(Terry Sutton) For years Oracle has been telling us to use the DBMS_STATS package instead of the ANALYZE command to gather statistics to be used by the Oracle optimizer. Many of us have heeded this advice and switched from using ANALYZE for scheduled statistics-gathering jobs to using DBMS_STATS. St
The Eclipse platform, Web tools and XML
(Ed Tittel) Eclipse is one of those development projects about which many people have heard, but only those who’ve worked inside its borders know what it’s really about. Though funded by IBM in large part, Eclipse is a manifold open source development effort that embraces a multitude of components a
What’s new with the IBM Database Add-Ins for Visual Studio 2005
(Vasantha Jayakumar) The IBM Database Add-Ins for Visual Studio 2005 provides significant enhancements to application development using DB2 databases, tight integration with Microsoft Server Explorer, and enhanced debugging. It introduces IBM Designers to create database objects and includes several
Working with Application Designer in Visual Studio 2005
(Satheesh Kumar) In this article we will see the introduction and usage of Application Designer which is one of the four new distributed designers introduced in the Visual Studio 2005 Team Architect Edition. First we will see how the Application Designer interacts with the other designers and then