A number of hierarchies and networks are most conveniently modelled as binary trees. So what is the best way of representing them in SQL? Joe Celko discards the Nested Set solution in favour of surprisingly efficient solution based on the Binary Heap
When is backup not enough? Steve Jones talks about a few things that can cause you issues and a backup can't help you recover from.
How to set all tempdb datafiles to same size to meet best practice.
A new event is coming to the East Coast next year that will give people a chance to experience a SQL Server conference at a much lower cost.
Shared Datasets are one of the features introduced in SQL Server 2008 R2. This article demonstrates how to implement Shared Datasets as well their use-case scenarios.
What does ANSI_PADDING mean and how does it affect my SQL Server database?
Trying to keep up with all the learning going on in the SQL Community can be frustrating. Or is it? Give us your answer in this week's Friday poll.
The capability of extending the limits of combining multiple node hierarchical structures has not been fully explored. Michael M. David presents a solution to advanced structure combining that is simple to use, generic and freely extends the way hierarchical structures can be semantically combined to produce advanced new hierarchical data structure mashups that dynamically increase the value of the data.
A guest editorial today from Justin H-Davies examines the change to management from the perspective of someone going through the transition. How do you deal with those former co-workers?
Spatial data support in SSIS is weak in comparison to SQL Server. This article demonstrates how to use the CLR to achieve the SQL Server levels of spatial data support in SSIS.
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Telp/WA.0821°3111°179 Komplek Cemara Asri, Jl. Boulevard Timur No.08B, Medan Estate, Kec. Percut Sei Tuan,...
BCA KCP Teluk Mas Telpon/wa.085373737699.Komplek Ruko, Jl. Soka 1 Jl. Terusan Bandengan Utara No....
Jl. Aiptu K.S. Tubun No.46, Pandau Hulu I, Kec. Medan Kota, Kota Medan, Sumatera...
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers