Forum Replies Created

Viewing 6 posts - 16 through 21 (of 21 total)

  • RE: WITH (NOLOCK) Question

    Michael L John (2/27/2015)


    They are PK indexes, so they are clustered.

    A primary key does not have to be a clustered index.

    A clustered index does not have to be the...

  • RE: WITH (NOLOCK) Question

    Matt Miller (#4) (2/27/2015)


    I am not going to wade in to the main part of the pool (plenty of good advice already out there), but I will point out this...

  • RE: WITH (NOLOCK) Question

    Michael L John (2/27/2015)


    Katerine459 (2/27/2015)


    (Edit to add: How do you post an execution plan from SSMS?)

    See

    Grant Fritchey

    The Scary DBA

    Author of:

    SQL Server Query Performance Tuning

    and

    SQL Server Execution Plans

    These...

  • RE: WITH (NOLOCK) Question

    Thanks again to all! All of you have given me a great deal to think about. 😀

    Luis Cazares: Thanks for that! It looks awesome, and I almost understand it, except...

  • RE: WITH (NOLOCK) Question

    I should have posted this question on a day when I'm not sick. 😀

    First of all, thank you all for your advice thus far. I'm sure it will be really...

  • RE: WITH (NOLOCK) Question

    Nevyn: Depends on what you mean by "a while." The database is fairly small and new, and I think there are less than 200 clients. The Access report that uses...

Viewing 6 posts - 16 through 21 (of 21 total)