Other News

Community

Mapping and Markup, Part 1

(John E. Simpson) One frustration you can still hear vented when someone first comes to XML takes the form, “Yeah, but what about the real world?” or “Show me some real-world examples!” What the speaker often means by this is that he or she simply needs to see XML in action, in some form–some a

Community

High-performance SQL

(Serge Rielau) This article introduces advanced SQL features which are being used in IBM DB2 Universal Database (UDB) for Linux, UNIX, and Windows (DB2 UDB for LUW) TPC-C benchmarks. Find out how to use these features in everyday customer environments.

Community

Monitoring Performance, Part 3

(Roger E. Sanders) In two previous columns in this series, I explained the two kinds of tools that make up the Database System Monitor: a snapshot monitor and event monitors. The snapshot monitor captures information about the current state of an instance and/or database at a given point, while even

Community

SQL Server 2000 Indexing

(Steve Jones) One of the keys to SQL Server performance is ensuring that you have the proper indexes on a table so that any queries written against this table can run efficiently. There are more articles written about designing indexes, choosing columns, etc for optimizing performance, so I will