Archive for the tag 'sql'

Jan 13 2008

Optimize Hierarchy Queries with a Transitive Closure Table

Published under Technology

Last year I posted about the use of a Joe Celko-style nested set hierarchy representation, for fast hierarchy queries. Here I will describe another approach which is simpler to query, but more wasteful of space. I did not invent this transitive closure approach, I learned of it from several directions: Celko wrote about it as […]

6 responses so far

May 17 2006

SQL Server Log Shipping – Testing the impact of large operations

Published under Technology

Background In a project we have here at Oasis Digital, our customer relies on the log shipping feature of Microsoft SQL Server 2000 to keep some secondary databases, reporting databases, up to date in almost-real-time: every few minutes a transaction log backup runs, then at a slightly longer interval, every 5-15 minutes, a restore of […]

Comments Off on SQL Server Log Shipping – Testing the impact of large operations

Mar 13 2006

SQL Server Log Shipping Fragility

Published under Technology

In a customer production system, we use MS SQL Server 2000 “log shipping” extensively to offload reporting DB load to secondary servers… a common use of the technology. This generally works very well, most of the time. We’ve noticed, though, that it can be somewhat fragile, in that it is easy to inadventantly run a […]

Comments Off on SQL Server Log Shipping Fragility