databasejournal.com databasejournal.com

Identifying and Eliminating the Dreaded Cartesian Product

Cartesian Products usually don't provide useful information and often result in mistakes that can hurt your database developer career. Learn to spot Cartesian Joins and banish them from your SELECT queries forever. I’ll never forget one of my first SQL assignments as a young junior developer in the Federal Government. I had to produce a report for one of our clients to help them generate some statistics for the...

databasejournal.com databasejournal.com

Set Functions: The StripCalculatedMembers() Function - Page 2

Practice Preparation: Access SQL Server Management Studio To reinforce our understanding of the basics we have covered, we will use the StripCalculatedMembers() function within queries that illustrate its operation. The intention, of course, is to demonstrate the use of StripCalculatedMembers() in a straightforward, memorable manner. We will turn to the SQL Server Management Studio as a platform from which to construct and execute...

databasejournal.com databasejournal.com

MS SQL Series

The Database Journal Series index is a listing of articles, which contain more than three installments. It is categorized by database, author name, series title and article title. MS SQL Oracle DB2 MS Access MySQL Michael Aubert Learn SQL Server 2000 Administration in 15 Minutes a Week Series SQL Server 2000 Administration in 15 Minutes a Week: Table Basics (Part 1)SQL Server 2000 Administration in 15 Minutes a Week: Restoring...

databasejournal.com databasejournal.com

MDX Essentials: Enhancing CROSSJOIN() with Calculated Members - Page 2

Introduction In The CROSSJOIN() Function: Breaking Bottlenecks, we introduced our efforts to enhance CROSSJOIN() by discussing how the function can contribute to a degradation in processing for queries that rely upon it in scenarios where we encounter medium- to large-sized data sets. We acknowledged the utility of the CROSSJOIN() function in scenarios where we wish to generate a cross-product of members in two different sets,...

databasejournal.com databasejournal.com

MDX Essentials: Enhancing CROSSJOIN() with Calculated Members

About the Series ... This article is a member of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs. For more information about the series in general, as well as the software and systems requirements for getting the most out of the...