1356
Index
Database Engine (cont inued)
server nodes, 90
System Monitor, 911
Tuning Advisor, 11, 1033
SQL Profi ler, 925
Database Lock, 1066
Database Mail, 7, 92
Database Manager, SQL Azure,
803–804
Database Services. See SQL Server
Database Services
Database Sharding, 385–386
DATABASEPROPERTYEX(), 474
DATABASE_SNAPSHOT, 643
DataCollection, PowerShell, 783
DataColumn, 791
data-driven design, 18
data-driven subscription, 1276–
1277
DataReader, 791
SSIS Data Flow, 1178
DataRelation, 791
DataRow, 791
DataSet, 791
datasets
Report Manager, 1268
reports, 1236–1237
SSRS, fi elds, 1253
datasrc, 372
DataTable, 791, 792, 797
Data-Tier Application (DAC)
database transfer, 630–632
PowerShell, 783
DataView, 791
Date, 176
DATEADD(), 192, 1187
DateAdd(), 194
DATEDIFF(), 192
@@DateFirst, 405
DateFromParts(), 196
DateName(), 192, 193–194
DatePart(), 194
Datetime, 176
date/time
data types, 76, 175–176
scalar functions, 191–196
SNAC, 76
DateTime2(), 176
DateTimeFromParts(), 196
Datetimeoffset, 176
DateTimeOffSetFromParts(), 196
DBCC. See Database Console
Commands
DBCC CHECKALLOC(), 592
DBCC CHECKCATALOG, 589DBCC CHECKCATALOG(), 593
DBCC CHECKCONSTRAINTS(), 593
DBCC CHECKDB
database integrity, 588–590
multi-user concerns, 592
object-level validation, 592–593
performance, 592
DBCC CHECKDB WITH DATA_
PURITY, 589
DBCC CHECKDB WITH PHYSICAL_
ONLY, 573, 586
DBCC CHECKFILEGROUP(), 593
DBCC CHECKIDENT(), 593
DBCC CHECKTABLE(), 593
DBCC CLEANTABLE(), 593
DBCC dllname (FREE), 603
DBCC DROPCLEANBUFFERS, 603
DBCC FLUSHPROCINDB(DBID), 603
DBCC FREEPROCACHE, 603
DBCC FREESESSIONCACHE, 603
DBCC FREESYSTEMCACHE, 603
DBCC HELP, 586
DBCC INPUTBUFFER (SPID), 603
DBCC MEMORYSTATUS, 603
DBCC OPENTRAN, 602, 1092
DBCC OUTPUTBUFFER (SPID), 603
DBCC PINTABLE, 603
DBCC PROCACHE, 603
DBCC SHOW_STATISTICS, 597,
1011–1012
DBCC SHRINKDATABASE, 600–601
DBCC SHRINKFILE, 567, 601
DBCC SQLPERF (LOGSPACE), 599
DBCC TRACEOFF, 604
DBCC TRACEON, 604
DBCC TRACESTATUS, 604
DBCC UNPINTABLE, 603
DBCC UPDATEUSAGE, 599
DBCC USEROPTIONS, 603
DB_NAME(), 210
dbo.pTitleCase(), 201–202
dbo.systranschemas, 956
dbowner, 886
DBREINDEX, 553
db.suspect_pages, 573
DBTYPE_DBTIME2, 76
DBTYPE_DBTIMESTAMPOFFSET, 76
DDL. See data defi nition language
ddl_database_level_events, 902
ddlmin, 886
ddl_server_level_events, 902
deadlocks
Activity Monitor, 1061
automatic detection, 1064
batches, 1066commit transaction, 1063
Extended Events, 1065
isolation, 1066
minimizing, 1065
Query Editor, 1061
SQL Profi ler, 1063
transactions, 1060–1066
TRY...CATCH, 1064
Deadlock Monitor, 1064
Debug Channel, Extended Events,
941
debugging
Query Designer, 113
T-SQL, 82, 397, 409
Decimal, 175
decision trees, SSAS data mining,
1290–1291
declarative language, 111, 114, 1041
data sources, 220
DECLARE
data types, 393
output parameters, 445
variables, 393
declared referential integrity (DRI),
312
object permission, 845
Decode-SqlName, 784
DecryptByPassPhrase, 855
decryption
symmetric encryption, 858
T-SQL, 855–856
DEFAULT, 439
INSERT, 294–295
defaults
A NSI, 516–517
instances, 58
parameter values, stored
procedures, 438–439
resource pools, 1132–1133
rows, INSERT, 300
transactions
blocks, 1054–1056
locks, 1054–1056
variables, 393–394
workload groups, 1136
default full-text language,
507–508
default language, 508
DEFAULT NEWSSEQUENTIALID(),
814
Default Trace, 928–929
DefaultDrillthroughMaxRows,
1228
DefaultMeasure, 1212
DefaultMember, 1210bindex July 23, 2012 2:44 PM V1
bindex.indd 1356bindex.indd 1356 7/31/2012 10:39:57 AM7/31/2012 10:39:57 AM
http://www.it-ebooks.info