I've written an article here on SQL Team about locking in SQL Server.

It's an introductory article that shows lock modes, lock granularity and lock compatibility matrix

and it will be followed by a few more advanced ones on the topic of locking.

Part 1:  Introduction to locking in SQL Server 2005