Author: SSWUG Research

Community

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

Community

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

Community

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

Community

Thanks XMLType

by Marius Nicoras – Last year I wrote “Another way to have your own aggregate function” ( Tip for Week of October 28, 2001 ) on the string data type as an alternative to a solution using object types ( Tip for Week of May 20, 2001 ). Now, in Oracle 9i, using XMLType I can build a DML statement […]