By Andrew Novick – Indexes have been a method to improve the performance of SQL queries since the creation of relational databases in the 1970’s. Up until recently, indexes were always created on a single table and they’ve undergone only limited changes over the years. That was true until a few year
Author: SSWUG Research
Letters, April 2003
From SQL Magazine – Readers give advice about configuring the Client Access ODBC driver for DTS data transfer between the AS/400 and SQL Server and ask about concurrent security role limits in Analysis Services.
App servers key to integration, Oracle exec says
By Paul Krill – Application servers utilizing Web services and Java will enable integration of multiple information systems for e-business, according to an Oracle official.
An XML Hero Reconsiders?
by Kendall Grant Clark – In a recent weblog entry, one which has been picked up by Slashdot, Bray asks whether XML has become too hard for programmers. Faced with writing code “to process arbitrary incoming XML”, Bray confesses that the experience was “irritating, time-consuming, and error-prone” —
Defining Web Services
The label “web services” is incredibly generic. Like any promising and loosely defined technology trend, the concepts it describes will be subject to a great deal of speculation and bandwagoneering in the months to come. With the aim of providing a reference benchmark—and of separating posturing fro
Generate Web Output in Multiple Formats and Languages with StrutsCX
by Bernhard Woehrlin – StrutsCX overcomes the limitations of the Struts Framework by enabling you to utilize XML, XSLT, and XPath technologies instead of its standard JavaServer Pages.
Oracle’s ‘Mr. Linux’
When Larry Ellison asked him to design a Linux-based Internet appliance, Wim Coekaerts reported back with a plan a couple of weeks later–and won himself a new task.
Using Metadata
The simplest definition I can find for metadata is simply "data about data". SQL Server has a number of different functions that you can use to query your database structure. This articles discusses the Information Schema views and functions such as ObjectProperty and ColumnProperty.
Manipulate Schema Information
by Dino Esposito – ADO.NET doesn’t provide classes for schema manipulation, although Microsoft plans to build an all-encompassing .NET object model for the data source’s Data Definition Language (DDL). In this column, I’ll examine the three options you have today to manipulate a table’s schema progr
Managing Result Set Paging
You often need to display a result set one page at a time while maintaining ease-of-navigation between those pages, particularly when you’re working with a Web site. Although it is possible to page through result sets using the ADO Recordset object, that solution is not scalable.To solve the