This document describes the new indexed views capability of SQL Server 2000 Enterprise Edition. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.
Other News
GNOME XSLT library released
Daniel Veillard, the maintainer of libxslt, the GNOME XSLT library, has announced its first stable release, version 1.0.0.
Managing data with XML: Forward to the past?
By Fabian Pascal – The inventors of XML, Jon Bosak and Tim Gray, described in a Scientific American article the problem that their invention was intended to solve. What the authors are talking about here is nothing but database management. And, in fact, telling "what things are, how they
Binary Data to Go: Using XML-RPC to Serve Up Charts on the Fly
by Joe Johnston – XML-RPC is a protocol that allows programs of different languages on different machines to easily talk to each other. By sending a well-defined XML document over unadorned HTTP, a client program can make a remote procedure call to a server. The server processes the request and wrap
Understanding and Calculating Dates
By Joe Lax – SQL Server provides many sophisticated functions to calculate dates. But knowing how to use them can often be a challenge. Suppose you want to calculate when a package is due to arrive based on the shipping date and the type of shipping chosen. Because many shipment types don't incl
Introduction to SQL
A free course of study at Free-Ed.Net. This is a complete course of study for SQL (sequential query language). Typical completion time for the course is about 12 weeks.
ASP SQL Server Query Analyzer
This SQL Server Query Analyzer is intended to be the front page of next generation of Buildapp, which I hope to develop if time permits. As with the original Buildapp, everything is as automatic as possible, with as much useful information for developing your queries only a click or two away.
Xslt Quickly
by Bob Ducharme – Geared toward new users of XSLT, this guide is a basic tutorial of the concepts and documentation manipulation techniques necessary for the most common XSLT tasks. Featuring an XSLT cookbook, which provides task-oriented recipes for tackling issues such as converting elements to at
Apache has mixed feelings about XML-RPC
Jason van Zyl proposed to accept the Helma XML-RPC implementation, already used by Turbine, into the Jakarta Apache project, provoking a strong pushback from xml-soap committer Sam Ruby.
EDI, ebXML groups agree to cooperate
By Michael Meehan – Though the two electronic trading formats have been cast as mortal foes, the standards bodies behind them have agreed to create a set of shared business processes that could ultimately create standards harmony in the world of e-commerce.