Forum Replies Created

Viewing 15 posts - 1,891 through 1,905 (of 2,838 total)

  • RE: Question about "coalesce"

    ichiyo85 (4/14/2011)


    Jason: The code works, and it returns the same result as the coalesce.

    I think my boss is more concerned with the output. Therefore I can probably set those...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: The Job Posting - Do I really have to be the SQL God?

    I received a job req not long ago that had 2 lines toward the end that set off all kinds of alarms for me. It was in a section marked...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: The Job Posting - Do I really have to be the SQL God?

    Revenant (4/14/2011)


    Stefan Krzywicki (4/14/2011)


    . . .

    I've found that almost all contracts are advertised as 3-6 month regardless of how long they're actually expected to take.

    . . .

    Most companies are allowed...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: The Job Posting - Do I really have to be the SQL God?

    Adam Machanic (4/14/2011)


    Stefan Krzywicki (4/14/2011)


    Was that you they were talking about? LOL. I had a feeling if I mentioned it here I might find out who it was.

    No, I was...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: The Job Posting - Do I really have to be the SQL God?

    Adam Machanic (4/14/2011)


    Interesting read.

    I do have to question the idea that the 3-6 month BI project is a junior role and a good way for someone to "get their...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    Jeff Moden (4/14/2011)


    Brandie Tarvin (4/14/2011)


    It's a singular versus plural reference. "There's" = "there is" (singular) while "there are" is a plural reference.

    And I'd have committed the worse writting sin of...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: The Job Posting - Do I really have to be the SQL God?

    Roy Ernest (4/14/2011)


    Stefan Krzywicki (4/14/2011)


    A few years ago I was interviewing for a SQL Server position and the initial phone interviews went fine. I was able to answer all their...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: The Job Posting - Do I really have to be the SQL God?

    A few years ago I was interviewing for a SQL Server position and the initial phone interviews went fine. I was able to answer all their questions to their satisfaction...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/13/2011)


    Update on contractor that bailed.

    His reason for bailing - his integrity was brought into question. And I did bring it into question - with plenty of good reason.

    Sounds...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Question about "coalesce"

    ichiyo85 (4/13/2011)


    Stefan Krzywicki: Thank you for your suggestions. I have 2 IDs because I need them both to connect to other tables. Also they are both important in our business.

    Also,...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Seperation of Duties - How many DBA's do you have?

    devereauxj (4/13/2011)


    Looking to get a feel of what other DBAs are doing. Need some feedback to confirm or deny my expectations.

    My company is looking to out source the DBA...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Question about "coalesce"

    ichiyo85 (4/11/2011)


    Hi experts,

    I have 2 tables where I want to join by ID1, IF NOT THEN join by ID2.

    Would this code work?

    select * from table1

    left join table2

    on coalesce(table1.ID1,table1.ID2) = coalesce(table2.ID1,table2.ID2)

    I...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    I'm using IE8, upper right corner, doesn't resize unless I hover.

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Failed attempt at using shortcutting to produce efficient query

    Are you sure using a cursor would be faster than letting some functions that don't return rows do some work? If most of the functions return rows most of the...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/13/2011)


    Jack Corbett (4/13/2011)


    CirquedeSQLeil (4/13/2011)


    GilaMonster (4/13/2011)


    CirquedeSQLeil (4/13/2011)


    Leave the contract early without notice and prior to completing the stated work.

    What does his contract require? Solo or contracting house?

    Solo contract and it...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

Viewing 15 posts - 1,891 through 1,905 (of 2,838 total)