A quick look at the different types of cache objects SQL Server 2005 keeps in the procedure cache, from a troubleshooting book I reviewed.
LEN Versus DATALENGTH: Trailing Spaces and Unicode Bytes
LEN versus DATALENGTH answers different length questions. Use explicit text types to check trailing spaces, Unicode bytes, empty values and NULL.
THROW or RAISERROR
THROW or RAISERROR changes how SQL Server handles severity, formatting, and XACT_ABORT; choose the right pattern for new procedures.
SQL SERVER – Order of Result Set of SELECT Statement on Clustered Indexed Table When ORDER BY is Not Used
A Clustered Indexed Table still needs ORDER BY to promise result order. I declare the order the reader or application requires.
Scaling Out Read Queries
Scaling out read queries uses replicas, caches, and routing with measured freshness and operating cost; learn when each path fits.
Designing Tables for High Insert Rates
High insert rates depend on key choice, row width, index count, and retention design; learn a practical SQL Server table layout for sustained writes.
Querying Active Directory From SQL Server
Querying active directory through an ADSI linked server can answer narrow questions, but its limits favor staged data for repeatable work.