(Jim Czuprynski) Oracle Database 11gR1 introduces SQL Plan Management, a new set of tools that allows an Oracle DBA to capture and preserve the most efficient execution plans for any SQL statement, thus limiting the impact of refreshed optimizer statistics, changes to existing applications, and even
Other News
How to disable optimizations when debugging Reference Source
(Shawn Burke) When you debug code in the .NET Framework using the newly available Reference Source functionality in VS 2008, you may notice that many variables are not available for inspection.
Split Sdo_Geometry Linestring at a known point
(Simon Greener) I recently received an email from someone asking me: Just wondering if you could shed some light on a problem I have. In oracle using PLSQL I need to cut a polyline at two know (sic) points (not necessarly vertices and the line may be not be straight) and copy the cut line into an
Visual Studio 2008 offers developers more testing options
(Tony Patton) Unit testing has evolved from a fringe activity to an industry-accepted way to develop software. This change in attitude was aided by the introduction of numerous freely available testing frameworks — most notably, NUnit.
DB2 History 101: Version 1.2
(Willie Favero) Even though DB2 V1.1 had only been GA for 10 months, Database 2 (DB2) Version 1 Release 2 was announced on February 4, 1986. Just one month later on March 7, V1.2 went GA. Since DB2 had now been in use by the general database community for a whole year almost (not counting the time i
Don’t Underestimate MySQL
(George J. Trujillo Jr.) A lot of the popularity of MySQL is its ease of installation and how easy it is to use out of the box. Anyone can install MySQL pretty easily. That is the danger of MySQL. Because MySQL is so easy to install, people can forget or not realize that MySQL is a full blown databa
Travels with Mark: A Hitchhiker’s Guide to the UniVerse, Part 5: Increase dynamic array processing performance in IBM UniVerse
(Mark Baldridge) This installment of the UniVerse performance series, investigates the effects of field-level caching in dynamic array access and suggests improvements for dynamic array access. (R)
Optimization Service Center Helps You Tune Your Applications and Queries in DB2 9 for z/OS
(Patrick Bossman and Gene Fuh) DB2 9 for z/OS includes new tools to improve the productivity of application developers and DBAs in tuning SQL workloads and individual SQL statements. Optimization Service Center (OSC) is a workstation tool for monitoring and tuning SQL workloads and individual SQL s
Nesting Transactions with a Single SQL Server Database
(Jani Järvinen) Many applications developed for the corporate world deals with SQL databases, and proper transaction handling is a central requirement for performance and robust data storage. When you are using C# to access data in Microsoft SQL Server databases, you are using transactions either im
Database Configuration Options
(Buck Woody) I’ve explained the options for configuring a server instance, and databases also have options for configuration. These options have to do with many parts of the database operation; from the way it protects the transactions to restricting the number of users who can access it.