Microsoft® SQL Server® 2012 Bible

1355

Index

date/time, 76, 175–176

DECLARE, 393

large value, 78

numeric, 175

PowerShell scripts, 779

SSIS

parameters, 1184

variables, 1186

Unicode, 174

XML, 78, 340–352

methods, 353–355

stored procedures,

441–442

Data Viewers, SSIS Designer, 1177

data warehouses. See also

Management Data

Warehouse

BI, 1143–1153

consistency, 1147

data compression, 1102

data integrity, 22

dimensions, 1151–1153

ETL, 816

fact tables, 1150–1151

MDM, 22

queries, data compression,

1106–1107

Sarbanes-Oxley Act, 22

Snowfl ake Schema, 1146–1147

SSAS, 1196

Star Schema, 22, 1144–1146

DataAdapter, 791

Databars, 1253–1254

DATABASE, 901

databases

access, confi guration, 523–524

ANSI, 474

architecture, Information

Architecture Principle,

16–17

attaching, database transfer,

624–627

auto options, confi guration,

510–512

availability, 20

backup, 555–562

basics, relational database

design, 143–154

Change Tracking, 946–947

compatibility, confi guration,

524–525

confi guration, 474–475

SSMS, 475

data integrity, 18–19

design, BI, 1143–1153

detaching, database transfer,

624–627

extensibility, 18

federated, 1110

fi le size, DBCC, 598–603

fragmentation, DBCC, 594–596

integrity, DBCC CHECKDB,

588–590

maintenance, 585–613

DBCC, 586–604

jobs, 17, 28

management, 604–613

monitor ing, 612–613

management, command-line

utilities, 612

market, 4–5

master, recovery, 579–581

master key, 854

mirroring, 685–695

ADO.NET, 687

AlwaysOn Availability

Groups, 685, 686

asynchronous, 691–692

availability, 686

confi guration, 693–694

data replication, 729

disaster recovery, 686

distributed transactions, 687

encryption, 686

FILESTREAM, 687

high-performance mode,

691–692

high-safety mode, 689

instances, 688

log shipping, 685

reports, 687

SLA, 688

SSMS, 694–695

synchronous, 689

TCP/IP, 693

transactions, 687

transaction logs, 688

WSFC, 687

model, installation, 68

objectives, 17–20

operational, performance, 21

performance, 19–20

RI, 18–19, 151

scalability, 19–20

schemas, 17

security, 20

shrinking

DBCC, 600–601

Maintenance Plan, 609

snapshots, 635–645

copy-on-fi rst-write, 637

CREATE DATABASE, 639

data compression, 1099

dropping, 643

mechanics of, 636–637

Object Explorer, 640

queries, 641–643

RESTORE, 638

RESTORE DATABASE, 643–644

rolling back, 643–645

using, 638–645

Windows Explorer, 640

Azure SQL Database, 804–805

SQL Profi ler, 921

SSAS, 1226–1232

state, confi guration, 522–525

system

database transfer, 627

performance, 17

recovery, 579–582

transfer, 615–633

Copy Database Wizard,

616–619

DAC, 630–632

database attaching and

detaching, 624–627

Import and Export Wizard,

627–630

methods, 616

scripts, 620–624

system databases, 627

usability, 17

Database Audit Specifi cations, 973

Database Console Commands (DBCC)

data integrity, 593

database

fi le size, 598–603

fragmentation, 594–596

maintenance, 586–604

shrinking, 600–601

indexes, 594–598

density, 597–598

statistics, 597

transaction logs, 599

shrinking, 601–603

Database Designer, 620

Database Diagrams

foreign keys, 95–96

Object Explorer, 90

SSMS, 95–96

Database Engine, 5–6

clustered instances, 756–757

Confi guration screen, 54–55

Registered Servers, 86

Resource Governor, 1140

bindex July 23, 2012 2:44 PM V1

bindex.indd 1355bindex.indd 1355 7/31/2012 10:39:56 AM7/31/2012 10:39:56 AM

http://www.it-ebooks.info