Many of us have read or heard that using SQL Server output parameters is more efficient than simply returning a recordset. But, how much more efficient? And was the gain in ADO, SQL Server, or both? Although Craig Utley is based in Kentucky, you might think he’s from Missouri, the "show me" state.

Pervasive.SQL for DataFlex is a combination of the DataFlex Connectivity Kit for Pervasive.SQL from Data Access Corporation and Pervasive.SQL from Pervasive Software, Inc. Pervasive.SQL's "Best of Both Worlds" server technology simultaneously provides the high-performance tra

Among the least understood and most often misused SQL Server settings are those for configuring the server and database. You might have experienced confusion about these settings when a vendor's tech support representative asked you to adjust a setting one way after another representative asked

XML has taken the industry by storm – not only revolutionizing the way that web pages are generated, but also the way that data is exchanged between disparate systems. This session will explain the new XML support added to SQL Server 2000. In particular, you will learn about XML recordsets, URL-base

Microsoft SQL Server 2000 Windows® CE Edition (SQL Server CE) is the compact database for rapidly developing applications that extend enterprise data management capabilities to devices. SQL Server CE has the familiar feel of SQL Server, with tools, application programming interfaces (APIs), and SQL

The new Alpha 21264 runs at 833MHz and will be included in Compaq's (NYSE: CPQ) AlphaServer ES 40 line of servers, machines that sell for tens of thousands of dollars and up. Some customers, including biotechnology companies, already had access to early versions of the server.

According to a newly published, record-setting TPC-C result, Microsoft SQL Server™ 2000 is the fastest database in the world, recording the highest performance ever for SQL Server 2000. With a performance rating of 505,302 tpmC and price/tpmC of $19.80, the 24-node Compaq ProLiant system running SQL

The database server is the basic building block for business applications. Today, organizations demand database solutions that meet exacting performance requirements, are cost effective, provide high availability option and are scalable to meet future needs.

Today's organizations typically manage hundreds of internal and external distributed and heterogeneous data sources—as well as gigabytes (GB) or terabytes of data—in a data warehouse or data mart. "T3," the project codename for terabyte cube, is a cooperative effort between EMC, Knosys,

Daniel Anderson writes…As an ASP developer, I am constantly looking for new source code examples that will help make my job easier. Of course, using someone else's examples is far simpler than enduring the pain of the development process. One of the examples I have seen on various