• Interests: Reading, movies, RPG (online and pen-and-paper)

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.

4.39 (59)

2010-12-10 (first published: )

32,527 reads

Blogs

Disabling Non-Clustered Indexes For Fun and Profit

By

One of the frequently quoted ETL best practices is to disable your non-clustered indexes...

Steps for a Successful Data Migration Session at Microsoft Ignite

By

I hope you’re all enjoying the latest rev of the Microsoft Ignite conference as...

Daily Coping 2 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Stored Procedure "Caching"

By LightVader

I'm having an issue with a database that I recently moved from SQL 2014...

SQLSaturday Foundation

By Steve Jones - SSC Editor

We are setting up this thread to welcome questions and comments about the latest...

update query problem

By DaveBriCam

Is there a way to take these two records and update the NULL values...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Adding N/A

See possible answers