L

large object data types. See LOBs (large objects)

latches, storage engine, 449

lazy writer

flushing data pages to disk, 451

procedure cache and, 459

storage engine, 449

LEFT joins, 50

lightweight pooling, 407

LIKE operators, full-text searches compared with, 63

LIKE predicate, T-SQL (Transact-SQL), 468

linked servers

creating, 53

data providers available for, 51

distributed queries and, 51–54

loopback linked servers, 354

scalability, 349–352

SQL Server 2005, 25

Linked Servers node, Microsoft SQL Server Management Studio, 53

Linux clients, 19

load balancing, storage engine, 445

LOBs (large objects)

allocation units in heaps, 464

page reads and, 286

locking hints

applying, 265

exercise applying, 273–276

list of commonly used, 260

locks

case scenario for optimizing locking, 280

exercise acquiring locks using read committed snapshot isolation level, 256–258

exercise applying locking hints, 273–276

exercise using stored procedure to protect against deadlocks and phantom reads, 276–280

extensive locking problems, 252

locking hints, 260

minimizing deadlocks, 266

OUTPUT keyword for optimizing locking, 261, 266

schema stability locks (Sch-S), 239

SET _TIMEOUT statement, 236

solving concurrency problems, 235

logical reads, page reads, 286

logon passwords, 12

logon credentials, for connecting to server, 148

Log Sequence Number (LSN), 449

logs

flushing log pages to disk, 452

log parity in SQL Server 2005 Storage Engine, 446

writing error messages to event logs, 227

loopback connections, data access and, 433

loopback linked servers, not allowing, 354

lost updates

concurrency problems, 234

read uncommitted isolation level and, 238

LSN (Log Sequence Number), 448

LTRIM function, 468