The LIKE predicate is used to search through character strings by specifying a search string. A LIKE search is primarily used for searches based on wildcard characters, such as the percent sign (%).
linked server
A database object that represents a particular data source and the attributes, including security and collation attributes, necessary to access the data source.
local partitioned view
A partitioned view where all member tables reside on the local instance of SQL Server.
lock
A method of ensuring concurrency. Locking enables users to temporarily "check out" an object, preventing other users from changing the object, for the purpose of ensuring consistency.
log file
A file or set of files containing a record of the modifications made in a database.