An old and new way to query Hierarchical data

This script uses an old mathematical way of doing hierarchical queries. The most common way of showing hierarchical data in SQL Server is by creating a stored procedure that calls itself. This is not a recent problem, in fact this programming technique has been around since the first programming languages. By using stacks, you can […]

1 (1)

2007-05-02 (first published: )

540 reads

Blogs

Container Limits and SQL Server

By

Limits in Containers Docker gives you the ability to control a container’s access to...

Inspector V2.6 now available

By

As always the code can be found here in our github repoWe updated our...

Data Mesh: Centralized ownership vs decentralized ownership

By

I have done a ton of research lately on Data Mesh (see the excellent...

Read the latest Blogs

Forums

New Index Maintenance Methods Recommended by Microsoft

By Jeff Moden

With reference to the following MS article... https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15 That article was where the old...

Define All The Steps Up Front

By Grant Fritchey

Comments posted to this topic are about the item Define All The Steps Up...

Having users access .dtsx (package file) saved on LAN

By redoak

Hello All, I created a package file (.dtsx) via SSDT. I took the folder...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers