Forum Replies Created

Viewing 15 posts - 781 through 795 (of 3,232 total)

  • RE: Deadlock when NOLOCK hint is used

    Ah, that makes sense. I guess my problem was in lumping the NOLOCK hint in with the locking hints. To be honest, I know that it is an...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 6, 2010 at 12:30 pm

    #1099860

  • RE: Stored procedure directory variable

    mattennevor (1/6/2010)

    I was asking about why I needed to break the bulk insert as an output string of another SP.

    also thanks for the correction in code 🙂

    You don't. You...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 6, 2010 at 12:15 pm

    #1099849

  • RE: Deadlock when NOLOCK hint is used

    Both. I always believed that the optimizer could escalte the lock type or scope as needed regardless of hints. In retrospect, that would mean that the optimizer would...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 6, 2010 at 11:17 am

    #1099789

  • RE: Exporting Data to AS400 from SQL2005 with SSIS is SLOWWWWW

    First off, I've never had to move data from SQL Server 2005 to an AS400 system, but I have had to go between SQL Server 2005 and other non-SQL Server...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 6, 2010 at 10:53 am

    #1099773

  • RE: Getting connection manager information into a variable?

    How is the location changing? Are you using package configuration files?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 6, 2010 at 10:24 am

    #1099753

  • RE: Stored procedure directory variable

    Good catch Jack. I didn't even notice that one.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 6, 2010 at 10:20 am

    #1099748

  • RE: Today's Random Word!

    More snow....

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 6, 2010 at 10:16 am

    #1099744

  • RE: Deadlock when NOLOCK hint is used

    CirquedeSQLeil (1/6/2010)

    Thanks Gail. Once again you have taught me something.

    I agree, this is news to me. I'll have to admit that I've only found the need to use...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 6, 2010 at 10:05 am

    #1099738

  • RE: Deadlock when NOLOCK hint is used

    Keep in mind that hints are just that, hints. They tell the optimizer what it should do, but the optimizer still has the ability to choose what it thinks...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 5, 2010 at 5:07 pm

    #1099315

  • RE: Recover Lost Space

    You have to manually shrink the files. This is usually not a good idea as the files tend to grow back to their previous size during normal processing, but...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 5, 2010 at 4:48 pm

    #1099312

  • RE: moving sql servers to a new ou

    Good question. I am not a network administrator so I don't know. I'd imagine that it is identical to moving it to the new ou. Isn't that...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 5, 2010 at 3:49 pm

    #1099299

  • RE: How to Reduce the Logical Reads, to imporve the Performance of the Query

    papapumpy (1/5/2010)

    Yes, indexing helps but reducing logical reads does not help performance. maybe a tiny bit

    read some article about buffer hit ratio and data cache. physical reads is the one...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 5, 2010 at 3:37 pm

    #1099287

  • RE: Newbie Question

    Thank you. It's not that we don't want to help. Each of us has our own jobs with our own work to do. So the more work...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 5, 2010 at 2:54 pm

    #1099263

  • RE: moving sql servers to a new ou

    This should be treated just like any other server move within your network. This is a network access issue, not a SQL Server one. As long as the...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 5, 2010 at 2:50 pm

    #1099260

  • RE: Newbie Question

    John Rowan (1/5/2010)

    Can you give an example of what Table X looks like, along with some sample data, and an example of how you want the finished Users table to...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    January 5, 2010 at 2:29 pm

    #1099249

Viewing 15 posts - 781 through 795 (of 3,232 total)