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...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: Random unions

    Thank you for the post, Steve, good one.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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....

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • RE: SETSPN

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

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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. ...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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.) 🙂

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • 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...

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

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