Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Hierarchies Rss

   Items 1 to 11 of 11   
 

Analysis Services Multidimensional

By Steven Neumersky 2014/02/04 | Category: hierarchies
Rating: (not yet rated) |  Discuss |   Briefcase | 1,247 reads

Hierarchies in SQL, Part II, the Sequel

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.  Read more...
By GSquared 2012/08/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,103 reads

Selecting from hierarchies like Managers and Employees

Chuck Hoffman shows a technique using sets for selecting records from hierarchies such as Manager / Employee structures.  Read more...
By Chuck Hoffman 2012/05/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 8,531 reads

Naturally Increasing Data Value with Hierarchical Structures

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.  Read more...
By Additional Articles 2011/03/23 | Source: Other | Category: data modeling
Rating:  Rate this |   Briefcase | 2,907 reads

Hierarchies in SQL

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.  Read more...
By GSquared 2010/12/10 (first published: 2009/01/28) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 30,587 reads

Implementing User-Defined Hierarchies in SQL Server Analysis Services

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.  Read more...
By Additional Articles 2010/03/05 | Source: SimpleTalk | Category: analysis services (ssas)
Rating:  Rate this |   Briefcase | 2,114 reads

Performing Hierarchical Restructuring Using ANSI SQL

Discover the flexibility and power of using ANSI SQL to reshape and transform hierarchical structures.   Read more...
By Additional Articles 2009/04/30 | Source: DevX | Category: hierarchies
Rating: (not yet rated)  Rate this |   Briefcase | 1,662 reads

Intrinsic Member Properties: The HIERARCHY_UNIQUE_NAME Property

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.  Read more...
By Additional Articles 2009/02/13 | Source: Database Journal | Category: mdx
Rating: (not yet rated)  Rate this |   Briefcase | 1,057 reads

Hierarchies in SQL

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.  Read more...
By GSquared 2010/12/10 (first published: 2009/01/28) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 30,587 reads

Creating Hierarchical Data Structure Mashups

You can use SQL to connect or "mash-up" hierarchical structures, joining them at or below the root to create larger queryable hierarchical structures.   Read more...
By Additional Articles 2009/01/28 | Source: DevX | Category: xml
Rating:  Rate this |   Briefcase | 1,812 reads

Two Useful Hierarchy Functions

Two useful functions for dealing with hierarchical data.  Read more...
By John Cawley III 2008/05/21 | Source: SQLServerCentral.com | Category: hierarchies
Rating: |  Discuss |   Briefcase | 14,256 reads
   Items 1 to 11 of 11   
 
Tags
t-sql (4)    
analysis services (ssas) (3)    
common table expression (cte) (1)    
data modeling (1)    
hierarchyid (1)    
mdx (1)    
sql server 2008 (1)    
xml (1)