(Craig Mullins) Since update of a record in one session leads to locking of the page (hence other records that belong to the same page are also locked), what is the workaround so that the application locks only the particular record that is being updated (i.e controlling the locking lower than table
Other News
Install and Configure IBM DB2 Universal Database Express Edition in Client/Server Environment
(Michael Gao) This article will demonstrate how easy it is to use DB2 GUI tools to install and configure DB2 UDB Express in client/server environments. In a client/server environment, your application is deployed on a separate machine from the database server machine. The machine which hosts you
EXSLT Meets XPath
Dare Obasanjo combines his efforts from a previous article on EXSLT with those of Oleg Tkachenko’s article on creating multiple outputs from a single XSLT transformation to create a customer EXSLT library for the .NET Framework that includes support for EXSLT functions to regular XPath queries.
XML Reflection for CORBA
(Steve Vinoski and Douglas C. Schmidt) Some programming languages, such as Java and Smalltalk, support reflection or introspection. This feature allows applications written in these languages to obtain information about objects and classes at runtime, typically using this information to perform dyna
Partition Outer-Joins
(Jonath1n Gennick) I don’t usually write about new Oracle features for this list, because so few people can use them, but this time I’m going to break that pattern. Oracle Database 10g brings a new feature called the “partition outer-join”. You use the feature to “densify” data, to fill in missing
Using Multi-Column Indexes
When an SQL request is commonly issued using multiple columns, a concatenated or multi-column index can be used to improve performance. Oracle supports the use of multi-valued indexes, but there are some important limitations. Unlike other relational databases, Oracle requires that all columns in th
Comparing Contents of Two Tables with Identical Structure
(Sanjay Ray) This script generates a spool file that can be run from a SQL*Plus session to list the differences between 2 tables with identical structure. This can be useful if 2 similar tables need to be compared across different schemas (or different databases, in which case a local view will
SQLXML Explained
(Ken Henderson) This chapter updates the coverage of SQLXML in my last book, The Guru’s Guide to SQL Server Stored Procedures, XML, and HTML. That book was written before Web Release 1 (the update to SQL Server 2000’s original SQLXML functionality) had shipped. As of this writing, SQLXML 3.0 (which
HOW TO: Troubleshoot DTS Packages That You Run from Visual Basic Applications
When you run a Microsoft SQL Server Data Transformation Services (DTS) Package from a Microsoft Visual Basic application, the package may fail without raising any error messages to help you to troubleshoot the failure. This article describes how to troubleshoot DTS packages that you run from Visual
Know Your System: Top Five SQL Server Questions
(Buck Woody) Have you ever had someone who treats all technology as equally mysterious ask you to take over a SQL server? He or she assumed you could handle it—after all, you know all about that “computer stuff,” right?