Hi,
I understand in SQL Server there are various levels of granularity for locks...RID, Key, Page, Extent, Table, DB.

Forgetting about lock escalation, I just want to check the default level of granularity in SQL Server 2008? How do I do that?

Thanks.