sp_BlitzCache could detect queries using dirty reads (kind of) and warn if they conflict with iso levels

[LitKnd]

sp_BlitzCache could look for NOLOCK hints or SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED in procedure text.

This isn't perfect because the nolock hints could be hidden in views, or the app could be setting the iso level in a statement (not a proc). But hey, it's something!

Extra points for detecting if RCSI / Snapshot are enabled in a user database and this might be underminding that setting.

[peschkaj]

This issue was moved to BrentOzarULTD/sp_BlitzCache#9