https://community.fabric.microsoft.com/t5/Fabric-Ideas/Automatic-use-of-NOLOCKS-when-querying-tables/idc-p/4505096
Automatic use of NOLOCKS when querying tables - Microsoft Fabric Community
Feb 25, 2025 - When you connect to tables, SQL is written in the background. However this doesn't include the use of WITH (NOLOCK). This can cause performance
microsoft fabricautomaticusequeryingtables