R-U


read locks

In SQL Server, this is equal to shared locks.

replication

Process of copying data and database objects from one data source to another across a network. This is done to synchronize two databases or to maintain a remote copy of a database.

rule

A database object that can be applied to columns or alias data types to enforce domain integrity. Is deprecated and should not be used.

scalability

Used to indicate that an application can handle an increased workload to accommodate a growing number of users. Scalability is accomplished by either scaling up (by increasing the hardware capacity of the current server) or scaling out, (by increasing the number of servers).

scalar function

User-defined function in which a single data value is returned, such as a string or an integer.

schema stability lock

A table-level lock taken to assert that a table's schema cannot be changed while the lock is held.

searchable arguments

Refers to the WHERE portion of a SELECT query in which a column is compared to a variable or a constant value. The query optimizer uses the searchable argument to determine the optimal execution path.

secure sockets layer (SSL)

To secure communications across the network, SSL certificates can be registered for a socket, which is an IP address and port.

Simple Object Access Protocol (SOAP)

Designed by the World Wide Web Consortium (W3C), this transport protocol provides a standard way to send messages between applications using XML.

storage area network (SAN)protocol

This new protocol available with SQL Server 2005 allows you to cluster together multiple servers to provide high availability to your database applications.

table-valued function

User-defined function in which a table is returned as a result, as opposed to a single data value.

try

If an error occurs while within a try block, the execution control is transferred to the catch block adjacent to the try block.

unique constraint

A database object that enforces value uniqueness for one or more columns in a table. Used to enforce entity integrity.




MCITP Self-Paced Training Kit Exam 70-442  .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
MCITP Self-Paced Training Kit Exam 70-442 .Designing and Optimizing Data Access by Using Microsoft SQL Server 2005
ISBN: 073562383X
EAN: N/A
Year: 2007
Pages: 162

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net