(Susan Lawson) Prior to V8, decision support queries have been difficult and expensive. They typically operate over a large amount of data which may have to scan or process terabytes of data and possibly perform multiple joins and complex aggregations. With these types of queries traditional optimiz
Other News
Dynamic Search Conditions in T-SQL
(Erland Sommarskog) A very common requirement in an information system is to have a function (or several functions) where the users may search the data by selecting freely among many possible search criterias. This is a tough challenge, because not only must you produce the desired output, but you m
Global Variables and SQL statements in DTS
(Darren Green) For those fortunate enough to have SQL 2000, using global variables with an Execute SQL Task, or as part of the source statement in the DataPump task is now a standard feature. For those still using SQL Server 7.0 this tedious process, but here are some examples of how it can be done.
DoS Flaw in SOAP DTD Parameter
(Ryan Naraine) Technology heavyweights IBM and Microsoft have released fixes for a potentially serious vulnerability in various Web Services products that could be exploited to trigger denial-of-service attacks. In separate alerts, the companies said the vulnerability was caused by an error in th
ADO.NET and System.Xml Version 2.0
(Alex Homer, Dave Sussman, and Mark Fussell) This chapter provides an overview of the .NET Framework 2.0 (Technology Preview release), summarizes the new data management features, looks at the reasons for the growing importance of XML, and summarizes how the techniques for binding to data in ASP.NET
XML Tutorial — Free
In our XML tutorial you will learn what XML is and the difference between XML and HTML. You will also learn how to start using XML in your applications.
Getting a Boost from DB2
(Michael L. Gonzales and Jon Rubin) Built-in business intelligence functions let DB2 handle data preparation so partner apps can do what they do best: Serve up actionable insight. The latest examples involve real time, spatial, OLAP, and other advanced forms of analysis. By now, the IT community
IBM DB2 Universal Database Problem Determination Tutorial Series
This series of nine tutorials is designed to assist anyone supporting or developing in a DB2 database environment, to quickly identify and resolve problems or errors encountered. It will familiarize you with the DB2 problem determination facilities and tools available and when it is most appropriate
.NET and Oracle Java Stored Procedures—Bridging the Gap with XML
(Jeff Hilts) Using Oracle as your database in the .NET environment is relatively simple, except when returning JDBC ResultSets from Java stored procedures. The Microsoft and Oracle .NET data provider drivers allow for easy access to data from SQL queries and PL/SQL stored procedures. There is not, h
Analyze a Table and All Underlying Indexes
(Bobby Akbari) This script analyzes a given table and all underlying indexes within the executing schema.