Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

C#

     base-64 encoding and decoding 2nd

    stored procedures, writing

         saving XML data to file 2nd 3rd 4th

calculating

     query plan cost 2nd 3rd

Call Stackwindow (BIDS)

calling

     xml data type methods

capturing

     blocked process reports 2nd 3rd 4th 5th 6th

catalog security 2nd

catalog views 2nd 3rd 4th 5th 6th

     for Service Broker 2nd

     HTTP SOAP 2nd

certificates

     Service Broker, security

Character Map transformation

Check Database Integrity task

checksum I/O transactions

     validating 2nd

cleansing data

clients

     SSIS

CLR

     appdomains

         sys.dm clr

    integration with SQL

         benefits of 2nd

         catalog views 2nd

         challenges 2nd

         examples 2nd 3rd 4th 5th 6th

         monitoring activity 2nd 3rd

CLR (common language runtime

CLR hosting

     design goals 2nd

CLR support 2nd

     as replacement for extended stored procedures

CLS (Common Language Specification)

clusters

     active-active

code access security in .NET Framework

     permissions 2nd

color-coding of SSIS execution status

columns

    non-key

         including in indexes

     partition columns

     persisted computed columns

COM APIs

     WMI

COM objects

     WMI providers

Command window (BIDS)

command-line switches (SQLCMD) 2nd 3rd

command-prompt utilities

     DTExec

     DTExecUI

     DTUtil

commands (SQLCMD)

common caching framework

comparing

     Service Broker and BizTalk Server

     Service Broker and Indigo

     Service Broker and MSMQ

     SQL Server 2000 and SQL Server 2005 2nd

compatibility views 2nd

computed columns 2nd 3rd 4th

Conditional Split transformation

configuring

     blocked process threshold 2nd 3rd 4th 5th 6th

     database mail 2nd 3rd 4th

     database mirroring 2nd 3rd

     NUMA affinity 2nd

     tables with SQL Server Management Studio 2nd 3rd 4th

consolidation

constraints

     creating for tables 2nd 3rd 4th

     precedence constraints

constructing

     XML with XQuery, example 2nd

constructors (XQuery)

containers 2nd

     For Loop container

     Foreach Loop container

     Sequence container 2nd

     Task Host container

context switches

contracts

     creating 2nd

CONTROL permission

control-flow tasks

     Analysis Services tasks

     data-oriented tasks

     process-oriented workflow tasks

     Scripting tasks

     SQL Server tasks

controlling system metadata access 2nd 3rd

     catalog security 2nd

     catalog views 2nd

conversation groups

conversations

cooperative thread scheduling

copy-on-write operation

     database snapshots

Copy/Map transformation

cost of query plans

     calculating 2nd 3rd

counters (Perfmon)

     for Service Broker 2nd

counters, Performance Monitor 2nd

covering indexes 2nd 3rd

     creating

     versus non-key included columns

CREATE ASSEMBLY DDL statement

CREATE ENDPOINT statement (T-SQL)

CREATE LOGIN DDL statement, options 2nd

creating

     assemblies

     asymmetric keys

     contracts 2nd

     covering indexes

     database master keys

     database snapshots 2nd

    endpoints

         for database mirroring

         HTTP 2nd 3rd 4th

         Service Broker 2nd

     indexes on computed columns 2nd

     indexes on xml type columns 2nd

         primary XML indexes 2nd 3rd

         secondary XML indexes

     indexes with computed columns 2nd

     message types 2nd

     new logins

     nonclustered indexes

     plan guides 2nd 3rd 4th

     primary XML indexes 2nd 3rd

     queues 2nd

     reports 2nd

     secondary XML indexes 2nd 3rd

     services 2nd

     symmetric keys

     synonyms

     typed XML 2nd 3rd 4th 5th 6th 7th 8th

creating new databases with SQL Server Management Studio 2nd

creating schema 2nd

creating SQL authenticated logins

cryptography

     data encryption

         asymmetric keys

         symmetric keys 2nd 3rd 4th

     key management

         symmetric keys 2nd 3rd 4th

CTEs

     recursive

CTEs (common table expressions) 2nd 3rd 4th 5th 6th 7th

CTS (Common Type System)

cubes

     creating from scratch

     data sparsity

     Intellicube

    multiple fact tables

         support for on Analysis Services 2005

     perspectives

     processing