H

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