L

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

latency
     replication 2nd
LEN() function
Length descriptor (columns)
Lightweight Pooling option (server properties)
linked servers 2nd 3rd 4th 5th
LOCAL cursors
Lock events 2nd 3rd
Lock[colon]Acquired event
Lock[colon]Cancel event
Lock[colon]Deadlock Chain event
Lock[colon]Deadlock event
Lock[colon]Escalation event
Lock[colon]Released event
Lock[colon]Timeout event
locking
     diagnosing with Profiler traces 2nd 3rd
locks 2nd 3rd
     contentions 2nd
     controlling lock behavior 2nd 3rd
     exclusive locks
     granularity
     shared locks
     transaction isolation levels 2nd
locks by object
locks by process ID
Locks option (server properties)
log files 2nd
logging
     application logs 2nd
logical data modeling 2nd 3rd 4th 5th 6th 7th
    attributes
         decomposing 2nd 3rd
         defining 2nd 3rd
         definition of
         foreign keys 2nd
         identifiers
         key attributes 2nd
         primary keys 2nd
         surrogate keys
     dependencies
         parent-child
    entities
         associate entities
         associative entities
         characteristic entities
         definition of
         kernel entities
         selecting 2nd 3rd
         unary entities
     ER (Entity Relationship) Model 2nd 3rd
         associate entities
         associative entities
         attribute decomposition 2nd 3rd
         attribute definition 2nd 3rd
         characteristic entities
         entity selection 2nd 3rd
         ERDs (Entity Relationship Diagrams)
         foreign keys 2nd
         identifiers
         kernel entities
         key attributes 2nd
         primary keys 2nd
         relationships
         surrogate keys
         unary entities
     exam prep questions 2nd 3rd 4th 5th 6th 7th 8th 9th
     logical structure
     relationships 2nd
         cardinality
         definition of
         identifying 2nd
         many-to-many 2nd 3rd 4th 5th
         one-to-many 2nd 3rd 4th
         one-to-one 2nd 3rd
logical operators 2nd
logical structure
logins 2nd 3rd 4th
     creating 2nd
logs
loops 2nd 3rd
LTRIM() function