T

table data type, 38, 306–307, 607

table locks, 491

table source, 460–461

table_name|view_name|table_alias.* syntax, 457

table_name placeholder, 459

TableName, 521–523

tables, 162–172

CREATE TABLE statement, 163–170

arguments, 165–170

syntax, 163–165

creating table with Management Studio, 170

Database Diagrams, 170–172

and database integrity, 359

INSERT, UPDATE, and DELETE statements, 441

and INSERT keyword, 425

names in CREATE TABLE statement, 165–166

overview, 11, 21, 162–163

securing with GRANT, DENY, or REVOKE, 134

and tabular data, 445–450

overview, 445–446

table concepts, 447–450

target, and BULK INSERT statements, 432

temporary, 425, 436

and UPDATE statements, 437–438

table-valued functions, 134

TABLOCK argument, 434–435

tabular data, 445–486

FROM clause, 459–461

FOR clause, 469–470

COMPUTE keyword, 467–469

GROUP BY clause, 464–465

HAVING keyword, 466

JOIN keyword, 470–475

join hint, 475

overview, 470–471

types of joins, 471–475

ORDER BY clause, 466–467

overview, 445

search condition, 461–463

SQL Server table, 445–450

overview, 445–446

table concepts, 447–450

table derivatives, 450–451

UNION operator, 475–476

views, 476–486

common table expression, 482–486

indexed views, 477–479

overview, 476–477

updatable partitioned views, 479–482

WHERE keyword, 463

tabular data streams (TDS), 71–72, 81

tags, XML, 509, 511

TAN function, 318, 607

tape backup, 178, 180, 182–183

tape devices, 205

tape drive, SQL Server Backup Options page, 197

tapes, 193

target servers, 236, 243, 246

task and thread architecture, 58–59

Task Manager, 535, 540, 541–542, 554

Task Scheduler service, 274

TB (terabyte) suffix, 148–149

TCO (total cost of ownership), 5

TCP/IP, 114, 251, 276

TDS (tabular data streams), 71–72, 81

telephony systems, computer, 14–15

tempdb database, 23, 140

template files, 518–519

temporal data, 358

temporary stored procedures, 401

temporary tables, 29, 425, 436

Ten minutes loss (10) tolerance, 183

Ten minutes wait (10) restoration, 183

terabyte (TB) suffix, 148–149

Terminal Services, Cluster Service, 271

termination, process, 542

termination clauses, WITH argument, 154

text and image functions, T-SQL, 319–321

text data type, 304–305, 583, 607

Text/Image page, 39–40

text-pointer value, 321

TEXTPTR function, 321, 607

TEXTVALID function, 321, 607

TGTs (ticket granting tickets), 112

thin client/server environments, 7–8, 14

threads, 58–59, 64

Three hundred and sixty minutes loss (360) tolerance, 183

Three hundred and sixty minutes wait (360) restoration, 183

throughput, 50, 538–539

ticket granting tickets (TGTs), 112

time functions, T-SQL, 319

time-out periods, interdomain key, 113

timestamp data type, 109–110, 307–308, 426, 607

time-to-market, 9–10

tinyint data type, 581, 607

tinyint integers, 301

TO|FROM principal, 134

TO FILEGROUP argument, 153

toolbar, System Monitor, 544

toolkit, Simple Object Access Protocol, 529–530

tools, SQL Server, 82–83

TOP argument, 429, 454–456

TOP function, 608

top secret data, 102–103

TORN_PAGE_DETECTION option, database recovery, 158

total cost of ownership (TCO), 5

TPC (Transaction Processing Performance Council), 50–51

TPs (transaction processors), 498

trace flags, 535, 608

trace logs, 550

transaction architecture, 52, 60–62

transaction basis locks, 491

transaction integrity, 363

transaction isolation levels, 62,490, 493–494, 497, 499

transaction logs

backups, 188–190, 198, 233

and disaster recovery, 178–181

and filegroups, 141–142

files for database storage, 144

in mirror sessions, 245–246

overview, 45–46

transaction management, 52

transaction manager, MSDTC, 280–281

Transaction Processing Performance Council (TPC), 50–51

transaction processors (TPs), 498

transaction recovery, 181–184

transaction twilight zone, 178

transactional data, 487–530

cursors, 503–507

distributed transactions, 502–503

overview, 487

Simple Object Access Protocol, 526–530

transaction processing, 497–499

transaction types, 499–502

FOR XML clause in T-SQL, 515–518

XQuery, 513–515

transactional replication, 213–214, 217

transactions, 608

BULK INSERT statements and, 435

remote, 402

Transact-Structured Query Language. See T-SQL (Transact-Structured Query Language)

transfer methods, Copy Database Wizard, 160–161

transfer rates, disk, 553

transition integrity, 362–363

Transport Layer Security, Secure Sockets Layer, (SSL TLS), 115–116

TRIGGER_NESTLEVEL function, 608

triggers, 379–397

and BULK INSERT statements, 435

creation of, 385–389

and cursors, 505

and debugging stored procedures, 409

deferred name resolution, 391

developing, 395

examples, 390–391, 395–397

execution types, 382

first and last, 391–392

managing, 393–395

nesting, 393

nuances of, 381–382

overview, 366, 379–381

plans for, 383–385

programming, 389–390

recursion, 392

rolling back transactions, 393

SQL Server Agent, 88

TRUNCATE TABLE function, 382, 440–441, 608

truncation and transaction log backups, 190

trust, 99

trusted access, 107–110, 117–118

trustees, 104–107

trusts, 112–113

TRY function, 608

TRY…CATCH command, 567

TRY…CATCH construct, 328, 430

T-SQL (Transact-Structured Query Language), 289–329,

T-SQL;

operators, T-SQL

backup scripts, 201

basic concepts of, 290

constants, 290–293

creating SQL Server logins with, 131

cursors and transactional data, 504–507

database mirroring, 246

and database restore, 202

expressions, 294–295

flow control, 324–328

monitoring with statements in, 548–549

overview, 12–13, 64, 289–290

and stored procedures, 37, 82, 399, 406–409, 417

trigger creation, 385

variables, 309–310

tuples, 26

turnkey solutions, 12

two-phase commit processes (2PCs), 502–503

type boundaries, assemblies as, 347–348

TYPE directive, FOR XML queries, 516–517

type integrity, 361

Type members feature, CLS, 335

type mode, T-SQL FOR XML clause, 516–517

type safety, 334

TYPE_ID function, 608

TYPE_NAME function, 608

TYPEPROPERTY function, 608

types, assembly, 347–348

Types feature, CLS, 335