[DDC-2310] [2.4] Fix evaluation of NOLOCK table hint on SQL Server

Backport to 2.4 of https://github.com/doctrine/dbal/pull/508 required for https://github.com/doctrine/doctrine2/pull/925.