"Does SQL change S locks to NOLOCKS hints on its own because it seems like S Locks are being escalted to IX or X locks."

SQL Server doesn't change S...

Nice article, but didn't Christoffer say all of that just 20 days ago? Check: http://www.sqlservercentral.com/columnists/chedgate/sqlinjection.asp

Great article Chris!

I just want to add that Enterprise edition (and Developer ed.) will also consider using the indexed view, even when the view is not used in the query...