latency, 364
licensing, 16
Lightweight Pooling, 399
Linked Objects, SSAS, 75
load
defining, 377–378
tuning, 526–528
LOAD Database statement, 64
Load Transaction statement, 64
local server accounts, 28
local service accounts, 28
local system accounts, 28
lock granularity for indexes, 483
lock pages in memory, enabling, 394
locks, monitoring, 93–94, 434
Log Reader Agent, replication using, 531
log sequence number (LSN), 594
log shipping
as alternative to clustering, 656
architecture of, 629–630
backup and recovery affects on, 628–629, 647
backup and recovery for, 606
compared to database mirroring, 585
configuring, 632–633
database mirroring integrated with, 648
deploying
with Management Studio, 634–637
scenarios for, 627–629
with T-SQL statements, 638
as disaster recovery solution, 628–629
failover clustering integrated with, 648
monitor server for, 630, 632
monitoring, 638–641
network requirements for, 632
performance of, 650
primary server for, 629
processes used by, 631
removing, 649–650
replication integrated with, 648–649
as report database, 629
role changing between servers
planned failover, process for, 644–645
redirecting clients, 646–647
switching between servers, 645–646
synchronizing dependencies for, 641–644
unplanned role change, process for, 645
secondary server for, 630
support for, by SQL Server edition, 15, 632
system requirements for, 631–632
troubleshooting, 638–639, 641
upgrading to SQL Server 2005, 72, 650–652
as warm standby server, 628
logical scan fragmentation, 475
logical unit numbers (LUNs), 371–372
logins for SQL Server instance. See also accounts for SQL Server; users
authentication for, 293–294
BUILTIN\Administrators login, 301–302
conflicts between access rights, 300–301
creating, 294–300
disabling, 299
granting access to objects, 299
granting database rights, 297–298
passwords for, 295–296
server roles for, 297
T-SQL for, 300
unlocking, 299
logs. See also log shipping; transaction log
default location for, setting, 42, 89
deleting, 46
displaying in Management Studio, 91
for jobs, 108
mirroring, 21
physical drive configuration for, 21
space required for, 66
specifying at startup, 83
SQLDiag.exe program using, 101
for SSAS, 184
log_shipping_databases table, 651
log_shipping_monitor table, 651
log_shipping_monitor_alert table, 638
log_shipping_plan_databases table, 651
log_shipping_plan_history table, 651
log_shipping_plans table, 652
log_shipping_primaries table, 652
log_shipping_secondaries table, 652
loop join (nested loop), 462–463
LSN (log sequence number), 594
LUNs (logical unit numbers), 371–372