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] DAC (dedicated administrator connection) data collection Service Broker solutions Data Conversion transformation data encryption asymmetric keys key management symmetric keys 2nd 3rd 4th symmetric keys 2nd 3rd 4th data explosion data flow engine (SSIS) Data Flow task (SSIS) data flow tasks source adapters data marts data mining Association algorithm Naïve Bayes algorithm neural network algorithm sequence clustering time series algorithm Data Mining Model Training transformation Data Mining Query transformation Data Mining Wizard data source views data sparsity data types xml 2nd 3rd data warehousing ETL 2nd data-flow tasks destination adapters source adapters transformations data-oriented tasks Database Mail 2nd 3rd 4th configuring 2nd 3rd 4th monitoring 2nd Database Maintenance tasks 2nd database master keys creating encryption database mirroring 2nd 3rd benefits of 2nd 3rd configuring 2nd monitoring 2nd operation modes asynchronous mode 2nd synchronous mode 2nd pausing server instances split-brain scenario database snapshot database snapshots copy-on-write operation creating 2nd of mirrored databases recovering deleted tables 2nd 3rd sparse files 2nd Database Tuning Advisor DATE CORRELATION OPTIMIZATION option 2nd DBAs performing developer responsibilities DDL triggers DDL triggers T-SQL enhancements 2nd 3rd 4th 5th 6th 7th deadlock graphs 2nd 3rd 4th 5th 6th deadlock information, viewing Debug window (BIDS) declaring variables of xml data type decrypting data 2nd 3rd Dedicated Administrative Console feature dedicated administrator connections 2nd default schema 2nd 3rd 4th 5th defragmenting indexes DENSE RANK function DENSE RANK ranking function 2nd dependencies of assemblies viewing deprecated features 2nd Derived transformation design goals of CLR hosting in SQL Server 2005 2nd designing packages 2nd 3rd 4th 5th 6th 7th SSIS packages logging SSIS expressions SSIS Object model 2nd 3rd 4th destination adapters Developer Edition dialog dialog conversations 2nd starting 2nd terminating dialog security Dimension Processing transformation dimension-level security 2nd dimensions enhancements to Analysis Services 2005 2nd fact dimensions many-to-many member properties members multiple hierarchy dimensions reference dimensions virtual disabling Service Broker 2nd disabling SQL authenticated logins 2nd disconnected editing discontinued features 2nd Discover method (XMLA) distributing server-side processing DMVs monitoring SQLCLR activity 2nd DMVs (dynamic management views) monitoring Service Broker 2nd 3rd DRI (declarative referential integrity) actions 2nd 3rd dropping assemblies from database DSO (Decision Support Objects) 2nd DSVs (data source views) DTA 2nd versus Index Tuning Wizard DTA (Database Engine Tuning Advisor) DTA (Database Tuning Advisor) 2nd 3rd 4th 5th 6th 7th 8th 9th DTExec DTExecUI DTMF (Distributed Management Task Force) DTS (Data Transformation Services) DTS 2000 packages migrating to SSIS 2nd 3rd DTS runtime engine Dynamic AWE 2nd dynamic management objects 2nd 3rd 4th 5th 6th dynamic management views 2nd |