(Carol Palmer and Jim Stenoish) This Technical Note is the first in a series about improving SQL*Loader performance. It provides steps for tuning the SQL*Loader date cache to improve performance during direct path loads. But before we talk about tuning the date cache, let’s briefly overview SQL*Load
Other News
Everything you always wanted to know about SAX (and XmlReader)
(Richard Mansfield) When you need to process XML documents, you must first decide whether to use DOM (Document Object Model) or SAX (Simple API for XML), the two main XML APIs in use today. You can use either (or both at the same time) to process XML documents, but DOM loads the document into me
Bits in SQL Server
(Muthusamy Anantha Kumar) The objective of this article is to analyze and understand how SQL Server uses Binary digits for categorizing and how to query such categorized binary numbers to produce detailed results.
Mini Disaster – AC Failure
(Andy Warren) I bet you’ve all had what I call a mini disaster, something that entirely disrupts production for a minute to a day or so. Sometimes it’s user error, a bad patch, user error, hardware failure, or user error! These mini’s are times that will often test your character. As much as I hate
FETCH FIRST ROW ONLY in an update query?
(Craig Mullins) Can I use FETCH FIRST ROW ONLY in a select statement of update query? Example: (SELECT SCH.SCHEDULEID FROM ASHOK.INTERVIEWERSCHEDULEMASTER SCH, ASHOK.RESUMEDETAILS SSS WHERE SCH.INTERVIEWLOCATION =SSS.CANDIDATELOCATION AND SSS.SCHEDULEID IS NULL AND SSS.REQUIREMENTID IS NO
Comparison of Oracle Drivers
(Haidong Ji) Because Analysis Service is bundled with SQL Server for free, many companies built data warehouses and OLAP cubes on top of SQL Server. DBAs usually use DTS to get data from Oracle and dump it into SQL Server for DSS and OLAP analysis. When you are ready to do data transformation from
Convert Alphabetical Phone Numbers to Numeric Phone Numbers
(Galina Petrenko) We sometimes have to store phone numbers in a system in alphabetical format. We can convert and format alphabetical phone numbers using the TRANSLATE function.
Automating B2B Integration with XML
(Suresh Damodaran and Neelakantan Kartha) This article will explain how XML is used to enable businesses to work together via the Internet, in the context of the RosettaNet B2B framework. Looking at proven frameworks such as RosettaNet is important as it provides insight into what works today, and w
The SQL Optimizers
(Mark Gurry) Whenever you execute a SQL statement, a component of the database known as the optimizer must decide how best to access the data operated on by that statement. Oracle supports two optimizers: the rule-base optimizer (which was the original), and the cost-based optimizer.
Practical database design, Part 2
(Philipp K. Janert) What are the best choices when designing the schema for a relational database? What is the rationale in deciding in favor of one and against some other alternative? Given the amount of vendor-specific recommendations, it is all too easy to overlook basic relational database funda