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] early restore access 2nd editions Database mail database mail 2nd 3rd configuring 2nd 3rd 4th monitoring 2nd Emergency mode invoking 2nd ENABLE BROKER option enabling database engine features row versioning Service Broker 2nd encryption [See data encryption] ending dialog conversations endpoint-based authentication 2nd 3rd HTTP support endpoints 2nd 3rd 4th for database mirroring creating HTTP creating 2nd 3rd 4th HTTP SOAP administering 2nd 3rd Service Broker 2nd creating 2nd enhancements server instances split-brain scenario to Agent security to auditing 2nd to availability 2nd database mirroring 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th database snapshots 2nd 3rd 4th 5th 6th 7th 8th 9th dedicated administrator connection 2nd early restore access 2nd failover clustering 2nd index operations 2nd 3rd instant file initialization 2nd multi-instance support replication 2nd 3rd to FOR XML clause 2nd 3rd 4th 5th 6th to reliability ATTACH REBUILD LOG clause checksum I/O transactions, validating 2nd Emergency mode 2nd mirrored backup media 2nd 3rd 4th online restoration page restorations piecemeal restoration verifying backup and restore media 2nd enhancements to SQL Server 2005 Setup 2nd enhancements to T-SQL ALTER INDEX statement 2nd BULK rowset provider 2nd CTEs 2nd 3rd 4th 5th 6th DDL triggers 2nd 3rd 4th 5th 6th 7th DRI actions 2nd 3rd dynamic management views 2nd error handling 2nd 3rd event notifications 2nd 3rd 4th 5th 6th 7th EXCEPT operator 2nd 3rd INTERSECT operator 2nd 3rd large object data types 2nd 3rd 4th metadata views 2nd OUTPUT clause 2nd ranking functions 2nd 3rd DENSE RANK 2nd NTILE 2nd 3rd RANK 2nd ROW NUMBER relational operators APPLY 2nd PIVOT 2nd UNPIVOT 2nd server configuration options SET SHOWPLAN XML statement 2nd SET STATISTICS XML operator 2nd snapshot isolation 2nd statement-level recompilation synonyms 2nd TABLESAMPLE clause 2nd TOP operator 2nd 3rd 4th Enterprise Edition environment variables (SQLCMD) 2nd 3rd 4th EPIC (Explicitly Parallel Instruction Computing) error handling 2nd T-SQL enhancements 2nd 3rd ETL (extraction, transformation and loading 2nd Evaluation Edition event notifications T-SQL enhancements 2nd 3rd 4th 5th 6th 7th EVENTDATA() function events SSIS 2nd example of xml data type 2nd examples of exist() method 2nd of query() method 2nd of SQLCLR integration base-64 encoding and decoding 2nd catalog views 2nd saving XML data to file 2nd 3rd 4th of value() method EXCEPT operator T-SQL enhancement 2nd 3rd EXECUTE AS clause 2nd 3rd 4th 5th 6th Execute method (XMLA) Execute Process task Execute SQL task executing queries in parallel 2nd execution context execution contexts defining for modules EXECUTE AS clause 2nd 3rd 4th 5th 6th limitations of ownership chaining 2nd execution plans Executive DTS 2000 Package task Executive Package task exist() method 2nd 3rd Express Edition 2nd Express Manager expressions in XQuery queries 2nd expressions (XQuery) FLWOR expressions 2nd 3rd extended stored procedures 2nd extended system support extending virtual memory on 32-bit processors external activation extracting data from XML documents |
Категории