Forum Replies Created

Viewing 15 posts - 136 through 150 (of 208 total)

  • RE: DECLARE - 1

    Nice question for Wednesday. Thanks to everyone for the discussion.

  • RE: Days Difference Between 2 Dates

    Thanks for the question. Like to see datetime questions, they are helpful.

  • RE: APPLY - 2

    Great question on a Monday morning. Gets me back on track after Fridays question.

  • RE: Extended Events II

    Too hasty in answering.

  • RE: IDENTITY INSERT

    Toreador (9/27/2012)


    Is it me, or does the "explanation" for (1) just repeat the incorrect syntax used in the question?

    "IDENTITY_INSERT is used to set identity of a particular table. SET IDENTITY_INSERT...

  • RE: IDENTITY INSERT

    Thank you for the thought provoking (for me at least) question!

  • RE: Inner Join

    Thanks for an easy one for mid-week.

  • RE: Tracking Processes

    thadeushuck (9/21/2012)


    SP_WHO2 does not answer this ... it does not give you disk reads and writes. It gives their sums.

    Speaking of sums: The correct answers were 51% and those...

  • RE: Tracking Processes

    Good way to end the week! Thanks.

  • RE: Resource Governor

    Good question. Got it right only by researching the topic in MSDN. Thanks.

  • RE: GO Part 2

    Anurag-428305 (9/20/2012)


    What a Nonsense this question is?:hehe:

    I'm not sure why they made "GO" a configurable batch separator. I'm sure they had a reason that is beyond me but the...

  • RE: Tablesample

    vk-kirov (9/19/2012)


    (Bob Brown) (9/19/2012)


    Executed the select many times and never got a return. Oh well.

    Try the following script, I'm sure you'll get some (approx. 10-15) non-empty results:

    set...

  • RE: Tablesample

    Executed the select many times and never got a return. Oh well.

  • RE: Backups

    Thanks for the lesson. Learned something today!

  • RE: FILTER

    Nice and easy. Thanks!

Viewing 15 posts - 136 through 150 (of 208 total)