Forum Replies Created

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

  • RE: Preventing recompile

    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. Perhaps someday,...

    October 14, 2014 at 7:31 am

    #1752211

  • RE: ROW_NUMBER

    Raghavendra Mudugal (10/13/2014)

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

    Great question and...

    October 13, 2014 at 7:54 am

    #1751989

  • RE: APPLY

    Great question! I love me some APPLY.

    October 8, 2014 at 6:59 am

    #1750934

  • RE: Row limits

    Ed Wagner (10/3/2014)

    SqlMel (10/3/2014)

    But I must say that I do not use this feature in my coding.

    I haven't either. I'd use TOP myself, but this is another nice tool...

    October 3, 2014 at 7:19 am

    #1749973

  • RE: raiserror level

    Thanks for the question Steve.

    October 2, 2014 at 7:47 am

    #1749682

  • RE: How many rows will be returned?

    Thanks for the question. I don't use triggers day to day so this was a nice learning experience.

    September 23, 2014 at 7:41 am

    #1747461

  • RE: ISNULL

    marcia.j.wilson (9/22/2014)

    JustMarie (9/22/2014)

    Made my guess, ran the code, got back NULL. Not an empty record set - NULL.

    So, did I. Even though that's what I answered, that's not...

    September 22, 2014 at 10:36 am

    #1747180

  • RE: Synonyms 1

    Thanks for the question. I had it right and then second guessed myself, so I learned something today.

    September 8, 2014 at 8:02 am

    #1743871

  • RE: What will this query return?

    SqlMel (9/4/2014)

    Thanks for the question.

    I'm actually surprised so many people have got this wrong.

    I say that because when I started using CTEs I was not accostumed to using the semicolon...

    September 4, 2014 at 7:26 am

    #1743205

  • RE: TVP

    Great question. Thanks.

    September 3, 2014 at 6:57 am

    #1742768

  • RE: Persisted Columns

    Ed Wagner (9/2/2014)

    I learned something new today. I didn't know about the add persisted syntax either. Got it wrong, but still learned something, so thanks for the question.

    +1...

    September 2, 2014 at 7:43 am

    #1742446

  • RE: Hypervisor

    Thanks for the question Steve. This was an easy one to finish the week on and I'm loving all the other "answers" in the forum.

    August 29, 2014 at 7:51 am

    #1741903

  • RE: CTE

    Thanks for the question. I learned something today.

    August 28, 2014 at 7:31 am

    #1741640

  • RE: sp_rename and the procedure definition

    stephen.long.1 (8/13/2014)

    Nice question. I've never used sp_rename, and now I know that I shouldn't use it. 🙂

    +1 Thanks so much for the question. I learned something new today.

    August 13, 2014 at 7:50 am

    #1737583

  • RE: What was that field name?

    Koen Verbeeck (8/6/2014)

    Nice question. I use SQLPrompt by Redgate so I immediately get all the column names and data types through the IntelliSense without even doing anything 😎 :w00t:

    +1 Thanks...

    August 6, 2014 at 7:40 am

    #1735641

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