Under SQL Server’s SNAPSHOT transaction isolation level, writers don’t block readers. We use it in production with good results.

While the internal implementation details differ from Oracle, the end result seems quite similar in practice.