Forum Replies Created

Viewing 15 posts - 4,021 through 4,035 (of 6,486 total)

  • RE: SELECT WITH NOLOCKS

    Jeff Moden (3/20/2008)

    No... like I said earlier... WITH (NOLOCK) only affects SELECT's. The following is from Books Online... (or are we talking something different?)

    NOLOCK

    Do not issue shared locks...

    March 20, 2008 at 10:51 am

    #792132

  • RE: Replace non numeric characters in string

    Sergei Zarembo (3/20/2008)

    If you go via a CLR regex function to render "235 dogs, 5 cats" to "2355" then [considering u r doing millions of recs] this a bit more...

    March 20, 2008 at 10:45 am

    #792129

  • RE: How to delete DTS versions.

    nplace6530 (3/20/2008)

    Hi Greg

    Many thanks for the reply.

    I've managed to find the GUI option to delete DTS package versions.

    The "Delete" option on right clicking the DTS package takes you into the...

    March 20, 2008 at 10:37 am

    #792118

  • RE: bulk updates on large tables

    jb_lbm (3/20/2008)

    thanks for the advice. I made your change so it only udpates where different (100% are different on the first runas they are defaulted to -1).

    I am going to...

    March 20, 2008 at 9:57 am

    #792095

  • RE: Performance Tuning: Concatenation Functions and Some Tuning Myths

    JJ B (3/20/2008)

    Mike: Thanks for looking into it. Glad to know I didn't miss something terribly obvious.

    re: "replace required on certain characters. "

    I would add: & # x 0...

    March 20, 2008 at 9:34 am

    #792081

  • RE: SELECT WITH NOLOCKS

    GilaMonster (3/19/2008)

    Matt Miller (3/18/2008)

    I'd have to agree. Just about the only thing preventing NOLOCK would be a schema-lock, or something changing your DDL. Do you have something routinely...

    March 20, 2008 at 9:18 am

    #792069

  • RE: optimizing query

    Since we're still guessing (no specifics to work on) - can you make that a covering index? Is the index even being used by the execution plan?

    March 20, 2008 at 9:09 am

    #792067

  • RE: Daterange Overlap Another Daterange

    Can't you just logically do it with 2 conditions:

    (StartOfService < WarEnd) and (EndOfService > WarStart)

    Should cover all possibilities, IMO....

    Of course - this only answers the questions of "who...

    March 20, 2008 at 9:00 am

    #792058

  • RE: Reduce INITIAL SIZE of TEMPDB

    Andras Belokosztolszki (3/20/2008)

    mjsteele (3/20/2008)

    No it deals with SIZE, which is different than INTIAL SIZE.

    🙂 Well, one more try:

    Management Studio will ignore your attempt to set the size of tempdb to...

    March 20, 2008 at 8:47 am

    #792046

  • RE: Replace non numeric characters in string

    By the way - here are the results for the "top 4", based on 4M rows... (Excluding the "I know the pattern" solution)

    Tomm - yours made the list. It's...

    March 20, 2008 at 8:34 am

    #792040

  • RE: Reduce INITIAL SIZE of TEMPDB

    The size cannot be smaller than the initial size. If you use the ALTER command - the SIZE will become the initial size.

    If you don't like using that -...

    March 20, 2008 at 8:20 am

    #792028

  • RE: More RBAR and "Tuning" UPDATEs

    Jeff Moden (3/20/2008)

    Manie Verster (3/20/2008)

    Hi Jeff, and I thought you were an American. Americans only eats meatloaf or not?:hehe:

    Heh... depends... will meatloaf hold up in a slingshot? 😉

    My Great-Aunt Wilma's...

    March 20, 2008 at 8:05 am

    #792015

  • RE: Concatenating string

    ryno (3/20/2008)

    Ahh great 🙁

    I just replace the query string back into the OPENQUERY and still it give me:

    Incorrect syntax near '+'.

    whatever is being passed to openquery must be a static...

    March 20, 2008 at 8:01 am

    #792005

  • RE: Replace non numeric characters in string

    GSquared (3/20/2008)

    Matt Miller (3/19/2008)

    ...Knowing the pattern allows you to come up with something better.

    Yeah.

    Of course, as in my prior example, turning "235 dogs, 5 cats", into "2355", is probably not...

    March 20, 2008 at 7:28 am

    #791978

  • RE: Replace non numeric characters in string

    GSquared (3/19/2008)

    That's on 4-million rows, no indexes, etc. Same tables as my last tests.

    How does that do on your machine?

    About like yours. It kills the regex replace handily....

    March 19, 2008 at 5:29 pm

    #791819

Viewing 15 posts - 4,021 through 4,035 (of 6,486 total)