Forum Replies Created

Viewing 15 posts - 46 through 60 (of 66 total)

  • RE: sysadmins

    Excellent question for a Friday.

    Thanks

  • RE: Wildcards

    Good question. Man, I have not used the "_" in a while so I almost got it wrong. Thankfully my brain kicked in.:-D

    Thanks for the question.

  • RE: SSIS Variable Casting

    All:

    I thought I had put in the answer "the format indicated in the question is a determination of my regional \ language settings (en-us \ short datetime: M\d\yyyy h:mm:ss tt)..."....

  • RE: Data Compression

    L' Eomot Inversé (11/13/2013)


    Jason and Koen have pointed out the flaws in this question.

    I wonder how many people will end up answering (correctly) "developer edition" and finding out...

  • RE: Automatic Page Repair

    Good question. Definitely a DBA question. +1

  • RE: Using Max()

    Nice question and good "back to basics."

    Thanks

  • RE: UNION

    L' Eomot Inversé (11/5/2013)


    Revenant (11/5/2013)


    I am really surprised that only one third of the replies has been correct.

    Thanks for the question, Steve!

    Well, maybe we should say 52% are correct -...

  • RE: UNION

    twin.devil (11/4/2013)


    That produces the following plan featuring a Merge Join (my answer!) running in Union mode:

    Its a boobby trap ... 🙂

    twin.devil, you stated it perfectly, it is a trap question....

  • RE: Orphaned users

    Nice question. Missed it though...selected 3 out of the 4 correct. Next time, I guess I'll read it a bit more "slowly." 😀

  • RE: DATE Conversion and Format

    L' Eomot Inversé (10/30/2013)


    Not a really bad query, but not really good either. It's fallen into the trap of assuming that the order in which rows in the heap...

  • RE: DATE Conversion and Format

    All:

    I thought I would give a nice "fun" one. I believe in the basics and you would be very surprised as to how many "experienced" DBAs (Logical and\or Physical)...

  • RE: Nested Transactions

    Nice question geared to the fundamentals. I almost got it wrong (reading it over too quickly). Thanks. 🙂

  • RE: Slowly Changing Dimension Transformations

    KWymore (10/22/2013)


    L' Eomot Inversé (10/22/2013)


    Remarkably easy for a 2 point question.

    Agreed, maybe it was marked for 2 points because we don't get a lot of DW-specific questions? Had it been...

  • RE: Slowly Changing Dimension Transformations

    All:

    I wanted to make this more of a definition for learning purposes. I am natively a BI person and I LOVE BI and related "true" statistical analysis (especially since...

  • RE: Slowly Changing Dimension Transformations

    Koen:

    While the SCD transformation does not natively adhere to level 3, I have used other transformations to accommodate SCD level 3.

    Thanks

Viewing 15 posts - 46 through 60 (of 66 total)