Forum Replies Created

Viewing 15 posts - 586 through 600 (of 824 total)

  • RE: How to copy database structure to another server?

    There are several ways to accomplish this.  DTS has a "Copy Objects" task which can either include data or not.  My preferred method tends to be scripting out the database...

  • RE: Best Practices for Database Design

    Well, there you have it again, even ISO gets it right, although not for any of the correct reasons and not without hoplessly falling into the trap of the "First great blunder." ...

  • RE: Best Practices for Database Design

    OK, I lied.  I'm not quite done. 

    I was finally able to get my hands on part of the ISO 11179 specification.  As expected, it was a tangle of muddled...

  • RE: Best Practices for Database Design

    One more time and then I'm done...at least in this forum.

    No, I was not talking about a database name, and frankly at the logical level there is no such concept...

  • RE: Windows 2003 and SP_change_users_login

    Don't use autofix.  I always specify both the user and login and I've never had problems.  The Windows version should have nothing to do with this.

    If you create a login...

  • RE: Remote backups?

    First off I would either demand that your hosting service provide regular DATABASE backups or I would find another service.  File level backups DO NOT WORK for databases. 

    As DBO...

  • RE: Restoring DB

    If there are NO backups at all, you're out of luck. 

    If you have an old full backup you can restore it giving it a different name then you can...

  • RE: Best Practices for Database Design

    Yes, and everybody is entitled to my opinion!

  • RE: Best Practices for Database Design

    "So you change your name as you move from room to room."

    "A Rose by any other name..."

  • RE: Best Practices for Database Design

    Yes, I find it usable. 

    On the flip-side, standards that are too rigid are often impossible to implement.  If the process of data modeling could be reduced to a set...

  • RE: Best Practices for Database Design

    In the relatively rare case that there is this kind of conflict I will normally rename the fK column.  This does happen all the time if you use surrogate keys,...

  • RE: Best Practices for Database Design

    I normally do not include the table name on any of the column names even if the column is just "Name" or "Description".  Why?  Because I don't like typing more...

  • RE: Best Practices for Database Design

    "you're getting caught up thinking about the container for the set, rather than the set itself."

    Guilty as charged!  Since it is the container (relation) that imparts meaning to the set...

  • RE: Best Practices for Database Design

    To give us some kind of idea of what the variable means and how it should be used, but not (except in the loosest sense of the word) to convey...

  • RE: Best Practices for Database Design

    To further amplify my point, your concern about confusion is, I think, somewhat overstated.  People are used to dealing with singular names for containers of multiple objects:

    Train Station rather than...

Viewing 15 posts - 586 through 600 (of 824 total)