Recent content by Snugglebear

  1. S

    POLL: Largest SQL Table

    In a perfect world... where companies/users don't suddenly decide they need all sorts of crap tacked on after design and implementation has been finished for many months, most of the talent has gone home, and they've filled the damn thing. Heck, even the multi-million dollar package I've been...
  2. S

    Executing 1,000's of SQL Updates

    I would figure the same thing. Last I checked those Progress databases had a nifty GUI you could feed these things into, plus a command-line utility to run scripts. Anyway, by a batch query I simply mean distilling down all those queries into a single one that affects multiple tuples and/or...
  3. S

    Raptor Hds?

    Seagate.
  4. S

    FAT32 Data Recovery

    There's really not much you can do once a good chunk of the data has been overwritten a few times. Your best bet would be to try another software package or two and then call it quits unless you want to send it out to a recovery specialist. There are a few more things they can do, but it will...
  5. S

    RAID with a WD Raptor 74GB 10k RPM

    The FAQ and its contents are your friend: http://www.lostcircuits.com/hdd/hdd7/
  6. S

    hard drive "clicks" and pc restarts......

    The click is the drive resetting itself. Could be a variety of things causing this, can't say much more without a better description of the noise.
  7. S

    hdd question ?

    Aside from making sure there aren't any massive stashes of temp files or crud in your recycle bin, see how large your pagefile is. Windows has a nasty habit of not adding it into used space calculations in certain circumstances.
  8. S

    Executing 1,000's of SQL Updates

    Creating a stored procedure is an easy way to speed things up since the statements are then stored in a precompiled fashion in the DBMS. All your client will do is call them and provide input data, then wait for returns. This can be problematic with so many statements if they're all doing...
  9. S

    ST373307LW SCSI pricing

    Refurbed equipment will carry a big "REFURBISHED" sticker on it, and resellers need to tell you that the equipment isn't new. OEM drives do not necessarily come with a one year warranty. The term "OEM" only means the drive doesn't come with a box and accessories that come with retail drives...
  10. S

    16x SATA RAID card

    As near-line backup or an archive server it wouldn't be too bad, but you wouldn't catch me throwing a database or high-load SMB/NFS server on it. Of course if the budget is really tight, maybe, but nothing mission critical.
  11. S

    16x SATA RAID card

    And 64MB of cache to support it all.
  12. S

    ST373307LW SCSI pricing

    Provided you're seeing 80-pin hits mixed with 68-pin hits, the $160 versions are probably sold without warranty, or with a significantly reduced warranty. This is fairly common practice in the world of SCSI and you need to be alert to it. Some years ago I was sold a drive with a 1 year warranty...
  13. S

    POLL: Largest SQL Table

    This is a database in development for some time. There are only a handful of tuples because of that; it really sucks having to migrate data safely when schemas change. Anyway, in the next month or two, this table will be broken up into a couple other tables, in the never-ending quest to please...
  14. S

    IT School

    The building boom is going to pop. Too few non-residential projects from business & government, too much competition for building materials from other nations, increasing interest rates, gas prices keeping commuters closer to jobs, and longtime residents getting sick of watching this half of...
  15. S

    New system, no budget...

    With 2k or 2k3 server you can enable PAE and use more than 4GB. Applications are limited to less than this, but on a whole it works quite well.
Back
Top