Performance testing

External Article

The Performance of Traversing a SQL Hierarchy

  • Article

Dwain Camps shows that, depending on the size and characteristics of some hierarchical data, six different methods of traversal can each be the fastest at some point. He illustrates the danger in generalizing from just one set of test data, and that it's foolish to assume that just because SQL code looks neat, it will perform well.

2014-05-14

2,625 reads

Blogs

Scary Scalar Functions - Part Two: Performance

By

Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...

Goal Progress for June 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

Using Sessionize for Your User Group – Part 2

By

Now that your CFS has been setup it’s time to get the word out...

Read the latest Blogs

Forums

SQL Server 2019 HA

By celigo

Looking for a HA solution for SQL server for our branch offices. Current setup...

The July Fourth Anniversary

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The July Fourth Anniversary

Independence Day 2022

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Independence Day 2022

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers