Forum Replies Created

Viewing 15 posts - 1,081 through 1,095 (of 18,926 total)

  • RE: Eliminate Loop and take a set-based approach

    TheSQLGuru (11/16/2011)


    Phil Parkin (11/15/2011)


    Script component is what you mean, I think.

    Well done on taking the time to find a solution to your problem.

    I still have concerns over the potential...

  • RE: index record count difference

    Checking assumptions (since nothing else is making sense atm) =>

    What isolation level did you run this under?

    Was it under repeatable read and in the same batch?

    I have a few of...

  • RE: index record count difference

    Do you have any errors in the logs about possible corruption?

  • RE: Batch delete TSQL

    Also you could take a copy of the bigger tables from prod and start testing with batches side and log growth.

    Those are the only 2 things that can bite you...

  • RE: Batch delete TSQL

    adb2303 (11/16/2011)


    on my sandpit database it looks to be. I'll have to wait for the app support team to tell me how much trade data I've inadvertently deleted before...

  • RE: Batch delete TSQL

    So the test runs were successful?

  • RE: index record count difference

    One more time with feeling =>

    GilaMonster (11/16/2011)


    Wiesinger (11/16/2011)


    the checktable (including indexes) reports no error.

    No, it won't now, because the problem went away when you rebuilt the indexes.

    Indexes with...

  • RE: Batch delete TSQL

    adb2303 (11/16/2011)


    let someone else run it and pretend you never had anything to do with it?

    Sorry, all out of guesses! 😀

  • RE: what is the use of : WITH (NOLOCK, READUNCOMMITTED)

    GSquared (11/16/2011)


    Ninja's_RGR'us (11/14/2011)


    GSquared (11/14/2011)


    Tom Brown (11/14/2011)


    OK I've read and inwardly digested the link. :blush:

    Seems like SNAPSHOT Read committed is one way to go. However if I investigate this...

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (11/16/2011)


    GSquared (11/16/2011)


    Or change your subscription settings on The Thread and don't bother with e-mails from it.

    I already know it will be updated throughout the day just about every...

  • RE: Are the posted questions getting worse?

    Logitech Wireless Performance Mouse MX

    It recharges its batteries with USB cable (± once month even with extreme use).

    And it works on glass or even a white piece of paper....

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (11/16/2011)


    Ninja's_RGR'us (11/16/2011)


    Koen Verbeeck (11/15/2011)


    Ninja's_RGR'us (11/15/2011)


    jcrawf02 (11/15/2011)


    Hey, I like the condensed version of The Thread...

    Same here.

    No offense if I forgot anything else. I didn't reread the whole 2...

  • RE: Table space usage 2

    Just to add to the non-fire of the lack of space.

    If your default FF is not 100, then you get to run out of space even earlier :Whistling:!

  • RE: Batch delete TSQL

    Looks ok but it's easy to overlook something.

    Only 1 way to tell if it works!

    1 guess what it is :hehe:

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (11/16/2011)


    Ninja's_RGR'us (11/16/2011)


    Koen Verbeeck (11/16/2011)


    I know I know 😀

    But I still have to read 10 pages here on the forum 🙂

    It's only 2 pages at 50 posts per page!...

Viewing 15 posts - 1,081 through 1,095 (of 18,926 total)