(Knut Stolze) Implement functions and stored procedures that allow you to use the IBM DB2 Universal Database (DB2 UDB) administrative APIs using SQL. This article illustrates two stored procedures, one that calls db2Runstats to collect statistics on a given table, and another that wraps the db2L
Other News
FIX: 17883 errors may be written to the SQL Server error log when you run a query that generates many floating point exception errors in SQL Server 2000
In Microsoft SQL Server 2000, when you run a query that generates many floating point exception errors, you may experience slow performance and query timeouts when you run other queries. This problem typically occurs when more than 1,000 floating point exceptions are generated.
MySQL Database Design (Sample Chapter)
(Larry Ullman) The first step in creating and using a database is to establish its structure. The techniques you will learn in this sample chapter will help to ensure the viability, performance, and reliability of your databases.
VB 6 Collection, VBScript Dictionary, and VB .NET Hashtable
Although most of the functions of VB .NET’s Hashtable object can be done using the VB 6 Collection object, and even more can be done using the Scripting library’s Dictionary object, VB .NET has vastly expanded and upgraded the way they work. In this mini-tutorial, we’ll go over the idea of collectio
Improving Application Performance by Implementing Paginated Lists
(Chuck Cooper) Describes how Ameripay has implemented the “How To: Page Records in .NET Applications” section of the Microsoft patterns & practices book Improving .NET Application Performance and Scalability.
Web-Database (Oracle) Integration
Database systems enable you to create, store, organize, and manipulate data. By integrating databases and web sites you can open up new possibilities for data access and dynamic web content.
Red Hat Linux Step-by-Step Installation (Sample Chapter)
(Mark G. Sobell) This chapter steps through the process of installing either Red Hat Enterprise Linux or Fedora Core. Frequently, the installation is quite simple, especially if you have done a good job of planning. Sometimes you may run into a problem or have a special circumstance; this chapter gi
IBM Looks To ‘Viper’ Database to Combat Oracle, Microsoft
(Barbara Darrow) IBM says it’s upcoming Viper release of DB2 will bridge the structured/unstructured divide and allow both types of data to be queried via SQL or Xquery statements.
Reading XML Files with the XmlTextReader Class, Part 2
(Tom Archer) My previous article presented the XmlTextReader class and various code snippets that illustrated how to use it for sequentially reading XML documents or files, determining node types, and parsing for specific nodes and values. This week, I’ll cover a few more issues regarding the XmlTex
How to Optimize the Use of the ‘OR’ Clause When Used with Parameters
(Preethiviraj Kulasingham) Have you ever tried to use parameter validation within a SQL Server stored procedure using an OR clause? At times, it can cause performance problems. I found this recently when I was asked to fine tune a stored procedure. The procedure had two parameters, and either of the