(Denis Gobo) You have all seen websites where you can pick a bunch of categories by selection a bunch of check boxes. usually what you do is store those in a lookup table and then you create another table where you store all the categories for each customer.
Author: SSWUG Research
Oracle: Standby Automatic File Management
(Paul Moen) So you have followed the recipes to create a standby database, setup the database to switch logs automatically, and now, as with any good database, the space required to support the application grows and grows and grows.
Database Bulls of Info-Storage on Linux – Oracle and IBM DB2
The most important point in any database software is its compliance to ACID properties. These are set of properties that guarantees that a transaction ( all the steps right from start to end e.g sign in to sign out) executed in orderly and reliable manner. Say for an example if you have to transfer
Rational Data Architect and DB2 9: Storage Diagrams
(Paul Zikopoulos) In my latest articles, I’ve been writing about the IBM Rational Data Architect (Rational DA) integrated development environment (IDE), a tool that’s specifically designed for those involved in data server design and schema evolution. So far, I’ve shown you how to add a database con
CAM: A Swiss Army knife for XML structures
(Daniel Rubio) Web services’ bread and butter consists primarily of exchanging XML structures between applications in order to fulfill interoperability requirements. Prior to such exchanges taking place, most XML data undergoes a series of steps that include validation and transformation, many of wh
Temporary Tables vs. Table Variables and Their Effect on SQL Server Performance
(Dmitry Tsuranoff) There are three major theoretical differences among temporary tables and table-variables.
Using SharePoint Solutions to Deliver Server-Side Solutions
(Robert Bogue) If you’ve ever worked on more than the most trivial installation program, you realize that developing installers isn’t for the faint of heart. After spending days or weeks learning about the MSI file format, how to assemble tables, and how to add dialogs, you’re left with a collection
XML Schema Facets
(Priya Lakshminarayanan) I have received a number of requests over a period of time asking how to get all the facets defined on simple types or complex types with simple content in an XML Schema. I recently wrote a code sample for the same and I thought i will post it for wider consumption. The code
Partition pruning tip: Use comparisons of column, not of partitioning function value
(Sergey Petrunia) A customer issue has drawn my attention to this this pecularity: if partitioning is done by the value of some function, then partition pruning module will make use of comparisons of the partitioning column(s), but not of comparisons of the value of the partitioning function.
Oracle Session Tracing Part II
(James F. Koopmann) Read on and learn how to set the module and action names.