(Stephen Toub) My client and I are working on a client-side application that entails making HttpWebRequests to a server application in order to submit data. We’re trying to limit the number of concurrent connections made by the client so we can limit the load placed on the server. Initially we t
Other News
Part 3: Outer Joins
(Mike Chapple) Take a moment and review the database tables located on the first page of this article. Notice that we have a driver — Jack Ryan — who is located in a city where there are no vehicles. Our vehicle managers would like this information to be included in their query results to en
UNIX to Linux Migration using VERITAS Portable Data Containers on IBM xSeries and BladeCenter
(Rufus Credle, Douglas Fallstrom, Nilesh Hiremath and Hideyuki Kamemoto) This Redbook will discuss a new tool that allows customers to more seamlessly migrate their applications from UNIX to Linux. This tool, called Portable Data Containers (PDCs), is part of VERITAS’ Storage Foundations 4.0 offer
Asked and Answered (DB2 – About the DB2 Governor Utility)
(Robert Catterall) We are in the process of implementing the concepts in your column "Do You MQ" for our batch processing, but our Web transactions aren’t ready for this approach yet. As an interim solution, we’ve planned to use the DB2 Governor utility, which supposedly would let us assign higher p
DBFilesWithLowFreeSpace :: (Script Library)
Category: Backup Software Tags: Backup software, Restore softw Compatibility: SQL Server 2000 only Description:
Leveraging on XML feature of Microsoft Office Word 2003
(Sarvesh Damle) Word 2003 came up with a new feature of saving the conventional word document (.doc) files in the XML format. You can retrieve the information inside the Word 2003 documents by using the XPath queries and some logic. This feature is particularly useful as the .doc file format that is
GIS and Spatial Extensions with MySQL
MySQL 4.1 introduces spatial functionality in MySQL. This article describes some of the uses of spatial extensions in a relational database, how it can be implemented in a relational database, what features are present in MySQL and some simple examples.
Analytic Functions in Oracle Warehouse Builder
Analytic Functions are an important feature of the Oracle database that allows the users to enhance SQL’s analytical processing capabilities. These functions enable the user to calculate rankings and percentiles, moving window calculations, lag/lead analysis, top-bottom analysis, linear regression a
SQL Server 2005 Recursive Functions
(Dan Sullivan) SQL Server 2005 has added a new format for queries called a Common Table Expression or CTE. CTE’s are part of the SQL:1999 Specification and represent further compliance with this specification by SQL Server. This article will cover using one of the many capabilities of CTE’s, imp
Digging Up the Dirt on Indexes
(Kalen Delaney) In SQL Server, indexes are one of the most important data structures—they are the only means by which SQL Server can process huge tables in a reasonable amount of time. In my November column, “Get Into Index Structures” (InstantDoc ID 43939), I described the structure and organizatio