Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: very slow INSERT to #tmptable

    free_mascot (4/21/2015)


    Select statement is always fater than Insert statement.

    This is interesting - I had never heard that. Why would INSERT...SELECT take noticeably longer than SELECT INTO?

    free_mascot (4/21/2015)


    This looks like optimizer...

  • RE: very slow INSERT to #tmptable

    Jeff Moden (4/21/2015)


    Just a curious shot in the dark on this... what is the default collation of the database you're select from and what is the default collation of TempDB?

    Interesting...

Viewing 2 posts - 1 through 3 (of 3 total)