SQL Server MVP Deep Dives, Volume 2

L

L1 cache L2 cache L3 cache LagMonths parameter Lah, Matija Landrum, Rodney Larsen, Greg Larsson, Peter last log backup last user seek LASTDATE (Date_Column) function LASTNONBLANK (Date_Column, Expression) function LASTPERIODS function LastRunOutcome property latches, buffer I/O late-arriving dimensions, in SSIS  example data structure  filing  handling in fact processing  ignoring  natural and surrogate keys  processing dimension up-date  scenario for  updating later late-arriving rows, caching LCK_M_* wait types LDF file, 2^nd Lee, Denny Leonard, Andy Levels method Levin, Ami lightweight reports lineage tracking linked pivots, vs. simple pivots linked server calls, in loops LinkedServers list disk statement ListPrice column live migration