PASS Summit 2010
Register Now

ROI Justification

Sponsors

Questions?

PASS Facebook PASS LinkedIn PASS Twitter


Premier Sponsor:
  

Platinum Sponsor:
  
Expanding Million Node Hierarchies Like Never Before
Hierarchies always seem to end up using RBAR (Row By Agonizing Row) methods to build them or use them. Even the new HierarchyID data type requires RBAR for sub-tree moves. Once built, many hierarchical structures require rather complex code to use and maintain the hierarchical data. The “Nested Set” method solves a lot of those problems but has its own maintenance problems to contend with. This “Developer-to-Developer” session quickly introduces the attendee to the 3 basic hierarchical structures, the advantages and disadvantages of each at the code level, and how to build each structure using typical/classic T-SQL methods. After a brief review of the advantages of the Nested Set method, a new very high performance method for creating Nested Sets from the Adjacency List model is demonstrated and culminates in a surprise ending; a new set based method for using the Adjacency List model to quickly resolve the 4 most frequently asked questions of a million node hierarchical structure.

Speaker Bio: With more than 21,000 posts, Jeff Moden is the leading poster on SQLServerCentral.com where he coined the term “RBAR” which is pronounced “ree-bar” and is a “Modenism” for “Row By Agonizing Row”. Jeff is mostly self trained in what he calls the “Black Arts” of T-SQL and SQL Server and is known worldwide for his informative articles, his high performance T-SQL coding methods, and his friendly mentoring. His dedication to and skill in helping people write better and faster T-SQL have earned him the Microsoft SQL Server MVP award for the last three years.

Session Goal #1: Teach a new very high performance method for creating the Nest Set hierarchy from the easy to maintain Adjacency List Model to be used at both the batch and GUI levels.

Session Goal #2: Teach a new very high performance method to accumulate COUNTs and SUM aggregates at the node & downline levels for all nodes in a million row hierarchy or just one. May eliminate need for Nested Sets.

Session Goal #3: Ancillary learning includes further "Black Arts" methods and a continuation of training in the paradigm shift necessary to achieving set based thinking.

(Please note: cannont click through to speaker details from speaker's name below)
Speaker:
Brook Source
Sr. Application DBA
With more than 22,000 posts, Jeff Moden is the leading poster on SQLServerCentral.com where he coined the term “RBAR” which is pronounced “ree-bar” and is a “Modenism” for “Row By Agonizing Row”. Jeff is mostly self trained in what he calls the “Black Arts” of T-SQL and SQL Server and is known worldwide for his informative articles, his high performance T-SQL coding methods, and his friendly mentoring. His dedication to helping people write better and faster T-SQL have earned him the Microsoft SQL Server MVP award for the last three years.
Register Now for PASS Summit 2010!


 
  Top Reasons to Attend
PASS Summit 2010
  • Over 160 technical sessions from the world's top SQL Server and BI experts
  • 2 full days of deep-dive Pre- and Post-Conference Seminars
  • Networking with thousands of SQL Server MVPs, experts, Microsoft employees, and peers
  • Face-to-face support with the Microsoft CSS and SQLCAT teams
  • Ask the Experts Lounge
  • And much more!
 
 

Gold Sponsor

     
     
Copyright 2010 by PASS | Terms of Use | Privacy Statement