Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 1,932 total)

  • RE: The Phantom DBA

    Yes, I think companies, especially small ones, are foregoing hiring DBA's. I work for a university, but the department where I work, has a small 4 person IT staff....

  • RE: Who Wants to Lead the Community?

    Yesterday at our staff meeting we learned that there will be no professional travel or training in the next fiscal year, for the third year in a row. I...

  • RE: It's a Zoo

    I am extremely envious. I went to my first TechEd a few years ago, after having been to VS Live events for several years, and found TechEd to be...

  • RE: Help to understand CROSS JOIN

    Thank you, ColdCoffee, for using a simpler example. That makes the concept of CROSS JOIN with a WHERE clause easier to understand.

  • RE: Help to understand CROSS JOIN

    Ken McKelvey (6/3/2010)


    Maybe:

    SELECT S.ClientNumber

    ,S.CaseNumber

    ,T.ReferralSourceType

    ,T.ReferralSourceDesc

    FROM RequestForServices S

    JOIN SourceOfReferral R

    ON S.ReferralSource = R.ReferralSource

    JOIN ReferralSourceTypes T

    ON S.ReferralSourceType = T.ReferralSourceType

    To me, that's a more elegant solution.

  • RE: Free Advice or Free Consulting

    I'm sure that, as some point on these forums, I've asked a question and indicated that I needed an answer in a hurry. I think that, when I read...

  • RE: Getting Colorful

    "Wet paint". I've never heard that phrase to describe code that is still in process, but not yet ready to be used. I like it!

  • RE: No More NULL

    Rich-403221 (4/8/2010)


    OK. I can't resist joining this one.

    When I was in high school I worked in a shoe store (no Al Bundy jokes, please). We would send the newbies to...

  • RE: No More NULL

    john.arnott (4/6/2010)


    Rod at work (4/5/2010)


    A friend of mine thinks that if you cross the International Date Line, say going from west to east, that you can actually travel back in...

  • RE: No More NULL

    A friend of mine thinks that if you cross the International Date Line, say going from west to east, that you can actually travel back in time. I kid...

  • RE: No More NULL

    Man, you had me going there, Steve! I am so gullible.

  • RE: How should conditions be stored in a table?

    Gail,

    I appreciate this feedback, and especially from you. This is the sort of thing that I've got to hear, so that I can see how better to architect solutions...

  • RE: Is it normal to not specify any relationships between tables?

    Jeffrey Williams-493691 (3/3/2010)


    Well, I wouldn't say it was normal either - but I have seen it quite often. Mostly where the company wants to be able to deliver their...

  • RE: Is it normal to not specify any relationships between tables?

    Lowell (3/3/2010)


    definitely not normal. foreign key relationships are a best practice.

    I've encountered this before, and it seems the companies think that their schema would reveal their business processes ro something,...

  • RE: Transaction log for master isn't happening

    Excellent information, Lynn, thank you! Well then I can see that there won't be a lot of activity on our Master database, as we don't do most of those...

Viewing 15 posts - 1,756 through 1,770 (of 1,932 total)