Taken from real life experience, author Alexander Kuznetsov shows you some simple tips to make sure the optimizer makes good decisions for your queries.
Other News
Oracle Draws a Mid-Market Blueprint
by David Myron – Oracle executives recently met with the research director to share their plans for the CRM mid-market. Dubbed Oracle E-Business Suite Special Edition, the Oracle mid-market solution comes with preconfigured and integrated Oracle applications including financials, order management, p
Microsoft Plugs Holes in BizTalk Server
By Erin Joyce – Newly discovered vulnerabilities in the company’s EAI software could lead to attackers embedding malicious SQL statement into a query string or could even result in attackers executing code of their choice.
Corel software gets Smart on XML
By Paul Festa – The struggling Canadian software company released Smart Graphics Studio. First announced in December, the software is part of Corel’s push to boost earnings with tools for use with XML, or Extensible Markup Language, a World Wide Web Consortium (W3C) recommendation for creating indus
Cleanup your schema for SOAP
More and more projects are using XML schemas to define the structure of their data. As your repository of schemas grows, you need tools to manipulate and manage your schemas. The Eclipse XSD Schema Infoset Model has powerful querying and editing capabilities. In this article, Shane Curcuru will show
RSS on the Client
by John E. Simpson – I am trying to figure out this RSS thing. If I want to “subscribe” to someone’s XML feed, what do I do? I hit the XML button and get an entire page of code. What do I do with that? I’ll start by spelling out something which you probably (at some level) already know: RSS
Administrative Products for DB2 for OS/390 – Extending the Power of DB2
The purpose of this paper is to describe the Version 7.1 release of the BMC Software administrative Products for DB2 for OS/390. We will highlight the features that are supported in Version 7 of the IBM DATABASE2™ Universal Database Server for OS/390 and z/OS, and explain how the BMC Software Databa
IBM takes integration from Garlic to DB2 II
By Ellen O’Brien – As the researcher credited with driving IBM Corp.’s federated database technology, engineer Laura Haas has led data management projects from the Garlic project to DiscoveryLink and, most recently, to the DB2 Information Integrator (DB2 II). She spoke with SearchDatabase.com about
Using XML Bulk Load to Load ADO-Generated XML Data
Rich Rollman of SQL Server Magazine answers a reader’s query about using XML Bulk Load to upload ADO-generated XML data that includes date fields, prescribing a mapping schema that translates ADO’s ISO8601 format for dates.
Managing Char Values in SQL Server 2000, 7.0, and 6.x
Do SQL Server 2000, 7.0, and 6.x manage char values differently? If so, can I compensate for this difference by using the appropriate database compatibility level?