"covering index"

Key Phrases: Enterprise Manager, Query Analyzer, Books Online, Meta Data Services, Visual Basic, Advanced Server, tbl address, sysobjects obj, tbl codes, verification trigger, meta data types, row count display (see more)

Key Phrases: Enterprise Manager, Query Analyzer, Books Online, Meta Data Services, Visual Basic, Advanced Server, Export Wizard, Fiber Channel, Maintenance Plan Wizard, Addr Linel, Client Network Utility, Error Check, Server Properties, Microsoft Windows, Named Pipes, Suggestion Wizard, Data Transformation Services, Index Tuning Wizard, Server Wizard, Visual Studio, Server Setup, Terminal Services, Analysis Services, Cancel Figure, Installing the Book Databases, tbl address, sysobjects obj, tbl codes, verification trigger, meta data types, row count display, from sysobjects, clustered drive resource, regression file, error log table, relational lookups, external stored procedures, virtual server name, repository engine, clustered instance, current connection properties, maximum column width, failover cluster, binary sort order, cursor result set, pad accordingly, denormalized data, global cursor, covering index, data lineage (see less)

Key Phrases: Query Analyzer, Correct Answers, Books Online, Object Browser, Lesson Summary, Enterprise Edition, updateable partitioned view, inner stored procedure, local temporary stored procedure, book shop scenario, bulk copy data, server cursors (see more)

Key Phrases: Query Analyzer, Correct Answers, Books Online, Object Browser, Lesson Summary, Enterprise Edition, Microsoft Windows, English Query, Open Table, Execute Mode, Analysis Services, Data Transformation Services, Microsoft Press, Manage Indexes, Microsoft Access, Number of Sales, Create Stored Procedure, Developer Edition, Meta Data Services, Create Database Wizard, Microsoft Excel, Server Agent, User-to-Activity Map, Microsoft Search, Selected Data, updateable partitioned view, inner stored procedure, local temporary stored procedure, book shop scenario, bulk copy data, server cursors, fixed server role, global temporary stored procedure, default result set, one application role, implicit transaction mode, second logical drive, foreign key constraint referencing, bcp command prompt utility, identifying system requirements, optimizing database performance, syscomments system table, virtual log files, data modification statements, isqlw utility, tabular result set, lazy schema validation, advanced query techniques, clustered index, lock timeout setting (see less)

Key Phrases: End Function, Meta Data Services, Analysis Services, Execute Package, Get Audit, Data Transformation Services, wrox database, data pump task, total order dollars, dynamic properties task, statement text window, valid time expression (see more)

Key Phrases: End Function, Meta Data Services, Analysis Services, Execute Package, Get Audit, Data Transformation Services, Audit Task, End Sub, Server Agent, Drop Stage Indexes, Load Dimensions, Set Job Information, Cleanse Facts, Extract Dimensions, Extract Facts, Private Sub, Script Debugger, Console Root, Data Driven Query, Hello World, Set Connection Values, Exit Sub, Object Library, Message Queuing, Window Help, wrox database, data pump task, total order dollars, dynamic properties task, statement text window, valid time expression, multiphase data, new transformation script, completion info, copy column transformation, delete global variables, send mail task, code nvarchar, row transform phase, valid date expression, msdb database, valid string expression, insert batch size, linked server, script task, custom task, calendar dimension, package transaction, contains connection information, structured storage file (see less)

Key Phrases: Server Books Online, Index Tuning Wizard, Server Profiler, Microsoft Windows, Server Enterprise Manager, Server Query Analyzer, default result sets, virtual log files, heterogeneous distributed queries, disk queuing, server cursors, sysadmin fixed server role (see more)

Key Phrases: Server Books Online, Index Tuning Wizard, Server Profiler, Microsoft Windows, Server Enterprise Manager, Server Query Analyzer, English Query, Server Agent, Index Services, Oracle Microsoft, Server Upgrade Wizard, Data Transformation Services, Visual Basic, Data Warehousing Framework, Merge Agent, Sybase Adaptive Server Anywhere, Microsoft Access, Microsoft Proxy Server, Microsoft Visual, Site Server, Microsoft Repository, Microsoft Excel, Control Panel, Exchange Server, Microsoft Management Console, default result sets, virtual log files, heterogeneous distributed queries, disk queuing, server cursors, sysadmin fixed server role, latent guaranteed consistency, msdb backup, max server memory, affinity mask option, server memory option, autoshrink feature, large object columns, orphaned sessions, autogrow feature, autogrow increment, min server memory, striped disk sets, physical hard disk drives, tempdb database, soft paging, text search catalog, freetext predicate, data warehousing process, command providers (see less)