• Sergiy - Tuesday, May 23, 2017 6:30 PM

    Anyone in the mood for talking about RAM requirements while remaining tight-lipped about the use of NOLOCK? Here you go.

    Apparently, there is nothing wrong with NOLOCK.It's inbuilt in in-memory objects, and it's a new big thing.So, shut up you pensioners! NOLOCK is good.Approved by Microsoft.

    Azure SQL Data Warehouse connections are all READ_UNCOMMITTED.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning