T | Professional SQL Server 2005 Administration (Wrox Professional Guides)

table scan, 465–467

Table Valued Functions, CLR, 288

tables

maximum size of, 5

partitioning

adding data to, 489–492

creating, 487–489, 623

definition of, 481, 623

deleting data from, 492–495

in production system, 495–496

reasons to use, 486–487

recommendations for, from DTA, 383, 496

support for, 15, 487

tail transaction-log backup, 595

target servers (TSX), 138–141

Task Manager, 344

technical support

Product Support Services (PSS), 47–49

programs supplying information for, 100–103

tempdb database

backing up, 602

capacity planning for, 381–382

configuring, 43–44

definition of, 7

features using, 380

performance considerations for, 370

placement of, 380

space required for, 66

uses of, 42–43

white paper regarding, 453

templates

SQL Profiler, 419

SSIS packages, 162–163

text data type, 10

32-bit system

memory configuration, 357–362

upgrading to 64-bit system, 72

32-bit X86

processors, 348

threads, in multi-core system, 351

/3GB setting, boot.ini file, 345, 357, 358, 393

throughput

of disk drives, 21–23

of system resources, 346

time data types, list of, 11–12

(TIME) token, 134

tinyint data type, 10, 11

token replacement, 133–136

total latency, 364

TPC-B Benchmark Kit, MS, 378

TPC (Transaction Processing Council), 351

trace flags

enabling at startup, 83

status of, displaying, 97–98

turning on or off, 97

upgrading affected by, 66

traces. See also SQL Trace

correlating with Performance Monitor log data, 428–429

creating with stored procedures, 419–424

deadlock traces, 98–100

managing with SQL Profiler, 424–431

performance of, 430–431

replaying, 418, 430

retrieving data from, 424, 425

rollover trace files, 424

server-side traces, 419–424

for SSAS, 199–201

terminology regarding, 418–419

track-to-track latency, 364

transaction log. See also log shipping

backup, 594–595

definition of, 4–5

restore, 615

Transaction Processing Council (TPC), 351

transactional replication

backup and recovery for, 606

compared to database mirroring, 585

definition of, 530

implementing, 541

transactions

ACID properties for, 594

Distributed Transaction Coordinator (DTC), 679–680

Dump Transaction statement, 64

Load Transaction statement, 64

online transaction processing (OLTP), 377–378

in Service Broker, 264

Transact-SQL (T-SQL). See also stored procedures

for backup execution, 612

CLR compared to, 275

compared to CLR, 275

creating logins using, 300

creating users with, 306

for deploying log shipping, 638

jobs executing scripts from, 106, 107

log shipping

deployment, 638

removing, 649–650

monitoring processes using, 95–97

for recovering database, 620–621

scripts in, 106, 107

for SQL Server logins, 300

for traces, 419–424

transfer time for 8

KB, 364

transmission_queue queue, 219

transport security, for Service Broker, 242–250

triggers, CLR, 287

triggers, DDL

creating, 324, 327–328

database triggers, 324–329

disabling, 328–329

enabling, 329

events monitored, list of, 325, 329

server triggers, 329–330

views of, 330

troubleshooting. See also logs; support; trace flags

for clustering, 697–699

for Database Mail, 142

for database mirroring, 577–579

for log shipping, 638–639, 641

permissions, 314

for Service Broker applications, 263–272

for SQL Server Agent, 141–143

Trustworthy Computing process, 52

Try…Catch exception handling, support for, 14

T-SQL (Transact-SQL). See also stored procedures