<p>How do I avoid read locks in my database?</p>

<p>Answers for multiple databases welcome!</p>

In SQL Server you can use the with(nolock) keyword in your select statements.  For example:
```
```
Select table1.columna, table2.columna
from table1 with(nolock), table2 with(nolock)
```
```
Make sure to specify with(nolock) for each table/view in the query.