MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam

Index

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

LABELONLY option, RESTORE statements

Last Batch column (Activity Monitor)

latency, replication

Leave the Database Ready for Use by Rolling Back the Uncommitted Transactions option (Restore Database dialog)

LEFT JOIN statements

LIKE keyword

linked server configurations (SQL Server)

Linked Server Properties dialog

live updates

local partioned views

locks

     contention, reducing

     deadlocks

     events, trapping

     exclusive

     levels of

     shared

     sp lock stored procedures

     SQLServer:Locks object

     sys.dm exec requests dynamic managment view

     sys.dm exec sessions dynamic management view

     sys.dm tran locks dynamic management view

     system monitor lock counters

     troubleshooting

Locks event class (SQL Profiler)

Log File Viewer

     SQL Server logs

     Windows NT logs

log shipping

Login Time column (Activity Monitor)

logins

     credentials

    SQL Server

         impersonations

         security

LTRIM (left trim) function