By default, SQL Server uses an isolation level of Read Committed, which means a query cannot read data modified by another transaction that has not yet committed, thus preventing dirty reads.