Some new interresting points about trees and CTE in SQL Server : transforming a tree from auto reference to interval model (nested sets), calculating levels in interval model, creating a view of auto ref from an interval model, hierarchical numbering of items, and more. This article includes more examples based on his previous work.
2007-12-26
5,640 reads
Your AI is busy. But do you know what it's worth? Most companies can...
By Brian Kelley
I wear many hats in technology, and one of those is as a (cyber)security...
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
Wa:083849450961 Jl. Raden Saleh Raya No.17A No. 13, 15, RT.1/RW.2, Kenari, Kec. Senen, Kota...
Comments posted to this topic are about the item Azure SQL Hyperscale Unveiled
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers