Tag: databases

Primary key access

Access via unique index

Table access by ROWID

Full table scan

Database Engine Tuning Advisor

SQL Server Configuration Manager

Database Maintenance Plan Wizard

Database Maintenance design surface

Find the process in System Monitor and select Kill Process.

Find the process in Activity Monitor and select Kill Process.

Find the process in SQL Profiler and select Kill Process.

Find the process in SSRS and select Kill Process.

SQL cannot support object-orientation

The same query can be written in many ways, each with vastly different execution plans.

SQL syntax is too difficult for non-computer professionals to use

SQL creates excessive locks within the database

DPAPI

RSA

Any of the above

None

At least one data mart

Data that can extracted from numerous internal and external sources

Near real-time updates

All of the above.

Data stored in the various operational systems throughout the organization.

Current data intended to be the single source for all decision support systems.

Data stored in one operational system in the organization.

Data that has been selected and formatted for end-user support applications.

Data in which changes to existing records cause the previous version of the records to be eliminated

Data in which changes to existing records do not cause the previous version of the records to be eliminated

Data that are never altered or deleted once they have been added

Data that are never deleted once they have been added

Capturing all of the data contained in various operational systems

Capturing a subset of the data contained in various operational systems

Capturing all of the data contained in various decision support systems

Capturing a subset of the data contained in various decision support systems

A process to reject data from the data warehouse and to create the necessary indexes

A process to load the data in the data warehouse and to create the necessary indexes

A process to upgrade the quality of data after it is moved into a data warehouse

A process to upgrade the quality of data before it is moved into a data warehouse