Table Locking Vs No Table locking

what is everyone’s opinion about table locking in linq queries… can it cause memory leaks if you have data directives that MRP touches…