T


Table control, using with Report Designer, 165

tables

designing with Report Wizard, 179

selecting with Query Builder, 177

Tabular reports, generating with Report Wizard, 179

TAKE OWNERSHIP permission, description of, 20

target endpoints, identifying in SQL Server Service Broker application, 136

Task* system variables, purpose in Integration Services, 196

tasks

role in DTR, 191–192

using with packages, 198–199

TCP/IP protocol, Binary Adjacent Broker as, 130–131

templates, creating UDTs with, 80–81, 83

Terminate aggregate method

description of, 86

example of, 88

Textbox control, using with Report Designer, 165

threads, managing with conversation groups, 129–130

Time Series algorithm, relationship to data mining, 238

Toolbox window

in Business Intelligence Development Studio, 34

in Report Designer, 165–166

TOP clause in T-SQL, enhancements in, 90

TOP(1) clause, using with SQL Server Service Broker application, 138

ToString UDT method, description of, 81

Trace permission feature of Profiler, description of, 45. See also permissions control

trace support, availability in Analysis Services, 221

Trace Wizard, replacement of, 45

transaction abort handling, T-SQL support for, 95–96

transaction isolation levels, support for, 61–62

transactions

and SQL Server Service Broker, 126

using with SQL Server Service Broker application, 136

transformations

managing with DTP, 189–190

using with Integrated Services, 200–201

Transparent Client Redirect feature, using with Database Mirroring, 54–55

triggers. See .NET triggers

Trustworthy Computing Initiative, goal of, 14

Try/Catch model, enhancements in, 95–96

T-SQL database objects, guidelines for use of, 96

T-SQL DDL and DML statements, integrating SQL Server Service Broker messaging with, 132–133

T-SQL enhancements

CTE (common table expressions), 90–91

DDL triggers, 93–94

DML output, 94

overview of, 90

PIVOT and UNPIVOT, 92–93

to TOP, 90

transaction abort handling, 95–96

varchar(max) data type, 95

WAITFOR command, 95

T-SQL INSERT statements, using with XML columns, 143

T-SQL query processor, support for, 14

T-SQL, relationship to CLR, 68

tuning. See Database Tuning Advisor

Type directive, using with FOR XML clauses, 151




Microsoft SQL Server 2005 New Features
Microsoft SQL Server 2005 New Features
ISBN: 0072227761
EAN: 2147483647
Year: 2005
Pages: 80
Authors: Michael Otey

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net