|
|
Daily scheduled tasks of a DBA, 51
Data access, security and, 90
Data Columns tab (Trace Properties screen), 256-257
Data files in a database
copying, 295
list of, 471
Data Pump Properties logging options, 131
Data type concerns of replication, 430
Data type standards, 221
Data types, 224-226
character, 226
DB2 vs. SQL Server, 314-315
fixed, 225
listing for a database, 475-476
specialized, 225
using the smallest possible, 225
Database access, restricting, 39-41
Database compatibility level
checking, 244
setting, 244
Database configuration options, 39-46
Database corruption, fixing, 189
Database environments, separation of, 52-53
Database growth
dual processors and, 219
forecasting, 160-161
monitoring, 218-219
time calculations for, 218
Database growth reports, 160-161
Database ID, determining, 236
Database Maintenance Plan Wizard, 352-360
Initialize Destination Databases screen, 356-357
Log Shipping Schedules screen, 357
Log Shipping Thresholds screen, 358
Select Databases screen, 352-353
Specify Log Shipping Destinations screen, 354-355
Specify Log Shipping Monitor Server Information screen, 359
Specify Transaction Log Backup Disk Directory screen, 353-354
Specify Transaction Log Share screen, 353-354
Database model performance tuning, 226-232
Database name, to pass light metadata, 194
Database objects
corrupted, 184
listing, 473-474
naming, 221
tying metadata to, 199
Database Properties dialog box, Offline option, 43
Database records
counting, 207-208
duplicate, 234
Database recovery models, 42-43, 275-278
Database roles, 64-66, 473
Database schema changes in replication, 449-451
Database schema example, 196-197
Database settings, optimizing, 32-33
Database Settings tab (Properties dialog box), 32
Database standards, 221-226
Database tables. See Tables
Database update, replication and, 421
databasepropertyex() function, 276
Databases
checking consistency of current, 185
configuring, 39-46, 218-221
corrupt, 187-189
distributing over instances, 340
deploying, 53-54
detaching and attaching, 293-297
finding out where space is used, 174-175
getting back online, 44
listing all columns in, 469
listing all constraints in, 470
listing all data and log files in, 471
listing all file groups in, 471
listing all foreign keys in, 471
listing all indexes installed in, 472-473
listing all installed, 462
listing of full-text catalogs in, 472
listing permissions assigned in, 474
listing users and roles in, 476-477
managing, 39-46, 218-221
manually expanding at off-peak hours, 219
multiple publications for, 443
placing in emergency mode, 188
placing in read-only mode, 246-247
placing in single user mode, 39-41
in read-only mode, 41, 246-247
rebuilding, 292-293
repairing minor problems of, 185
restoring, 54, 262, 282-293
restoring vs. attaching, 54
restoring large, 262
returning from single user mode, 40-41
separate for each client, 224
shared, 224
shrinking in production, 43
shutting down, 45
in standby mode, 360
taking offline, 43-44, 295
taking out of read-only mode, 247
version controlling, 54
DatabaseSizeReport table, creating, 160
DATETIME (Earlier Wins) Conflict Resolver, 446
DATETIME (Later Wins) Conflict Resolver, 446
DBA group, central, 51
DBA roles, 46-52
DBAs
job descriptions of, 46-52
organization of, 50-51
scheduled tasks of, 51-52
DBCC (database consistency check) commands, 184
administrative, 184-192
DBCC BUFFER, 478
DBCC BYTES, 478
DBCC CHECKDB, 185-187, 265, 477-478
DBCC CHECKIDENT, 195
DBCC CHECKTABLE, 173, 189
DBCC DBINFO, 479
DBCC DBRECOVER, 479
DBCC DBREINDEX, 249-250
DBCC DBTABLE, 479
DBCC DES, 479
DBCC DROPCLEANBUFFERS, 236, 479
DBCC ERRORLOG, 480
DBCC EXTENTINFO, 480
DBCC FLUSHPROCINDB, 236, 480
DBCC FREEPROCCACHE, 236
DBCC HELP, 477
DBCC IND, 480
DBCC INDEXDEFRAG, 252-253
DBCC INDEXDRAG, 249
DBCC LOCKOBJECTSCHEMA, 480
DBCC LOG, 481
DBCC OPENTRAN, 190-191
DBCC PAGE, 481-482
DBCC PRTIPAGE, 482
DBCC RESOURCE, 482
DBCC SETINSTANCE, 482
DBCC SHOWCONTIG, 248-252
DBCC SQLPERF, 189-190, 482-483
DBCC TAB, 483
DBCC TRACEOFF, 152
DBCC TRACEON, 152-153
DBCC TRACESTATUS, 153
DBCC UPGRADEDB, 483
DBCC USEROPTIONS, 191-192
increasing the performance of, 186-187
obtaining an entire list of, 184
undocumented, 477-483
db_datareader role, 65
db_datawriter role, 90
db_id() function, 236
DB-Library API, 166
db_name() function, 194
DB2
connecting to, 314
OLE DB provider for, 115
support for SQL Server data types, 314-315
table naming compatibility issues, 223
DB_VERSION table, creating, 57-58
Deadlock Information trace flag, 154
Debug mode, rerunning an installation in, 9
Debugging
of ActiveX Script tasks, 130
of jobs, 110
of performance problems, 257
of users' problems on the phone, 191
using Profiler for, 254, 257
Decimal data type, 225
Default administrative shared drive, 433
Default database, 79
Default directory for backups, changing, 265
Default port, changing, 79-80
Defragging indexes, 252-253
DELETE command, vs. TRUNCABLE TABLE command, 242
Delete process, tips to speed up, 242
DELETE statement, 195
Delivery Latency counters, 452
Denormalization, 227
DENY statement, 62
Denying permissions, 61
Dependencies tab (SQL Server Properties), 408
Deploying a database, 53-54
Design Table screen (Enterprise Manager), 201
Desktop Engine (MSDE), 11
Detaching a database, 293-295
Detailed Deadlock Information trace flag, 154
Deterministic restriction on Indexed Views, 335-336
Developer Edition (SQL Server), 11
Developers, granting access to, 70-71
Development DBA (job description), 47-48
Development environment, 52-53
Device configuration, with T-SQL, 271
Differential backups, 271-272
Differential database restores, 287-288
Directories, locking down, 82
Directory permissions, 82
Disable All Other Hints trace flag, 156
Disable Locking Hints trace flag, 156
Disable Parallel Checking trace flag, 155
Disable Publishing and Distribution Wizard, 437
Disaster planning and recovery, 261-297, 453-454
Disaster recovery, replication and, 453-454
Disconnecting users, 219-221
Disconnection, warning users about, 179-180
Disk dependencies, setting up, 408
DISTINCT keyword, avoiding using, 242
Distribution agents (replication), scheduling, 436-437, 448
Distribution database (for replication), 423, 435
Distributor, upgrading, 21
Domain user account, and starting SQL Server Agent, 15-16
Domains
determining, 493
preclustering considerations, 380
DOS DIR command, 179
Double-quotes, 179, 245, 319
Double-pound sign (##), before table name, 238
Downtime, measured in nines, 344
DPVs (distributed partitioned views), 12, 324-333
architecture of, 325-326
and CHECK constraints, 326, 330-331
design guidelines, 332
inserting data into, 329-331
limitations of, 332
preparing for, 326-328
querying, 331
setting up and using, 329
and text and image fields, 333
updating, 331-332
Drive configuration for clustering, best practices, 387
Drive defragmenting at Windows startup, 211
Drive formatting and naming, 385
Drive letters, renaming, 386
Drive signatures, 383
Drive suffixes, 385
Drives
preparing for clustering, 382-387
and scaling up, 341
selecting for clustering, 391
Drives available to read and write data, listing, 486
Drives and space available, listing, 490
DSNs, listing for a server, 488-489
DSS (Decision Support System), 246, 333
DTS connections, 115-116
DTS (Data Transformation Services), 49, 115
administering, 115-131
Bulk Insert task, 126
explictly executing a package in, 206
hybrid DBA need for learning, 50
inserting data from Excel using, 216
list of files to make DTS-independent, 129
multiphase data pump, 125-126
Transform Data task, 126-128
troubleshooting, 129-131
version-control system, 118
without SQL Server, 128
DTS Designer
exception file logging in, 130
Package menu in, 121
DTS methods, 205-206
DTS packages
create/view/execute rights to, 119
executing, 204
executing from within a query, 180-181
DTS properties, 206
dtsrun.exe utility, 180, 122-124
DTSRunUI.exe utility, 124
DTSTest package, 180
DTSUsers role
creating, 119-120
granting access to, 120-121
Duplicate records, 234
Dynamic disks, 383
Dynamic memory, and scaling up, 340
Dynamic stored procedures, building, 237-238
|
|