Mathematics

SQLServerCentral Article

Navigating Trees With CTE

  • Article

Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]

(5)

You rated this post out of 5. Change rating

2021-04-19

8,167 reads

Blogs

Project Management – Part 1

By

The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related...

Install SQL Server 2025 Container on macOS Using OrbStack

By

My old Dell XPS that I used for personal stuff started to degrade; well,...

Flyway Tips: Immediate Code Review for Developers

By

At the Redgate Summits this year, we’ve highlighted a few things in the Flyway...

Read the latest Blogs

Forums

ALAMAT BCA KCU TANJUNG PINANG TLP/WA 08218200203

By R4nt4u

Hub Cs:08218200203 Jl. Sunaryo, Kemboja, Kec. Tanjungpinang Bar., Kota Tanjung Pinang, Kepulauan Riau 29112

ALAMAT KANTOR BCA KCU BATAM TLP/WA 08218200203

By layanan_Bca88

Hub Cs:08218200203 Jl. Raja Ali H. No.18, Sei Jodoh, Kec. Batu Ampar, Kota Batam,...

ALAMAT BCA KCU PEKANBARU TLP/WA 08218200203

By m4rt1n4

Hub Cs:08218200203 Jl. Jend. Sudirman No.448, Tanah Datar, Pekanbaru Kota, Kota Pekanbaru, Riau 28115

Visit the forum

Question of the Day

DBCC CHECKDB Limits II

I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?

See possible answers