Index L

[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]

LANs (Local Area Networks), PC LAN computing   2nd  
latches, Lock Manager  
latent transactional consistency  
Lazy spool, Query Analyzer  
lazywriter process, memory management   2nd   3rd   4th   5th  
leaf rows, nonclustered indexes   2nd   3rd   4th   5th   6th   7th  
legacy syntax
       T-SQL  
levels
       AS  
libraries
       .NET Framework class library   2nd  
       DB-Library applications  
       named pipes   2nd  
       Net-Libraries
               DLLs   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
       networks
               installatin and   2nd  
licensing models   2nd   3rd   4th  
       CAL  
       Database Engine Edition  
       EULA  
       failover cluster configuration   2nd  
       installation and   2nd  
       mixing  
       Per Processing  
       Per Seat licensing  
       Personal Edition  
       processor licensing  
       Processor licensing  
       selection tips   2nd  
       Server/Per-Seat Client Access License  
       Windows CE edition  
lightweight pooling, configuration   2nd  
Like/Not Like filter, Profiler  
linked cubes, AS  
linked servers   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th  
       adding   2nd   3rd   4th   5th   6th   7th   8th  
       completely linked servers  
       configuration   2nd   3rd   4th   5th   6th   7th  
       definition   2nd  
       distributed queries   2nd  
       distributed queries and   2nd  
       distributed transactions   2nd  
       dropping   2nd  
       general information   2nd   3rd  
       local logins   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
               dropping mappings   2nd  
               login settings   2nd   3rd  
       overview   2nd   3rd   4th   5th   6th  
       remote datasources   2nd   3rd   4th  
       remote server  
       security   2nd   3rd   4th   5th  
       setup
               Enterprise Manager   2nd   3rd  
       sp_addlinkedserver   2nd   3rd   4th   5th   6th   7th   8th  
       sp_addlinkedsrvlogin   2nd   3rd   4th   5th   6th   7th  
       sp_droplinkedsrvlogin   2nd  
       sp_dropserver   2nd  
       sp_helplinkedsrvlogin   2nd   3rd  
       sp_linkedserver   2nd  
       sp_serveroption   2nd   3rd   4th   5th   6th   7th  
       stored procedures  
               executing  
        system-stored procedures   2nd  
       T-SQL and   2nd   3rd   4th   5th  
links servers
       Enterprise Manager  
listings
       altering views   2nd  
       CREATE_INDEX syntax   2nd  
       Creating Base Tables for Partitioned View   2nd   3rd   4th  
       Grouping function  
       GROUPING function, resultset ordering  
       grouping over several columns   2nd  
       IF statement, conditional processing  
       Local Partitioned View   2nd   3rd  
       Returning data from multiple tables  
       ROLLUP operating calculating super aggregates  
       SELECT statement defining information_schema.table_privileges View   2nd   3rd  
       T-SQL to create database   2nd  
       view to limit column access   2nd   3rd  
       views, WITH CHECKOPTION  
load balancing, enterprise computing and   2nd   3rd  
load performance, BCP utility and   2nd   3rd   4th   5th  
loading image data, BCP utility   2nd   3rd   4th   5th   6th  
local cubes, AS  
local cursors   2nd  
local logins
       mapping to linked server   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
               dropping mappings   2nd  
               login settings   2nd   3rd  
Local Partitioned Views  
local temporary tables, stored procedures   2nd   3rd   4th  
local variables   2nd   3rd   4th   5th  
       values
               assigning  
Lock Manager   2nd   3rd  
       bulk update locks  
       exclusive locks  
       intent locks   2nd   3rd   4th  
       schema locks   2nd  
       shared locks   2nd   3rd  
       syslockinfo table   2nd   3rd   4th   5th   6th   7th  
       types of locks   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th  
       update locks   2nd   3rd  
locking
       application locks   2nd   3rd   4th   5th   6th   7th  
        contention   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th   30th   31st   32nd  
       deadlocks   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th   26th   27th   28th   29th   30th   31st   32nd  
       Enterprise Manager and   2nd   3rd   4th   5th  
       granularity   2nd  
       index locking   2nd   3rd   4th  
       isolation levels and   2nd   3rd   4th   5th  
       latches  
       lock escalation   2nd   3rd  
       locks configuration setting   2nd   3rd  
       need for   2nd   3rd  
       optimistic locking   2nd   3rd   4th   5th   6th   7th  
       page-level   2nd   3rd  
       Performance Monitor and   2nd   3rd  
       Profiler and   2nd   3rd   4th   5th  
       row-level   2nd   3rd  
       sp_lock stored procedure   2nd   3rd  
       syslockinfo table   2nd   3rd   4th  
       tables and   2nd   3rd   4th   5th   6th   7th   8th   9th  
       traces and   2nd   3rd  
locks
       activity monitoring   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th  
       bulk update locks  
       compatibility   2nd  
       configuration   2nd  
       exclusive locks  
       granularity   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st   22nd   23rd   24th   25th  
       intent locks   2nd   3rd   4th  
       key range locking, serialization and   2nd   3rd   4th   5th   6th  
       locking levels   2nd   3rd  
       schema locks   2nd  
       shared locks   2nd   3rd  
       syslockinfo table   2nd   3rd   4th   5th   6th   7th  
       timeouts, setting   2nd  
       transactions   2nd   3rd   4th   5th  
       types   2nd  
       types of   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th  
       update locks   2nd   3rd  
locks configuration setting   2nd   3rd  
locks, Performance Monitor  
Log Agent
       transactional replication  
log caches  
log files   2nd   3rd   4th  
       shrinking   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th  
log manager   2nd   3rd  
log marks  
Log Reader Agent
       subscriptions
               creation  
log reader agent (replication)   2nd   3rd  
Log Row Scan icon, Query Analyzer  
log shipping   2nd   3rd   4th   5th   6th   7th   8th  
log shipping tables   2nd  
Log view, Performance Monitor  
log writer  
logged operations, BCP utility   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th   16th   17th   18th   19th   20th   21st  
logging
       disk activity, Performance Monitor  
logical database design   2nd   3rd   4th   5th   6th   7th   8th  
logical datatype
       bit  
logical operators
       icons
               Query Analyzer   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th   13th   14th   15th  
login  
Login Properties dialog box   2nd  
logins
       Enterprise Manager   2nd  
       Enterprise Manager and   2nd   3rd   4th  
       linked servers  
       local
               mapping to linked server   2nd   3rd   4th   5th   6th   7th   8th   9th   10th  
       security   2nd   3rd  
               standard logins  
       stored procedures   2nd  
       T-SQL   2nd   3rd   4th  
logs
       error logs
               Agent  
       transaction log
                backups   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       transaction log backups  
       transaction logs   2nd   3rd  
               backups   2nd  
       transactions   2nd   3rd   4th  
               checkpoints   2nd   3rd   4th   5th   6th   7th   8th  
        write-ahead logging  
long-running transactions   2nd   3rd   4th   5th   6th  
Lotus Notes, Mail setup   2nd   3rd   4th   5th   6th  
LSN (Log Sequence Number)  
LSN (log sequence number)  
LUW (Logical Unit of Work)