Forum Replies Created

Viewing 15 posts - 16 through 30 (of 1,220 total)

  • RE: One to Many relations

    MMartin1 (10/4/2016)


    Are you sure this will never be a many to many relationship, even if it is not one now? A person can appear in more than one photo but...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Backup database only if changes happen

    Very true, Scott. But the original poster was talking about hundreds of tables, not hundreds of databases. There could be a terminology mismatch here between what he said...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Backup database only if changes happen

    I'd go with Grant's original advice: just do the backup. If there's no activity in the database since the last log backup, the amount written to your backup volume...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: One to Many relations

    I would use an individual photo table for each parent with a 1:M relationship. Using a link table adds a layer of complexity for your application developers that isn't...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Questioning the Interviewer

    I am definitely adding "How large is your IT department" for future interviews. I've always had a file of questions to ask at interviews, and the worst jobs that...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Coming Attacks

    The source code of the botnet that compromised IoT devices that knocked Brian Krebs off the internet is now available online, so expect to see more of this in the...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Restoring a database (without effecting original) - to test the retore process...

    You say "without affecting the original". Make sure you're selecting "Copy-only backup" so you don't mess up your backup log chain, unless this is going to be part of...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The altered view

    The oldest DB book that I have at hand is The Practical SQL Handbook, published in '89 by Sybase/Addison-Wesley, and it shows the column names being defined as part of...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Good Stories

    Reading David Poole's story above made me realize that my first real computer job 30 years ago that I was doing ETL. We had a canned time charge billing...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Interview Questions

    I can do it in a single line of code, so I could put it in a single function or statement vs a table, but seven REVERSE() seems a bit...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: More and More Data Growth

    kiwood (6/9/2016)


    Heading over I had noted while reading that the idea of filtering data before storage reaches into some hobbies. In model rocketry for instance, there are inexpensive altimeters that...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: The altered view

    A subtle one, and I saw the answer right away. I love it when that happens!

    And I haven't had my morning bottle of Starbucks yet, but I did sleep...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Accept Failure

    There are tons of places where you can download the PDF of the earlier printing, it has been revised and reprinted several times. This particular one apparently can be...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Potential presentation idea: SQL Server for absolute beginners

    Yeesh, yeah, not easy to do. I started a training class for a bunch of COBOL/mainframe developers who didn't know the first thing about database or SQL Server. ...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

  • RE: Meeting Cheating

    In some ways I am an extremely punctual person. While doing film programs (back when it was 16mm film) for science fiction conventions, I committed the blasphemy of all...

    -----
    [font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]

Viewing 15 posts - 16 through 30 (of 1,220 total)