Forum Replies Created

Viewing 15 posts - 61 through 75 (of 76 total)

  • RE: Overusing Identities

    Steve Jones - Editor (3/1/2010)


    I think Roger has put things well. I'm not saying you don't have a PK. I'm saying identities work well in that role.

    I agree that they...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Overusing Identities

    Steve Jones - Editor (3/1/2010)


    It's not a question of the origin of the number, but the fact that it's arbitrary-generated, and as such isn't necessarily a PK. In the paper...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Overusing Identities

    Steve Jones - Editor (3/1/2010)


    Shocked? What's a natural key? A PO number? Ever talked to someone about those? they're made up, usually by someone that keeps a spreadsheet, or even...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Overusing Identities

    Steve,

    I'm shocked! :w00t: The only purist rationalization for a surrogate PK is when no 'natural key' exists. Otherwise, it's just a throwback to mainframe days when files used data...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Overusing Identities

    Quite right. I, on the other hand, have a serious problem with using a composite key and not using identities. Case in point (battle I lost), a customer database that...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    cherie j sheriff (5/8/2009)


    There are so many methods of getting the education out there, college just isn't up to the challenge yet.

    Hmmm.... that's a pretty bold statement, and often what...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    Hi Cherie...

    cherie j sheriff (5/6/2009)


    I think it is a superficial thing to require a degree over experience. Had there been more to actually learn in the IT courses I...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    LOL... love the metaphor's 🙂

    Well, at the end of the day, I think it's about breadth. On coming back from a short stint in the USAF after high-school, I fell...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    sing4you (5/5/2009)


    My schooling doesn't really make much difference these days. Now, I'm wondering about whether getting MS certifications is worthwhile. Maybe we could start another thread?:-P

    Now that's an...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    Two of the best developers I know are both accomplished musicians.

    Edit: And neither has a degree at this time.

    It is an interesting correlation... I was initially a music major......

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    Jeremy Brown (5/5/2009)


    No offense to anyone with a CS degree but its probably going to be the case where most people who have a CS degree will say that its...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    Lynn Pettis (5/5/2009)


    As I mentioned above, I have a CS degree. Would I say what I learned in my CS program was directly helpful to what I do today...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: Do You Need an IT or CS Degree to be a Successful DBA?

    Well... I've done it without a degree, then finally went back and finished the BIT, then MIT, and now doing a DCS... my earlier opinion was that it wasn't that...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: One Hour Query that used to take 13 minutes

    You've probably already evaluated, but the use of a function in a join (UPPER in this case) negates the use of an index. Is your server set to be case...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

  • RE: I can not find SSIS to work with data

    Charlie,

    For a simple import, just right-click on the database (i.e.-'AdventureWorks'), select Tasks, Import Data...which will create a simple SSIS package if you so desire.

    Unlike SQL2000 Enterprise Mgr, SSIS is a...

    Dr. Les Cardwell, DCS-DSS
    Enterprise Data Architect
    Central Lincoln PUD

Viewing 15 posts - 61 through 75 (of 76 total)