hardware
read cache and write cache, 449
requirements for Exam 70–442, xix
scatter-gather capabilities, 449
hardware trends
CPUs, 407
new trends in hardware manufacture, 406
NUMA, 407
software design and, 408
HAVING clauses
function in SELECT statements, 456
subqueries and, 50
heaps, in non-clustered indexes, 305
heterogeneous data sources, linked servers, 51
HOLDLOCK, 260
horizontal partitioning
DDR and, 355
DPV and, 353
overview of, 344
HPAs (Host Protection Attributes), 429
HTTP Web services, connections for, 22–24
HTTP endpoints
authentication options, 20
creating for client connections, 19
exercise consuming HTTP endpoint, 28–30
exercise creating HTTP endpoint, 27–28
SMO for accessing, 145