GLOSSARY

ad hoc query    A query that is executed infrequently. Ad hoc queries can sometimes be troublesome because untrained users can create queries that are inefficient, causing the server to suffer significant performance degradation.

aggregate    A group such as grouped data. For example, when aggregating data, we are grouping data. A common aggregate function is Avg (average). It looks at a group of data (an aggregate) and provides an average.

alerts, Performance    A Performance alert is an alert configured within the operating system Performance Logs and Alerts tool. Performance alerts can be configured to log an entry into the application event log, send a network message, start a performance log, or run a program. They are not directly ...

Get MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.