L

language interoperability, 333–336

Larson, Brian, 20

latches, 62

Latches SQL Server object, 547

Law of Scalability, 258

lazywriter process, 64, 71

LEFT function, 582

left outer joins, 463, 472–473

LEFT(string, startindex) function, 313

legacy client code, 385

legacy inner join statements, 471

legacy methods, 538

legacy outer join statements, 463

LEN function, 313, 582

less than (<) operator, 297, 462

Less Than (<) operator, 560

less than or equal to (<=) operator, 297, 462

Less Than or Equal To (<=) operator, 561

LIKE function, 582

LIKE logical operator, 298

linear scalability, 255

linear scale-up, 258

line-of-business (LOB) applications, 7, 24

linked servers, 480–481

load balancing, 257, 263–264, 267

LOAD function, 582

LOB (line-of-business) applications, 7, 24

local partitioned views, 480–482

local stored procedures, 401

local temporary tables, 29

LOCK_TIMEOUT setting, 497

locking mechanism, 52

locks

overview, 61–62

transactional data management of, 487–497

blocks, 494

compatibility, 494–495

deadlocks, 495–497

duration, 493–494

escalation, 495

granularity, 491

hints, 497

modes, 492–493

obtaining information about, 495

overview, 487–491

Locks SQL Server object, 548

log caches, 56

Log File Viewer, 77

log files, 24, 40–42, 46, 64

LOG function, 582

LOG ON keyword, 147

log sequence numbers (LSNs), 245

log shipping, 235–243

basics of, 236–237

configuring manually, 237

configuring with Management Studio, 237–242

overview, 235

SQL Server Agent jobs, 243

LOG10 function, 582

LOG10(float) mathematical function, 318

LOG(float) mathematical function, 318

logical database architecture, 26–38

creating tables, 26–27

data integrity mechanisms, 34–36

data types and domains, 28

defaults, 36

full-text indexes, 38

indexes and keys, 30–34

naming convention, 27–28

NULL, 28

overview, 26

properties, 38

rules, 36

stored procedures, 37

system, 28–29

table data type, 29

triggers, 36

user-defined data types, 37–38

user-defined functions, 38

views, 29–30

logical disks, 142

logical operators, 297–298, 461–462

logical reads, 57

logical reporting, 469

logical_expression placeholder, 169

logical_file_name placeholder, 155

logins, 114–115, 118, 130–131, 133, 279

logs

Performance Monitor, 549–551

SQL Server, 77

lost updates, 488

LOWER function, 313–314, 582

LSNs (log sequence numbers), 245

LTRIM function, 314, 582