cRuchika (3/4/2010)
I still have doubts about BEST PRACTICES...
Google SSIS Best Practices
I mean I say that we can use NOLOCK,
I wouldn't necessarily say that's a best practice. Common practice, yes, often because peopple don't know what NOLOCK actually means.
See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability