Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • by djberg96 (2603) on 2003.01.26 9:35 (#16393) Journal
    There was a story on slashdot about this. Five of thirteen root nameservers disabled - ouch. I've never heard a good thing about MS SQL Server (and not just because MS makes it). Why do folks use it? I'm genuinely curious.
    • It's actually not a bad database, so long as you understand its locking strategies. It's based off an old branch of Sybase, so it's got good heritage. We use it in an extremely large installation - over 25 replicated SQL servers globally. It all seems to work fairly well, though I try not to get involved.

      However where MS SQL Server doesn't work is when you get deadlocks. Its locking strategy is significantly poorer than PostgreSQL or Oracle's (i.e. it doesn't do MVCC - reading commited data while other tra
      • There's also the problem with row locks myseriously escalating into page locks (they may have changed this behavior in SQL Server 2000, but it was definitely a problem in 6.5 and 7).