https://medium.com/geekculture/a-primer-on-stored-procs-locks-transaction-commits-query-plans-in-microsoft-sql-server-5be28495c085
