In earlier versions of Oracle, it was not efficient to process collections that contained sparse element collections. Without the save exceptions clause specified, the statement being executed would terminate when it reached the first deleted element. With save exceptions specified, the operation wo
Author: SSWUG Research
Frozen streams: an experimental time- and space-efficient implementation for in-memory representation of XML documents using Java
(Alex Brown) As XML becomes a pervasive technology for data storage and processing, many adopters of the technology face a practical problem caused by the perceived slow performance of many XML processing operations, particularly in comparison to tried and trusted RDBMS-based solutions that are bein
Compliance-Enabled Call Recording
(James Gannaway) Ever since Alexander Graham Bell invented the telephone in 1875, people have wanted to record and retrieve conversations. Although that basic desire hasn’t changed, the reasons for recording calls and efficiently retrieving them certainly have. Organizations today face more legal, f
SQL and XQuery tutorial for IBM DB2, appendix: Appendix A
(Pat Moffatt, Bruce Creighton and Jessica Cao) Appendix A describes all of the tables in the Aroma database, which consists of two schemas: a simple star schema for retail sales information and a multistar schema for purchasing information. This appendix belongs to the SQL & XQuery Tutorial for IBM
The performance of System.Xml – Insert operations
(Bcoelho) In this post, I will analyse the ways that you can add nodes to a XmlDocument and wich way is the fastest, using the .NET framework 1.1.
Monitoring and Troubleshooting Replication Using SQL Server 2005
(Baya Pavliashvili) The first two articles in this series taught you how to set up and maintain transactional replication with SQL Server 2005. The latest release of SQL Server introduced numerous enhancements to replication, and monitoring tools have changed quite a bit. This article shows you how
Build molecular queries from atoms in SQL Server
(Arthur Fuller) Every SQL Server developer has a preferred method of doing things; mine is what I call molecular queries. These are queries assembled from atomic queries; by which, I mean that they address exactly one table. By combing atoms, I can create molecules. There are restrictions of course
Indexes made handy in SQL Server
(Jeremy Kadlec) When starting an application, you should be able to identify many of the indexes based on a reasonable set of rules. As the application grows and changes, the indexes should be reviewed to ensure no good index candidates are overlooked. It should be based on how the application is us
MDX Numeric Functions: The .Ordinal Function
(William Pearson) In this lesson, we will expose another useful function in the MDX toolset, the .Ordinal function. The general purpose of the .Ordinal function is to return the ordinal value of a specified dimensional level. The .Ordinal function is particularly useful within scenarios where we emp
Why move to V8 NFM: Reason #1
(Willie Favero) Once you finish your V8 upgrade to new function mode (NFM), something you will want to take advantage of almost immediately is the new sample program DSNTEP4. DSNTEP4 is an upgraded flavor of the well established sample program DSNTEP2. Written in PL/I just as its predecessor, DSNTEP