Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | Michael Valentine JonesYak DBA Kernel (pronounced Colonel)
 
 
                                        7020 Posts | 
                                            
                                            |  Posted - 2006-06-06 : 21:18:34 
 |  
                                            | Paul Randal,There has been a discussion/debate going on this thread about the benefits and drawbacks of using the NOLOCK hint:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67294It occurred to me that you might know more about this than any of us, or at least be able to point us to a white paper or knowledge base article that explains the subject in more detail.  Any light you can shed on the subject would be a big help.CODO ERGO SUM |  |  
                                    | paulrandalYak with Vast SQL Skills
 
 
                                    899 Posts | 
                                        
                                          |  Posted - 2006-06-06 : 21:24:24 
 |  
                                          | I'll get one of my guys to jump on the thread.Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |  
                                          |  |  |  
                                |  |  |  |