(Mike Selvaggio) If you need to calculate working days between 2 dates and you can’t create the Oracle-recommended working days function, here is the SQL that can accomplish the same task.
Other News
Star join optimization in DB2
(Terry Purcell) Since the introduction of the Star Join access method in Version 6 of DB2 UDB for z/OS and OS/390, there have been many additional enhancements to improve the detection of star schema queries to determine the most efficient access path, and also to minimize regression of non-star sch
XML: To CLOB or Object?
In the January/February 2003 issue of Oracle Magazine, Jonathan Gennick wrote about XML DB and explained some of its capabilities offered in Oracle9i Database Release 2. Gennick referred to the two different storage architectures of the new datatype, XMLType: CLOB (Character Large Object) and struct
So, Could Microsoft Ever ‘Own” XML?
Last month, Microsoft applied for a patent to cover a word-processing document stored in a single XML file. That was in Europe and New Zealand. “The present invention,” it said in its accompanying Summary submitted to the European Patent Office, “is directed at providing a word-processing docum
Using Oracle’s SQL Functions
(Steve Callan) Oracle provides quite an array of functions when it comes to manipulating data via SQL. The Oracle9i SQL Reference guide (for release 2) lists five categories of SQL functions, with each category containing one or more functions within a category. The major functions are single-row, a
SQL Server Contention: Diagnosing and Resolving Blocking Problems
With more concurrent users on the same system, you run the risk of being forced to wait for each other or reading inconsistent data due to in-progress changes. The trade-off between accuracy and throughput is critical; it can have a major impact on your SQL Server performance. Download Quest Soft
Seeing is Believing
(Michael H. Alcorn) Anyone who has ever surfed the Web or tried to buy something online knows how critical performance is to Internet-based companies. Fast responses and well-designed sites don’t guarantee that customers will do their research on or buy something from a particular company’s site. Bu
Remember ebXML? – Doing business in real time
(David S. Linthicum) While there are many standards that look like ebXML, ebXML is the first horizontal standard designed to address the exchange of information and adherence to inter-enterprise processes. However, in attempting to reach this lofty goal, ebXML is also a complex standard and takes so
Death, Taxes, and Relational Databases, Part 2
(Andrew Conrad) The second in a series of articles by Andrew Conrad showcases the XML functionality of SQL Server 2000 by turning SQL Server into an object repository using XML as the bridge between relational and object-oriented data.
Oracle9i Replication: Multitier Materialized Views
Materialized views, known as snapshots in prior releases, are used to replicate data to non-master sites in a replication environment. Updatable materialized views enable users to maintain data at their local site (even a mobile user with a laptop) and later resynchronize with main site by applying