On April 24, Microsoft announced the first single-system TPC-C benchmark result to surpass the 600,000 tpmC mark. SQL Server 2000 Enterprise Edition (64-bit) on a Hewlett-Packard (HP) Superdome server running Windows Server 2003 Datacenter Edition returned a tpmC score of 658,277 at a price/performa
Other News
Working with SQL Server Date/Time Variables: Part Two – Displaying Dates and Times in Different Formats
Greg Larsen continues his series on date/time data by exploring how to use different SQL Server functions to display dates and times in different formats. Learn how to display a date any way you need it by using the CONVERT function along with one or more additional SQL Server functions.
IOUG Live! 2003: The Week in Review
David C. Kreines summarizes the week, focusing on what makes IOUG Live! such a unique event. Read about what he calls “an incredible opportunity to learn, share experiences, and interact with your fellow Oracle professionals.”
Issues with Implementing UNICODE for DB2 in UNIX ODBC
Think you can get UNICODE support from IBM’s DB2 ODBC driver on UNIX? Nope. In order to provide UNICODE support for a database, the driver must both support UNICODE and be compatible with the database. Learn more here.
Oracle, Unisys Team on $1 Billion Transportation Security Deal
Oracle Corp. and Unisys Corp. have been chosen by a newly formed Homeland Security agency to construct a single online portal for consumers and airline personnel to report security incidents relating to airlines and other transportation systems.
A Comparison of SQL Server 2000 with DB2 v8.1
Alexander Chigrik compares SQL Server 2000 with DB2 Universal Database version 8.1 regarding price, performance, platforms supported, SQL dialects, and products limits.
IBM touts its technology durability
Steve Mills, IBM’s senior vice-president and group executive in the IBM software group, touted the strength and popularity of IBM product lines during a keynote speech at the IBM developerWorksLive conference. He said, for example, that the WebSphere applications platform has 50,000 customers, that
Simple Oracle objects
by Eli Leiba – Version 8i introduced simple objects in Oracle and so made the Oracle database a true object-oriented environment. This article presents short scripts that demonstrate how to build, use and maintain Oracle simple objects.
Index Fragmentation and Its Resolution
(Randy Dyess) While there is no doubt of the benefits of adding indexes to your tables, and for the most part you have to do little work to keep the indexes maintained, some maintenance is required as indexes can become fragmented during data modifications. This fragmentation can become a source of
HOWTO: Retrieve XML Data by Using a SQL XML Query in an ASP Client
When you run an ADODB command stream and specify SQL SELECT with the FOR XML AUTO clause, an XML document stream is fetched from SQL Server, sent to the response object, and piped to the client.