use Perl

• Win file locking issue? (Score:2)

  by wickline (135)

  What sort of database? Is each table a file?
  
  If so...
  
  Is it possible that an earlier instance of the script crashed or was interupted while it had that file open? Can you read the file in a text editor, or does NT give you an error?
  
  Do you see different behavior depending on whether you read/copy the file on the local machine vs via filesharing?
  
  If you can't read the file from a share (and possibly locally), it may be that Win thinks the file is in use, possibly by a crashed/interupted previous instance of
  • Re:Win file locking issue? (Score:2)

    by Ovid (2709)

    The database we're using Microsoft SQL Server 2000. We stopped and restarted that server and, before anything else could touch the database, we successfully dropped the table. I've added it back and everything seems to work perfectly. Of course, we haven't done any load testing on the new table, so it might be a bug waiting for its opportunity to bite. It's extremely frustrating that we cannot find any logs anywhere which refer to this table or what the problem might be.

    I've double-checked the code wh
• SQL Server Admin tools (Score:1)

  by dws (341)

  The better DBA's I've worked with have been able to extract a healthy pile of clues from the admin tools provided with SQL Server (e.g., who has what locked).

  Since you're dealing with a single row in a single table, my number one cause of mystery grief on SQL Server--row locks getting escalated to page locks--probably isn't an issue.
  • Re:SQL Server Admin tools (Score:2)

    by Ovid (2709)

    dws wrote: The better DBA's I've worked with have been...

    Ovid replied: ha, ha, ha, grunt, snort, ha!

    We let our "DBA" go on the grounds that we couldn't afford him. That's true because while he might have been qualified to be an intern, he certainly wasn't qualified to be a senior DBA. He lied his @$$ off on his resume and when he was hired, no one was capable of evaluating his performance -- not surprising given that this company once hired a CTO who didn't know what FTP was. Then I returned to
    • noarmuyzed (Score:2)

      by wickline (135)

      "If you need to change it, you can just write a script to change all of the instances of it!"
      
      Hmmm...
      
      Actually, you could remove a layer of indirection by eliminating the username entirely. That way, if it changes, you don't have to update anything at all. You'll still be able to refer to users by other unique fields. The probability that any two users have the same hire date and birth date is probably sufficiently low ...and if not, you can just throw in more fields until you eliminate the duplication.
      
      The