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