(William E. Pearson, III) In this article, we will explore the use of a calculated member property to optimize query performance. Almost anyone who has worked with MSAS for any length of time has become aware of the NON EMPTY keyword in MDX. Empty cells are the reason that most of us are thankful fo
Other News
Exploring XML in SQL Server 2005
A new type of data has gained popularity in recent years, XML. XML has evolved from a simple data transfer format to a data storage format that includes its own schema-definition vocabulary, XSD, as well as query languages. Look at the XML data type, implementation of XML in tables, parameters, and
Storage Options for Oracle Real Application Clusters on Linux
Oracle Real Application Clusters (RAC) is an implementation of Oracle Database where more than one instance, located on different cluster nodes, access the same database. To enable simultaneous access, the database files must be located on shared storage. RAC also requires cluster management s
XML: Too much of a good thing?
(David Becker) Despite rumors to the contrary, the adult entertainment industry is not developing its own dialect of Extensible Markup Language dubbed XXXML. Aside from that, it’s hard to find an industry or interest that isn’t taking advantage of the fast-growing standard for Web services and da
ROW_NUMBER in SQL Server 2005
(Vinod Kumar) This is yet another cool feature in SQL Server Yukon .It has been in the SQL Server 2000 wish list for quite sometime. But I am excited to see this T-SQL enhancement make it into the SQL Server 2005 version for sure. What is this requirement? It is to generate a pseudo column as the qu
Oracle Tip: Create linguistic helper functions in SQL
(Scott Stephens) In a globalized environment, many simple tasks become more difficult because of the variety of grammar rules in different languages. You can generalize these tasks by breaking down a particular language into a set of grammar rules and exceptions to those rules (as well as a base voc
Zeroing in on UniData problems
(Wally Terhune) This article is written to assist with the problem determination process for someone administering or supporting IBM UniData databases. If you’re faced with a puzzling problem, here are some questions to ask in order to zero in on the problem, and actions to take to solve it.
Tip: Send multiple Web services requests from XForms
(Nicholas Chase) A typical HTML form only lets you submit to one URL at a time, which makes it difficult to retrieve information from multiple Web services. This tip shows you how to use XForms to solve that problem by using multiple submissions from a single form.
IDUG Abuzz With DB2 UDB v.8.2
(David Beulke) Attendees of the International DB2 Users Group (IDUG) North America conference held in May in Orlando, Fla., learned firsthand about the new application development and other features of the next release of DB2 Universal Database (UDB) for Linux, Unix, and Windows v.8.2. For those
Review: SQL Trace Manager
(Dale Elizabeth Corey) Ever wanted to create you own server-side SQL Server trace without having to run internal system procedures to define the server-side trace and having to specify numbers for events and data columns? Well, SQL Trace Manager (a SQL Enterprise Manager extension snap-in) is a conv