(Hemant K Chitale) After having described the test data, here are the results of my first test : [on 10.2.0.3 on 32-bit Windows (8KB Block Size) ] Querying for My Private Library (fewer books) against the Public Library, with Complex View Merging enabled by default, I see that the tables MY_BO
Other News
MySQL Proxy recipes: tokenizing a query
(Giuseppe Maxia) Using regular expressions for query handling can become prohibitively complex after a while. If you need to manipulate parts of a query, either you are a regexp guru (I mean it, really, someone who speaks regular expressions more fluently than English) or you find some alternatives.
How to stop logging all successful backups in your SQL Server error logs
The SQL Server error log is a great place to find information about what is occurring on your database server. One helpful thing that each log offers is that it shows you all of the failures and/or errors that have occurred since the last start of SQL Server or since the last time you cycled the er
New SelectViews SQL Server Show Posted
New SelectViews SQL Server Show Posted Today we have specific tips for accidental DBAs to consider, upcoming events and the newsletter watch. Also, the 60-second SQL Server tip of the day, discussion watch and a lot more. [Watch the show here] SQLonCall Show Available Part II of Manager or Leader – what makes a great manager or leader, and which […]
Web Standard Tools and LARGE XML File Editing
(David Carver) Something that I learned today, that might help others that experience slow performance with editing large XML files. By large XML files, I mean files that are 500K or larger. By slow performance I mean: –Noticeable Typing delays when in source editor –Formatting of a document s
V6R1 SQL Query Engine Delivers on Its Promise
(Jarek Miszczyk ) With V6R1 DB2 for i5/OS, the transition of SQL workloads from Classic Query Engine (CQE) to the new SQL Query Engine (SQE) has been basically completed. So far, the SQE functionality has been delivered in six waves: 1. V5R2 GA 2. Mid-V5R2 (Check APAR II13486) 3. V5R3 GA
XML and Information MVC
(Michael C. Daconta) When designing the electronic mortgage standard for Fannie Mae, my goal was to design a flexible container that could travel with the content, protect the content, log its use and render it in multiple views. Of course, I was leveraging my programming experience and encoding the
Using the SQLXML data type
(Deepak Vohra) If you’re a Java 2 Enterprise Edition (J2EE) developer, you’ll want to preview the SQLXML technology. Check out procedures to create an XML document, store an XML document in a relational database, retrieve an XML document from a database, and navigate an XML document with the SQLXML
More on the Calculated Measure Cube
(Bud Endress) In Keith’s post, he describes how to create a calculated measure cube in Oracle 10g. In this post, I will describe how to create a calculated measure cube in Oracle 11g.
Back to the Basics: SQL *PLUS – Working with Files
In one of our previous blog post, we talked about basic SQL*Plus editing commands. In this blog post, we will see how can we deal with files in SQL*Plus.