Forum Replies Created

Viewing 15 posts - 1 through 15 (of 584 total)

  • RE: How Many Rows Returned

    NBSteve (6/15/2015)

    For anybody having trouble following the joins, just focus on the Authors in the individual joins. ...(Nice explanation deleted) ...

    That was a very good explanation. I appreciate it.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    June 15, 2015 at 5:30 pm

    #1805614

  • RE: XML Indexes

    Thanks for an easy start to the week, even though it's not Monday yet! 😉

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    February 28, 2015 at 3:16 pm

    #1780905

  • RE: Not Again!

    Brian.Klinect (2/18/2015)

    I learned to today that I can set permissions at the column level. Never even considered trying to do that before.

    I really liked the story that went with...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    February 18, 2015 at 4:19 pm

    #1778507

  • RE: Group By, Count, and NULLs

    Nice question to highlight the differences in ways that NULLs are handled by different operations. Thanks!

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    February 2, 2015 at 8:57 am

    #1774803

  • RE: SOME rows

    Brian Hibbert (1/29/2015)

    I think I'm not quite understanding what SOME (or Any) actually does.

    A quick read of the BOL says the return type is Boolean, but it's not...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 29, 2015 at 10:44 am

    #1774099

  • RE: EXCEPT

    Thanks for the question Steve. Liked it a lot.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 28, 2015 at 10:28 am

    #1773760

  • RE: Getting Distinct

    Bob Cullen-434885 (1/23/2015)

    Thanks Hugo for a perfectly clear explanation!:-)

    +1 Still waiting for Hugo to rewrite BOL so they are more useful. 🙂 In his spare time of course.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 23, 2015 at 5:38 am

    #1772564

  • RE: IMPLICIT_TRANSACTIONS & BEGIN TRAN

    Hugo Kornelis (1/12/2015)

    I thought that using SELECT would have started the implicit transaction, but I tested after answering this question and nothing changes if I use SELECT instead of PRINT....

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    January 12, 2015 at 2:38 pm

    #1769646

  • RE: Parallel Plans

    Easy one. Thanks for the Christmas gift Steve!

    Hope everyone who is not offended by the statement has a Merry Christmas! I hope the rest have a great day too....

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    December 24, 2014 at 11:55 am

    #1766374

  • RE: T-SQL

    Nice easy one for a Friday. Thanks for submitting the question!

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    December 19, 2014 at 9:43 am

    #1765753

  • RE: Execution Plan reuse

    Nice question. And I'm only partially motivated in my praise by having got it correct.

    Had to think about it for a while - almost went with the dropping an index...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    December 17, 2014 at 9:45 am

    #1765230

  • RE: I have no id

    Heals (12/16/2014)

    Good question - got it wrong, but learnt something so all to the good!

    Never come across it before as I always use aliases, but good to know when I...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    December 16, 2014 at 3:01 pm

    #1765038

  • RE: Automatic Page Repair

    Seemed pretty much common sense. Glad it was. Thanks for the question!

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    December 2, 2014 at 10:55 am

    #1762177

  • RE: Find the Most Recent Post

    Thanks for the question. Seemed easy enough, but was sufficiently challenging for a Monday.

    Saw Koen's plug for his blog. Can we get him to rewrite BOL too?

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    November 24, 2014 at 10:02 am

    #1760577

  • RE: Fun with RAND()

    Chiefly Confused (11/5/2014)

    I also believe the answer is misleading. The select will return 1 row, 1 to 9 times, each one is a separate select of 1 row. ...

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

    November 5, 2014 at 3:54 pm

    #1756841

Viewing 15 posts - 1 through 15 (of 584 total)