Forum Replies Created

Viewing 15 posts - 7,996 through 8,010 (of 8,416 total)

  • RE: SET vs SELECT

    Florian Reischl (5/9/2009)

    ...the TPM thought there is no time to fix it for the first version and the customer "for sure" would never do this...

    If I had a dollar for...

    May 9, 2009 at 10:43 am

    #991652

  • RE: SET vs SELECT

    Florian Reischl (5/9/2009)

    ...a joker entered something like "84320583450" :laugh:

    If only 'joker' were synonymous with 'tester' eh?

    May 9, 2009 at 10:36 am

    #991650

  • RE: Are the posted questions getting worse?

    Florian Reischl (5/9/2009)

    @paul-2: Starting with a string.Join or a StringBuilder? 😉

    A StringBuilder. A CLR aggregate based on a StringBuilder.

    Such as implementation gets plugged directly into the plan (no reflection!)...

    May 9, 2009 at 10:34 am

    #991649

  • RE: Are the posted questions getting worse?

    Bob Hovious (5/9/2009)

    ...I'm certainly happy both you guys have become regulars.

    I ascribe it to a high-fibre diet and drinking plenty of water. :laugh:

    Seriously, thanks. But speaking for myself, I...

    May 9, 2009 at 10:31 am

    #991648

  • RE: Concurrency Question

    Lynn Pettis (5/9/2009)

    You do understand that it isn't the implicit or explicit transaction itself that creates the locks, but the action itself (INSERT,UPDATE,DELETE, and even SELECT), and that any locks...

    May 9, 2009 at 10:26 am

    #991647

  • RE: SET vs SELECT

    The effort-reward ratio has fallen below my personal threshold on the whole SELECT versus SET assignment thing. Anyone who thinks n SET statements is as quick as a single...

    May 9, 2009 at 10:03 am

    #991644

  • RE: Are the posted questions getting worse?

    That's not a bad idea.

    Maybe I will start a thread to show how CLR solutions are best for concatenating strings...!

    😎

    May 9, 2009 at 6:35 am

    #991610

  • RE: Are the posted questions getting worse?

    Flo,

    Understood! I will stop building you up :laugh:

    Congrats on reaching Ten Centuries BTW!

    Paul

    May 9, 2009 at 3:42 am

    #991590

  • RE: SET vs SELECT

    Florian Reischl (5/9/2009)

    Question: Am I the only one that finds the TOP syntax a bit strange-looking sometimes?

    Yep, from my side. I like this syntax but it depends on the formatting.

    How...

    May 9, 2009 at 2:57 am

    #991583

  • RE: Are the posted questions getting worse?

    Florian Reischl (5/8/2009)

    It will end with the beginning 😉

    :laugh:

    Yes, but sadly I remember the beginning too!

    May 9, 2009 at 2:23 am

    #991579

  • RE: SET vs SELECT

    John Esraelo (5/9/2009)

    have not we have had kicked this dead horse plenty..

    I think we did..

    :))

    Hey John,

    Probably, yes.

    If it's ok with you though, I'd like to carry on a while longer,...

    May 9, 2009 at 2:19 am

    #991578

  • RE: SET vs SELECT

    Florian Reischl (5/8/2009)

    I think I misunderstood your code and the intention. This is a really nice deal if you want to be sure that there is no other value. My...

    May 9, 2009 at 2:15 am

    #991577

  • RE: SET vs SELECT

    Jeff Moden (5/8/2009)

    Paul White (5/8/2009)

    When assigning multiple variables from constants, SELECT is significantly quicker than separate SET statements.

    Heh... I agree, but where's the code to prove that? 😉

    And there...

    May 9, 2009 at 1:59 am

    #991573

  • RE: Concurrency Question

    Bob Hovious (5/8/2009)

    Paul, can we agree that if a unique index exists over the column(s) to be inserted, that SQL will return an error for any subsequent "duplicate" inserts regardless...

    May 9, 2009 at 1:46 am

    #991572

  • RE: Concurrency Question

    -- duplicate post: having problems submitting this end! --

    May 9, 2009 at 1:39 am

    #991570

Viewing 15 posts - 7,996 through 8,010 (of 8,416 total)