W
WHERE clause
The part of a SQL statement that specifies which records to retrieve.
wildcard characters
Characters, including underscore (_), percent (%), and brackets ([ ]), that are used with the LIKE keyword for pattern matching.
wildcard search
The use of placeholders (such as * or ?) to perform a search for data in a table or field. For example, searching the Last Name field in a database by using Smith* could result in finding all records in which the last name starts with Smith, including Smith, Smithson, Smithlin, and so forth.
Windows Authentication
One of two mechanisms for validating attempts to connect to instances of SQL Server. Users are identified by their Windows user or group when they connect. Windows Authentication is the most secure mechanism for connecting to SQL Server. See also SQL Server Authentication, trusted connection.
Windows collation
A set of rules that determine how SQL Server sorts character data. The collation is specified by name in the Windows Control Panel and in SQL Server 2000 during Setup.
write back
To update a cube cell value, member, or member property value. See also write enable.
write enable
To change a cube or dimension so that users in cube roles who have read/write access to the cube or dimension can change its data. See also write back.
write-ahead log
A transaction logging method in which the log is always written prior to the data.