(Muthusamy Anantha Kumar) When a new version is released or when existing software is upgraded there is always a learning curve and getting used to new ways of doing things. This article demonstrates how to use SQL Server 2005’s catalog views in comparison with using system tables in SQL Server 2000
Other News
Running MySQL queries on multiple servers
(Mark Alexander Bain) You may know how to use SQL to extract data from a table in a MySQL database, and how to run a query that combines data from more than one table. But what about multiple databases? Or even multiple databases on multiple servers?
ASP.NET Outlook-Like Time Field
(Steven Berkovitz) The IT side of my company is almost completely service based, mostly involving on-site technicians. We have an internal e-Business portal that we use to track services rendered to the clients. The complaint I received most often from our technicians was how annoying it was to ente
Managing and Deploying SQL Server Integration Services
(Michael Otey and Denielle Otey) In today’s businesses, decision-making processes and daily operations often depend heavily on data that is stored in a variety of data storage systems, formats, and locations. In order to turn this data into useful business information, the data typically needs to be
Structural Join Order Selection for XML Query Optimization
(Yuqing Wu, Jignesh M. Patel and H. V. Jagadish) Structural join operations are central to evaluating queries against XML data, and are typically responsible for consuming a lion’s share of the query processing time. Thus, structural join order selection is at the heart of query optimization in an
The SOAP Protocol (Sample Chapter)
(Peter Brittenham, Glen Daniels, Doug Davis, Paul Fremantle, Steve Graham, Dieter Koenig, Yuichi Nakamura, Simeon Simeonov and Claudia Zentner) The Web services Architecture group at the W3C has defined a Web service as follows (italics added): A Web service is a software system designed to suppo
AJAX: Asynchronous Java + XML?
(Coach K. Wei) Gmail, GoogleSuggest, and GoogleMap opened the eyes for millions of netizens to a “new” Web: a smarter, more responsive, and more interactive Web that does not employ a foolhardy “click, wait, and refresh” approach. For the first time, the vast majority realize the Web can be much bet
Creating Index-Organized Tables
Let us learn about Creating Index-Organized Tables by Creating an Index-Organized Table, further by Creating Index-Organized Tables that Contain Object Types and also you will learn how to View Information about Tables.
Oracle Sequences
(Robert Vollman) Proactively maintaining your database … something some people do only AFTER a problem of some kind.
IBM’s Info On Demand Gig Gears Up to Ease IT Pain
Here you have a healthy appetite. Since the Informix deal in 2001, IBM has acquired a whopping 16 companies in its Information On Demand initiative.