Have your developers use WITH (NOLOCK) is my contribution. All selects cause locking of data and at least in my company 98% of queries are on historic or non-critical data. The performance-increase on an intense system can be dramatic. Syntax:
FROM table 1 a WITH (NOLOCK)
INNER JOIN table2 b WITH (NOLOCK)
ON a.ID = b.IDI'm aware that this is not exactly what you asked for but since I'm not a hardware-person this is what you get
"Real programmers don't document, if it was hard to write it should be hard to understand"