SQLServerCentral.com Articles tagged Hierarchies

Hierarchies in SQL, Part II, the Sequel

Tue, 21 Aug 2012 06:00:00 UT

In a followup to his first article on Hierarchies, Gus Gwynn takes a look at the performance of a few different methods of querying a hierarchy. Learn how the HierarchyID stacks up.

Selecting from hierarchies like Managers and Employees

Thu, 03 May 2012 06:00:00 UT

Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.

Naturally Increasing Data Value with Hierarchical Structures

Wed, 23 Mar 2011 06:00:00 UT

Hierarchical structures have an inherent ability for significant data value increases beyond the data collected. This will be shown to exist in hierarchical structures and even more powerfully in their natural hierarchical processing capabilities. These will demonstrate flexible and efficient ways to increase data value automatically and will be discussed in this article. SQL will be used to perform a wide range of hierarchical processing operations that easily demonstrate these increasing data value capabilities.

Hierarchies in SQL

Fri, 10 Dec 2010 07:00:00 UT

One very common structure that needs to be handled in T-SQL is the hierarchy. One of our prominent members of the community discusses how you can handle hierarchies in SQL Server.

Implementing User-Defined Hierarchies in SQL Server Analysis Services

Fri, 05 Mar 2010 07:00:00 UT

To be able to drill into multidimensional cube data at several levels, you must implement all of the hierarchies on the database dimensions. Then you'll create the attribute relationships necessary to optimize performance. Analysis Services hierarchies offer plenty of possibilities for displaying the data that your business requires. Rob Sheldon continues his series on SQL Server Analysis Services 2008.

Performing Hierarchical Restructuring Using ANSI SQL

Thu, 30 Apr 2009 06:00:00 UT

Discover the flexibility and power of using ANSI SQL to reshape and transform hierarchical structures.

Intrinsic Member Properties: The HIERARCHY_UNIQUE_NAME Property

Fri, 13 Feb 2009 07:00:00 UT

This month's installment of "MDX Essentials" examines the HIERARCHY_UNIQUE_NAME intrinsic member property. Join SSAS Architect Bill Pearson in an introduction of this intrinsic member property, which Bill complements with hands-on exercises and sample uses.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Hierarchies in SQL

Fri, 10 Dec 2010 07:00:00 UT

One very common structure that needs to be handled in T-SQL is the hierarchy. One of our prominent members of the community discusses how you can handle hierarchies in SQL Server.

Creating Hierarchical Data Structure Mashups

Wed, 28 Jan 2009 07:00:00 UT

You can use SQL to connect or "mash-up" hierarchical structures, joining them at or below the root to create larger queryable hierarchical structures.

Two Useful Hierarchy Functions

Wed, 21 May 2008 06:00:00 UT

Two useful functions for dealing with hierarchical data.