(Goce Smilevski) Alexander Kozak described an efficient row-based solution for the problem of identifying islands and gaps in sequential numbers in his article, Islands and Gaps in Sequential Numbers. The set-based solutions described there were not very efficient, especially when the input data was
Other News
DB2 Development Center — The Next-Generation AD Tooling for DB2
(Abdul H. Al-Azzawe) This article describes some of the technical highlights of the new Development Center and describes some of the major tasks you can do with the center, such as developing stored procedures, user-defined functions, and specialized table functions. If you are particularly interest
How To: Shape FOR XML AUTO results using SQL views
Sometimes it is easier to use FOR XML AUTO to retrieve XML from SQL Server than it is to use FOR XML EXPLICIT. However, if you’re combining data from multiple tables you may not get results you expect using the AUTO mode. Suppose that we want to get a list of the products in our database, but we
Oracle on Windows
(Steve Callan) Microsoft takes a beating at times from frustrated users of its own products and from users of third party products hosted on Windows. When it comes to using Oracle on Windows, it seems that a frequently appearing solution to problems is to reboot the PC. In reality, rebooting is nece
MDX in Analysis Services: Optimizing MDX: More on Location, and the Importance of Arrangement
(William Pearson) In our last tutorial, Control Location of Processing, we began a three-part mini-series, Optimizing MDX. We stated that the objective of this “triptych” is to explore methods for optimizing the performance we obtain from our MDX queries. We introduced types of intervention, or clas
Query Optimization For OLAP-XML Federations
(Dennis Pedersen, Karsten Riis and Torben Bach Pedersen) In this paper we present novel techniques for query optimization in federations of OLAP and XML databases. The techniques include so-called inlining of XML data in OLAP predicates, caching, and pre-fetching. Experiments show that the proposed
Using Oracle’s Time Zone Feature
(James F. Koopmann) A few articles back I wrote on a comparison between the DATE datatype and the TIMESTAMP datatype. This article goes one step further and explores Oracle’s TIME ZONE feature of the TIMESTAMP datatype. In particular, Oracle has added the "WITH TIME ZONE" and the "WITH LOCAL TIME ZO
Oracle Net Configurations: Find the Weak Link
(Shirish Joshi) Performance and connection are the main issues developers and testers face when deploying Oracle applications. Most of the connection issues can be traced to how the Oracle Net Services and its related components are configured. According to the Oracle Manual, Oracle Net Services
List Table Names, Rows, and Created Date
(Pasupuleti Sailaja) This script will display table names, number of rows existed in table and table created date in current login user for any ORACLE version. (script)
The Trigger-Happy DBA – System Triggers
(Steve Callan) So far, the trigger-happy DBA series has dealt with triggers related to Data Manipulation Language (DML) operations. As mentioned in the beginning of the series, another type of useful trigger is that of the system trigger. System triggers can be delineated into two categories: those