(Renee Mason) More than once, I’ve gotten a call from a DB2 System i client complaining of slow database performance. Later in our conversation, the client will mention experiencing an abnormal system end sometime ago. We discover that several access paths were marked invalid after the crash and are
Author: SSWUG Research
Oracle to update JD Edwards World at Collaborate ’07
(Mark Brunelli) Oracle is set to release JD Edwards World A9.1 — the newest version of its full-service ERP suite for IBM iSeries — at Collaborate ’07 Oracle users conference in Las Vegas. (R)
Oracle to Announce ‘Project X’ Integration Framework
(Renee Boucher Ferguson) Oracle is developing a new service-oriented architecture strategy that could overtake the momentum around its Fusion Applications initiative, according to sources close to the company.
The Clustering Factor (Sample Chapter)
(Jonathan Lewis) In the previous chapter, I warned you that the clustering_factor was an important factor in the cost of using a B-tree index for a range scan and could easily be the biggest cause of errors in the calculation of cost. It’s time to find out why things can go wrong. (pdf)
Ipedo: Unifies XML, SQL for XQuery
(Vance McCarthy) Earlier this year, Ipedo launched a major enhancement to its XQuery Views capability in Ipedo XIP to provide corporations deeper insight into their corporate data and content held in Oracle, IBM and Microsoft data stores.
SQL SERVER 2005 Disable Triggers – Drop Triggers
(Pinal Dave) There are two ways to prevent trigger from firing.
Using the New MySQL Query Profiler
(Robin Schumacher) One of the great things about MySQL is the superior innovation model that’s used to deliver database server software. Rather than relying solely on internal engineers who create and maintain a piece of software (as in a traditional software company), MySQL partners with the millio
Simplify Ajax development with jQuery
(Jesse Skinner) jQuery is a JavaScript library that helps simplify your JavaScript and Asynchronous JavaScript + XML (Ajax) programming. Unlike similar JavaScript libraries, jQuery has a unique philosophy that allows you to express common complex code succinctly. Learn about the jQuery philosophy, d
XML Data Binding using Data Templates in XAML
(Doug Cook) Avalon provides a number of conveniences in terms of accessing and binding external data sources. This tutorial shows how you can bind and display XML data using a data template in XAML. This technique is also known as creating an XML data island.
Inserting a New Row in GridView
(Bipin Joshi) Many months back I wrote an article that explained a trick that allows you to add a new row to DataGrid. Just like DataGrid control the new GridView control doesn’t allow you to add new rows. Developers often use the following techniques to add new rows in such case: –They place a