Forum Replies Created

Viewing 15 posts - 106 through 120 (of 552 total)

  • RE: Does the database exist?

    Alex Gay (11/4/2014)


    DIR is an alias. The command behind it is Get-ChildItem.

    (to my knowledge..) DIR is a DOS command which also can be used in PS without aliasing. Once...

  • RE: Trace Flag

    Ed Wagner (10/30/2014)


    A very good question - thanks. I learned something new and think I'm going to use it.

    +1 (except the "using" part)

  • RE: Template parameters

    Thank you for the post, Steve, interesting one.

    I used this before and i have created my own templates for some set of specific work which i use them.

  • RE: Random unions

    Michael Riemer (10/23/2014)


    ,,Was looking for the catch...!

    If i had 1 rupee everytime i did or said that, i would have brought a 1tb PHD....:-D

  • RE: Random unions

    Thank you for the post, Steve, good one.

  • RE: DONEPROC

    stephen.long.1 (10/22/2014)


    ...Eliminating the options that included 3 or 5 left (1,2) and (1,2,4), so I went with (1,2,4) and got it right!...

    I also did the same thing..(not in depth... but...

  • RE: DONEPROC

    ksatpute123 (10/22/2014)


    Raghavendra Mudugal (10/22/2014)


    Thank you for the post, really eye opening.. And really had no idea what this was.

    I read it and without any research, i selected the choice and...

  • RE: DONEPROC

    Thank you for the post, really eye opening.. And really had no idea what this was.

    I read it and without any research, i selected the choice and got it wrong....

  • RE: Terminating with THROW

    Thank you, Sean, for the awesome post, very interesting one.

    (out of three choices, I was knowing 2, and for the returned resultset is null or empty there I was having...

  • RE: Plan Guides

    Thank you for the post, Steve, very interesting one.

    (..in previous month I was reading this article http://blogs.msdn.com/b/igorpag/archive/2014/01/15/sql-server-2014-inside-hekaton-natively-compiled-stored-procedures.aspx and came across "sql_handle" and "plan_handle".. then started exploring in the local_help and...

  • RE: SETSPN

    Thank you for the post, Steve, nice one. 🙂

  • RE: Preventing recompile

    Dana Medley (10/14/2014)


    Ed Wagner (10/14/2014)


    Another question where I got to learn something. Thanks. I haven't gotten to play with 2014 yet, but still enjoy learning about it. ...

  • RE: ROW_NUMBER

    Thank you for the post, Steve, simple one. (for me the choice was obvious, but my uncontrolled mind was still looking for the trick/catch.) 🙂

  • RE: THROW formatting

    Xavon (10/10/2014)


    I'm not sure if this was a double trap or I simply over thought it. I was going to say no, I remembered reading it could not, and...

  • RE: THROW formatting

    Stewart "Arturius" Campbell (10/10/2014)


    ...

    Thank you, Stewart.

    So he meant usage of placeholders directly in the THROW's message parameter. (because the question asked was "can we use...?" and obviously we can, but...

Viewing 15 posts - 106 through 120 (of 552 total)