Best Practice No.28

8 Aug

Best Practice No.28

Sarabpreet Singh Anand Best Practices Leave a comment

Understand NOLOCK hint before using this in your transactions\applications – the data you are reading might not be consistent (Dirty Reads)

About Author: Sarabpreet Singh Anand

SQLServer - MVP Sarabpreet is SQLServer MVP, Consultant, Speaker, Trainer, Blogger and Community Lead. You can find him speaking at a local UG Event or a SQL Webcast. He has 11+ years of Experience and worked with Industry Leaders. He has many SQL Certifications under his belt. His core competency lies in administration of SQL Server. Always ready to help, online \offline. His life’s mantra is “Knowledge Increases by sharing so, Pass it on”.

Sarabpreet S. Anand

SQL Server (Ex-MVP), Consultant, Speaker, Trainer and Learner ;)