Bits of .NET

SELECT COUNT_BIG(*) FROM Orders WITH (NOLOCK);

Why this matters
On massive tables, counts are expensive — cache or approximate when possible.