Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Using a View from one database to a second database that returns a large result set RE: Using a View from one database to a second database that returns a large result set

  • July 30, 2013 at 2:42 pm

    #1637116

    Erland Sommarskog (7/30/2013)

    Kalyan Boddupalli (7/30/2013)

    1. Make sure nolocks are maintained on the tables from where the data is getting selected

    Do you mean that the NOLOCK hint should be used? Have ye no shame!

    The NOLOCK hint can be very important when running diagnostic queries in a live system, but it rarely is a good thing to put in application code, and absolutely not in a view definition!

    I agree here. There is little to no reason to make that recommendation.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events