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

The pros and cons of self-service BI: What every industry leader should know

By

The post The pros and cons of self-service BI: What every industry leader should...

Off to the PASS Data Community Summit 2024

By

As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...

Implement a RAG Solution Using Azure SQL Database

By

AI and ChatGPT are all the rage these days.  Seems like around every corner...

Read the latest Blogs

Forums

South Kerala Tour Packages

By indiaboundtour

South Kerala tour packages offer an immersive experience into the heart of Kerala's natural...

Black Corgi Chihuahua Mix – Unique Look and Personality

By dogshabit

Ever seen a corgi chihuahua mix black, or "Chigi"? This rare color variation makes...

How to change font size in Query window

By MurraySobol

I am running SQL Server 20.2. When I copy a query into the query...

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers