Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 5,590 total)

  • RE: DeadLock

    Craig Farrell (10/6/2010)


    WayneS (10/6/2010)


    Craig Farrell (10/6/2010)


    Answer: No and no.

    This code, as is, will not deadlock independently. There's no transaction calls.

    What is the serverwide setting for isolation?

    Craig, did you consider...

  • RE: Finding Sequences (Need help ASAP)

    craig-404139 (10/6/2010)


    Craig Farrell (10/6/2010)


    craig-404139 (10/6/2010)


    Craig Farrell (10/6/2010)


    Craig,

    Is it safe to assume that this field will alway end in numerics? If so, I may have a simple solution for you...

  • RE: DeadLock

    Craig Farrell (10/6/2010)


    Answer: No and no.

    This code, as is, will not deadlock independently. There's no transaction calls.

    What is the serverwide setting for isolation?

    Craig, did you consider the effect of...

  • RE: DeadLock

    Amit Pandey DeBugSQL (10/6/2010)


    The Deadlock trace graphs shows the same object ID on the node2 which points to the below Stored proc.

    I have a neat script that shreds a...

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (10/6/2010)


    Alvin Ramard (10/6/2010)


    Are we there yet?

    Wow, Alvin gets two in one day.

    And both on the thread!

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (10/6/2010)


    Lately I have found that more posters actually have a problem with their expected result sets because they forgot (or didn't know) what they should be expecting. That...

  • RE: Are the posted questions getting worse?

    GilaMonster (10/6/2010)


    WayneS (10/6/2010)


    [Heavy Sigh]

    okay, wait mode on. This will be on your blog?

    Well, yes. 😀

    It's for the T-SQL Tuesday blog 'party' so *shock* *horror* you'll have to wait for the...

  • RE: Are the posted questions getting worse?

    GilaMonster (10/6/2010)


    WayneS (10/6/2010)


    Okay, I've got a few questions:

    1. Can I help?

    Thanks, but I have it under control (will hack out the post this weekend)

    2. Can you share the myth that...

  • RE: Are the posted questions getting worse?

    GilaMonster (10/6/2010)


    WayneS (10/6/2010)


    GilaMonster (10/6/2010)


    ... I have 3 table variable myths targeted.

    Did I cover them in my article[/url]? If not, I'd love to know what you have, so that I can...

  • RE: Are the posted questions getting worse?

    GilaMonster (10/6/2010)


    ... I have 3 table variable myths targeted.

    Did I cover them in my article[/url]? If not, I'd love to know what you have, so that I can enhance it...

  • RE: SELECT * WHERE pattern matches XXX

    This link might be helpful for you.

  • RE: Excel Worksheets

    SSIS can only work with known worksheets.

    However, you CAN use a Script Task, use some Excel Automation, and get a list of worksheets. However, utilizing Excel Automation on a Server...

  • RE: Why are we still talking about Women in Tech?

    I for one look forward to when

    Someday, we'll run out of "women in technology" things to talk about. That will be a good day.

    becomes a reality. It will...

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (10/5/2010)


    ... how many members of the thread will be coming to SQL Saturday#60 in Cleveland......

    Hmm, 9 hr drive each way, plus 2 nights in a hotel... I think I...

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (10/5/2010)


    Woohoo - Wayne just gave me permission to post a bunch!!!!!

    Actually, I wouldn't be surprised if Steve has a trigger on this thread... when it gets to 19950, it...

Viewing 15 posts - 3,001 through 3,015 (of 5,590 total)