At my company I was advised to always run SQL queries as follows:
SELECT col1, col2
FROM table WITH (READUNCOMMITTED)
WHERE table.id = my_id;
It is a production database which is used by other applications and I only have read access. However I issued a query like the following:
SELECT col1, col2 FROM table;
Is it possible that I corrupted the database by locking parts of it due to the missing WITH (READUNCOMMITTED)? I stopped the query before it could finish.