Forum Replies Created

Viewing 15 posts - 3,466 through 3,480 (of 8,416 total)

  • RE: Statement evaluation precedence

    Tom Brown (5/7/2010)


    Thanks Paul for the tip on Itzik's book - I'll be visiting Amazon soon I think (or should I wait for the R2 edition?)

    AFAIK he's not releasing...

  • RE: Clustered indexes

    Jan Van der Eecken (5/7/2010)


    Paul, could you elaborate a bit more on this? BTW, thanks for the great articles on APPLY and Server-Side Paging.

    Gosh thanks Jan! Haven't seen you...

  • RE: Are the posted questions getting worse?

    Chris Morris-439714 (5/7/2010)


    Huh? Oh! Today's Random Worm is Gordon Brown, a former British politician. Google DSM-IV code 301.7 😎

    Harsh! You or Gordon Brown 😉 :laugh:

  • RE: Missing numbers in a series

    Garadin (5/6/2010)


    To know that much about SQL Server... AND be able to write C# code. Way to make the rest of us look like schmucks ;-).

    Hey look so I've...

  • RE: Minimising use of tempDB during large INSERT

    Chris Howarth-536003 (5/7/2010)


    Am I doing something wrong in my sample code above, or is the article inaccurate?

    Sort of neither, really 🙂

    SELECT...INTO is always minimally logged, but as I mentioned before,...

  • RE: Statement evaluation precedence

    CirquedeSQLeil (5/6/2010)


    Though I got this correct, it appears there is a typo in the correct answer. My version had the last two flip-flopped based on the source document provided...

  • RE: Statement evaluation precedence

    Yay! Another point. Found this one quite easy - but only because I happened to re-read Itzik Ben-Gan's Inside Microsoft SQL Server 2008: T-SQL Querying recently. (Chapter...

  • RE: Clustered indexes

    An excellent question - or was it several questions all rolled into one?

    Some extremely important concepts - unbelievably assigned just a single point! Madness.

    I got this right, but I...

  • RE: A round number

    Connect Item added:

    https://connect.microsoft.com/SQLServer/feedback/details/557523/automatic-type-assignment-causes-data-corruption

    Please vote and mark as reproducible if you can.

    Thanks to everyone that contributed to the discussion - especially Christian, Wayne, and Oleg.

  • RE: Missing numbers in a series

    Jeff Moden (5/6/2010)


    I'm not sure where you found the time to study that but, like Seth said, I learn something new every day. I didn't know why it worked...

  • RE: Missing numbers in a series

    Jeff Moden (5/6/2010)


    Paul White NZ (5/6/2010)


    Ok, here's the quick 'n' dirty CLR aggregate:

    Ooooohhhhh mmmmyyyyy ggggooooodddd... someone that actually knows what "//" is for.

    Very well done Mr. White.

    Thanks - but it...

  • RE: Improving Performance of Cross-Partition Queries

    Solomon Rutzky (5/6/2010)


    But then I tried the CROSS APPLY + $PARTITION approach and it took 1 minute and 30 seconds. Checking the stats it caused 1,262,939 logical reads and...

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (5/6/2010)


    Top Ten Posters in this thread (out of 15,100 or so)

    Hmmm. Seems I don't post as much in here as I thought.

    Steve, how about some...

  • RE: Are the posted questions getting worse?

    Grant Fritchey (5/6/2010)


    And by the way, just passed 8000 points. #10 to do so.

    Now I'll let Jason & Paul pass me.

    Jason's gone through. I'm more than 1000 posts...

  • RE: Missing numbers in a series

    Jeff Moden (5/6/2010)


    Yep... I remember the "other" triangular join. You made it to be very fast but it still ended up doing the same number of reads. This...

Viewing 15 posts - 3,466 through 3,480 (of 8,416 total)