Forum Replies Created

Viewing 15 posts - 481 through 495 (of 583 total)

  • RE: Select top row and second top row from DIM table

    Cadavre (9/26/2011)[hr

    Good morning and welcome to SSC!

    It seems that your DDL script seems to have become detached from your post, or perhaps you were unaware of the benefits of...

  • RE: Use of BETWEEN and DATETIME

    I was originally going to post something saying that the question, which I got right, was needlessly tricky. However, on further reflection, I thought it was perfectly fair. How many...

  • RE: Power of implicit conversion

    Excellent! Just the right amount of grey cell stimulation for an early Monday morning. Thanks.

    Great example of taking two simple things you "know" (precedence and conversion) and synthesizing them into...

  • RE: Big Gaps

    Two things missing:

    1. Willingness to LISTEN to customer requirements - not give them what you think they need

    2. Willingness to spend a little extra time to come up with a...

  • RE: Union results

    Nice example of the question not being more complicated than necessary to demonstrate the point. Thanks for the question.

  • RE: Table Access Order

    Not only a great question, but a superb explanation. Thanks.

  • RE: SubQuery

    Thanks. Got it right - but almost went for the first instance of the name change. Good thing I kept "parsing". Thanks for the lesson!

  • RE: Unary & Aliases

    Nice question Carlo! My first thought was, "What am I supposed to learn from this question?" Then I dug in a little deeper. Got it right, but not as quickly...

  • RE: Database Collation

    Tom.Thomson (9/12/2011)


    Thomas Abraham (9/12/2011)


    "Always" is what did it for me too - what about not having permission to read from that table?

    Can't happen - you always have permission to read...

  • RE: Database Collation

    cengland0 (9/12/2011)


    I got it right but for the wrong reason. The reason specified was for case sensitivity but I thought of other reasons it wouldn't run. The question...

  • RE: Database Collation

    paul s-306273 (9/12/2011)


    Thomas Abraham (9/12/2011)


    BTW, can anyone else see a question for October 14, 2011 in their list of "previous" questions?

    Yes - I can see it too!

    If he's going to...

  • RE: Database Collation

    Thanks for the question.

    BTW, can anyone else see a question for October 14, 2011 in their list of "previous" questions?

  • RE: Order By Clause

    Thanks for a good question. Missed the subquery ORDER BY clause error as I never use ORDER BY in a subquery - expect all results before my final output will...

  • RE: Odd men out

    Feel a bit deflated at having my streak of correct answers ended by a question like this. Luminaries?

  • RE: Resource Governor

    Almost missed it, using "Features Supported by the Editions of SQL Server 2008" as a reference, since it only mentions Enterprise. Good thing I paused to reflect this morning. Thanks...

Viewing 15 posts - 481 through 495 (of 583 total)