Term
|
Definition
| how quickly hard disk can process read and write requests |
|
|
Term
|
Definition
| captures database activity for analysis |
|
|
Term
| SQL Server Database Tuning Engine |
|
Definition
| analyzes system activity and reports on index use |
|
|
Term
|
Definition
| impose physical organization on tables, sort rows in index order |
|
|
Term
|
Definition
| provide logical organization, organize data according to specified columns, do not affect physical table order |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
| used to provide access to selected data, helps to restrict access to the database |
|
|
Term
|
Definition
| set of executable statements that supports input and output parameters |
|
|
Term
|
Definition
| accepts input parameters and returns specific type of value, either scalar or table value |
|
|
Term
|
Definition
| specialized procedure associated with specific objects or events |
|
|
