One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. Recently started looking at this issue where I worked and stored procedures gathered from other clients and I noticed that there is an issue with SQL developers not taking recompile
Other News
Configure Memory for More Than 2 GB in SQL Server
This article describes how to configure SQL Server to use more than 2 GB of physical memory. Microsoft SQL Server 7.0 and Microsoft SQL Server 2000 dynamically acquire and free memory as needed. When you run multiple instances of SQL Server on a computer, each instance dynamically acquires an
New MS e-commerce tool to boost .Net
By Joe Wilcox – Microsoft will launch Commerce Server 2002, new software for building e-commerce Web sites and one of the first products supporting the company’s .Net strategy.Commerce Server 2002 will allow Web site operators to manage catalogs of products and services and to tailor the con
Managing Oracle9i
By Liz Cully with Tom Haunert – Is Oracle9i Database more powerful than Oracle8i? Absolutely. It’s also easier to use. “We got a massive amount of input from DBAs on the most tedious, time-consuming tasks they have to do,” says Valerie Kane, a group manager in Oracle’s Server Division, “and we used
Oracle ending Express OLAP engine
Paul Krill – WHEN ORACLE SHIPS the upcoming upgrade to its database, designated Oracle9i Release 2, in May, it will mark the end of the Oracle Express OLAP (online analytical processing) product line and the dawn of an offering more tightly integrated with the main database.
Microsoft, HP, Others Back Common XML Rights Language
By Paula Rooney – One major XML consortium said that Microsoft, ContentGuard, Hewlett-Packard, VeriSign and Reuters will collaborate to advance a common XML rights language.As first reported by CRN last Friday, XML interoperability committee OASIS said those members will try to advance the E
CECID Launches Test Site of OASIS ebXML V2 Registry Reference Implementation
Center for E-Commerce Infrastructure Development (CECID), Department of Computer Science Information Systems, The University of Hong Kong (HKU) is pleased to announce today the immediate availability of an OASIS ebXML V2 Registry. This implementation of the OASIS ebXML V2 Registry/Repository (ebXMLR
What's New in XSLT 2.0
by Evan Lenz – In my previous article, I went through a brief overview of some of the features that XPath 2.0 offers over and above XPath 1.0. We saw that XPath 2.0 represents a significant increase in functionality for XSLT users. In this article, we'll take a look at some of the new features s
SQL Server 2000 Table Hints
by Randy Dyess – This article will describe the use of the table-level locking hints and general table hints that are available to Transact-SQL developers and SQL Server database administrators, and attempt to provide scenarios on when you should use a particular hint. You should note that SQL Serve
SQLCache
SQLCache is an OLE DB data provider with an in-built and fully tunable data cache. This means SQLCache can be used with traditional database queries made within web pages without the need for any code changes or the learning of a new Application Programming Interface (API). When SQLCache is used to