(Eddie Awad) The join condition determines whether a join is an equijoin or a non-equijoin. An equijoin is a join with a join condition containing an equality operator. An equijoin combines rows that have equivalent values for the specified columns. When a join condition relates two tables by an ope
Other News
Power of MySQL Storage Engines
(Peter Zaitsev) Where does real power of MySQL Storage Engines, and pluggable storage engines as MySQL 5.1 lays ? It is very much advertised this allows third parties to create their own storage engines and we can see solutions as Solid and PBXT . Plus there is Falcon storage engine being developed
DB2 Import Commands Failing With ‘transaction log for db is full’ Errors
(Andrew Law) Trying to upload test data with the DB2 Import Utility. I have a .CSV file with 100,000 records in it. It used to work; then I added another column and now it fails with “transaction log for database is full” errors.
Poking around SQL Server’s Transaction Log
(Andrew MacNeill) I recently had the opportunity to try and figure out why SQL Server was doing certain things in one of my applications. This application was using CursorAdapters and for some strange reason, data was being cleared out (for no apparent reason, of course).
Looking into Visual Studio 2005 and its first Service Pack
(Ed Tittel) What with a new desktop OS (Vista, in all its many versions) and a new version of MS Office (2007) on the scene, there’s been plenty of action around Visual Studio in the past few months. Given all the new functionality those two introductions trailed in their wake, not to mention more t
Improve performance by compressing ViewState
(Bipin Joshi) Developers often worry about performance of their web sites. Every developer wants that his web site be optimized for good performance. There are several factors affecting performance of your web site and one of them is ViewState. In this article I am going to show a way by which you c
User Database Query Tool
(KChandos) From time to time programmers come across users who, for whatever reason, seem to actually want to code T-SQL in order to find the information that they need. In an SQL Server environment, a common way to give them this capability is to install the SQL Query Analyzer product. Beginning wi
IBM Content Manager Integrator for Workplace Forms
(Arthur Choi) Replacing paper with electronic documents brings many advantages to a business: faster processing, concurrent access by multiple people, and the possibility of a single system of record with audit trails. We do a good job when dealing with scanned images and computer-generated document
Querying and Updating Probabilistic Information in XML
(Serge Abiteboul and Pierre Senellart) We present in this paper a new model for representing probabilistic information in a semi-structured (XML) database, based on the use of probabilistic event variables. This work is motivated by the need of keeping track of both confidence and lineage of the in
Execute an XPath and get the line numbers
(Oleg A. Paraschenko) I’m investigating the structure of an XML file. The best tool is an usual text editor (vim), but I need to look at some specific tags in some specific contexts. The idea is to execute an XPath and somehow to get to the location in the editor. Remembering that I saw something in