CREATE STATISTICS command 819
Create Stored Procedure Wizard 531–35
CREATE TABLE command 211, 211, 278, 336
adding a CHECK constraint 379, 379
creating a default on a column 359
creating a PRIMARY KEY constraint 374
creating a table in a filegroup 219–20, 219
creating a UNIQUE constraint 371–72, 371, 372
horizontal partitioning 458
storing the DEFAULT definition with the table 358
CREATE TABLE permission 947
CREATE TRIGGER command 544–59, 547
CREATE UNIQUE CLUSTERED INDEX statement 464
CREATE VIEW command 437–38
accessing a subset of columns in a table 439
accessing a subset of rows 440
creating an aggregation view 444
creating partitioned views 445
joining tables into a virtual table 442
CREATE VIEW permission 947
Create View Wizard 449–51
crises 50
cross joins 301–3
Ctrl+C in OSQL 286
Crtl+L in the Query Analyzer window 962
Ctrl+Tab 566
Cube Browser dialog box 805, 806
Cube Editor window 796, 797, 802–4, 803, 804
cubes See OLAP cubes
Cubes folder 802 802
Cube Wizard 787–91
Current Activity folder 994
current configuration 923
Current Index Information screen 410, 411
current transaction log 912, 913
cursor data type 208, 284
cursor keysets 1014
cursors 514
cursor threshold parameter 1014, 1020
customers See users
Custom installation 147, 148, 151
Customize The Configuration screen 647
Customize The Properties Of The Publication screen 658, 659, 706, 706, 749, 749
customizing data types 212
custom resource types 260
cylinders 72, 73
D
data
aggregation 775 (see also aggregations)
analysis 775–77
collecting for post-capacity planning 140–43
enabling partitioning with views 452
extracting using BCP interactively 590–92, 590–91
extracting using the queryout option 592
extracting with command-line options 592
loading interactively using BCP 587–89, 587–88
loading using command-line options 589
loading using the format option 589–90
refreshing daily 57
retrieving from tables 280
space requirements for 98
spreading across multiple RAID controllers 183, 185
spreading across several disks using filegroups 182, 182
striping proportionally across all files in a filegroup 183
data_file parameter with the BCP command 584
data access methods 964, 980–81
Data And Object Transfer screen of the SQL Server Upgrade Wizard 154
Database Access tab of the SQL Server Login Properties window 933, 934
database administrator See also monitoring; tuning
backup responsibilities of 873
design and development responsibilities 45–46
documentation responsibilities 42–45
duties of 35–48
ensuring service levels 39–40
granting permissions to 953
installation and configuration by 36–37
operational jobs 38–39
security monitoring 37–38
server permissions assigned to 942
system uptime duties 40–42
tips and techniques 48–50
tracking user-defined data types 218
database applications See applications
database cache 118, 119. See also cache
database compatibility level 582
Database-Complete backup option 891
database configuration See also configuration
documentation for 43
parameters for 580
database connection pooling See connection pooling
“database consistency checker” commands. See DBCC (database consistency checks)
Database Creation screen in the SQL Server Upgrade Wizard 157–58, 158
database diagram
creating to show a foreign key relationship 376–77, 377
deleting tables with dependent tables 354
displaying 349, 350
method for creating or modifying a FOREIGN KEY constraint 390–92, 390, 392
modifying tables in Enterprise Manager 348–51
for two tables 390, 390
Database dialog box 786, 786
Database-Differential backup option 891
database executable 118
database files See data files; files
Database Integrity Check screen 828–29, 829
database I/O 134–36
Database Maintenance Plan dialog box 835
database maintenance plans See maintenance plans
Database Maintenance Plan Wizard 825–33
database maintenance tasks 164
database object permissions 943–46
database objects See also objects
defining and managing 278
determining the maximum number 817
manipulating the data contained in 279
database objects section of Object Browser 970, 971–72, 971, 972
Database option 914 914
Database Pages counter 1033–34
Database Properties window 193–94, 193, 194, 304, 305
database restore 913–22
Database Role Membership list box 941
Database Role Properties window 940, 941, 950–52, 950, 951
database roles See also roles
administering 949–55
managing 39
modifying 940, 941
specifying for users 940, 941
databases
access 514
accessing 173
administration 35
allowing the user to create 946
backups See backups
calculating the number of disk drives needed for 134
changes 874
creating 187–98, 680
deleting 200–202
designing 45–46
dropping damaged 1044
including in the upgrade process 157
laying out 64–65
loading data into 579
maintaining 9
maximum file sizes for 180
monitoring the growth of 186
offloading to reporting systems 698
overwriting the existing 916
permissions (see permissions)
processing area 118
recovering 580
recovery plan 924 (see also recovery)
replication (see replication)
restoring 922, 922
restoring in BULK_LOGGED recovery mode 913
restoring under a new data filename 916
restoring using a different name 914
saving important information about 282
selecting for publications 741, 742, 743
selecting the default 784 784
servers 3, 109, 118, 877 (see also servers)
setting to recovery mode 920
size 134, 136
space requirements for 98–99
statement permissions 946–47
structure of 179–86
tables (see tables)
users (see users)
validating the integrity of 1043
viewing 198–202
database services component of an application 66
Database Settings tab 815, 816, 884, 884, 1010, 1027, 1027
Databases folder 198 199
Databases object counters for 1035–36
database system 42
Database User Properties window 940, 941, 943–44, 943, 944
data cache 1000
data center 41
Datacenter Server 16, 17
data cleansing 57
Data Columns tab of the Trace Properties window 977, 977
data definition language See DDL (data definition language)
data file backups 885, 887
data files 179. See also files
backing up 899
configuring for I/O operations 102
configuring the I/O subsystem for 100
configuring to grow automatically 821–23
creating before starting the Upgrade Wizard 158
deleting accidentally 878
deleting and writing over with restored 921
maximum file size for 180
placing in a SQL Server system 65
protecting from disk drive failure 86
removing unused space from 827, 828
restoring 922, 922
shrinking periodically 582
sizing 65
types of 179, 180
using multiple for backup 907
Data File(s) Size (KB) counter 1035
Data Files tab 193–94, 194, 822, 822
datafiletype parameter for BULK INSERT 594
data filters 660, 660, 706, 706
Data Folder Location dialog box 778 779
data integrity 370, 437. See also integrity
data length 344
Data Link Properties window 789–90, 789
data loss 878
data manipulation language See DML (data manipulation language)
data marts 771
data mining 772, 775–76
data modeling 45
data modification events 541
data packets 1017
data placement 182
data source options in the DTS Import/Export Wizard 598
data sources
configuring 781–85
coordinating transactions from multiple 623–24
naming and describing 782, 783
selecting in the Cube Wizard 787–91
specifying for export 606
data splits 613
data striping 84. See also stripes; striping
data structures 811
data tables 219
Data tab of the Cube Editor window 804
data transformation 57
Data Transformation Services See DTS (Data Transformation Services)
Data Type Change Required dialog box 345
data types 207. See also system data types
added for SQL Server 2000 10, 284
added with SQL Server 7 284
altering for a column 338
altering in Enterprise Manager 346
compatible 328
configuring for replication 703, 704
configuring replication to use 704
converting automatically 312
defining in the model database 212
inserting compatible 495–96
selecting correct 210–11
data warehouses 771
Data Warehousing Framework 772
datetime data type 208, 338
DAY function 284
DBA See SQL Server DBA
DBCC (database consistency checks)
improvements in SQL Server 2000 9
listing of commands 1043–46
DBCC CHECKALLOC command 1043
DBCC CHECKCATALOG command 1043
DBCC CHECKCONSTRAINTS command 1043
DBCC CHECKDB command 828, 1043
DBCC CHECKFILEGROUP command 285, 1043
DBCC CHECKTABLE command 1044
DBCC CLEANTABLE command 1044
DBCC CONCURRENCYVIOLATION command 1044
DBCC DBREINDEX command 425, 1044
DBCC DBREPAIR command 1044
DBCC DROPCLEANBUFFERS command 1044
DBCC FREEPROCCACHE command 1044
DBCC HELP command 1044
DBCC INDEXDEFRAG command 1044
DBCC INPUTBUFFER command 1044
DBCC Logical Scan Bytes/seccounter 1035
DBCC MEMUSAGE command 1044
DBCC NEWALLOC command 1044
DBCC OPENTRAN command 1044
DBCC OUTPUTBUFFER command 1044
DBCC PINTABLE command 1045
DBCC PROCCACHE command 1045
DBCC ROWLOCK command 1045
DBCC SHOW_STATISTICS command 431, 1045
DBCC SHOWCONTIG command 1045
DBCC SHRINKDATABASE command 285, 1045
DBCC SHRINKFILE command 285, 828, 1045
DBCC SQLPERF command 1045
DBCC TEXTALL command 1045
DBCC TEXTALLOC command 1045
DBCC TRACEOFF command 1045
DBCC TRACEON command 1045
DBCC TRACESTATUS command 1046
DBCC UNPINTABLE command 1046
DBCC UPDATEUSAGE command 1046
DBCC USEROPTIONS command 471–72, 471–72, 1046
dbcreator role 953
DB-LIB 229, 231, 232
DB-Library Options tab 237, 238
DB lock type 996
DDL (data definition language) 278–79
deadlocks 487–88, 488, 1037
decimal data type 208
decision support systems (DSSs). See DSSs (decision support systems)
Decision Support Systems transactions. See DSS transactions
decision tree 775–76
DECLARE keyword 519, 519, 520
default databases 784 784
default definitions
assigning and modifying in Enterprise Manager 364–67
for columns 358
default filegroup 181
default file location for the creation of new databases 1027
default full-text language parameter 1015, 1020
DEFAULT keyword 341
default language parameter 1015, 1020, 1026
default level of isolation 472
default nullability 221
Default objects
binding to more than one column 364
creating 358, 361–63
creating and managing 367–70
deleting 364, 370
unbinding 363–64, 370
viewing existing 367
default passwords 169, 173–75
Default Properties window in Enterprise Manager 367–68, 368
defaults for table columns 357
changing existing 359–61
defining and modifying with Enterprise Manager 364–70
defining and modifying with T-SQL commands 358–64
dropping existing 360
printing the definition of 538
using instead of null values 357
Default Table Article Properties window 657
default values
allowing the user to create 946
in columns 497
declaring for NOT NULL columns 341
defining for columns 220
supplying for input parameters in stored procedures 518–19, 518
Define Restriction screen in the Create View Wizard 450
Define The Database File Growth screen 191
Define The Transaction Log File Growth screen 192
Delay Between Responses spin boxes 862, 863
delegated administration in Windows 2000 25
Delete_It trigger 556, 556
Delete Database message box 201
deleted table 544, 545–46
indicating rows to delete from related tables 547
querying in an UPDATE trigger 551, 551
Delete Publication button 652, 653, 699, 699, 741, 742
DELETE statement 280–81, 503–4
inserted table and 546
triggers with 541
Delete Table From Database option 354
Delete-Title trigger 548
DELETE trigger 541, 547–50, 548
deleting
backup-and-restore information for a database 201
CHECK constraint 394
databases 200–202
default objects 364, 370
dimension 803
empty tables 504
FOREIGN KEY constraints 548
rows 280, 503–4
rule objects 397
stored procedures 537
tables 278–79, 504
triggers from tables 564
triggers in Enterprise Manager 566
user-defined data types 214–17
delimiter 585
Dependencies dialog box 216, 216, 353, 354
Dependencies tab in the SQL Server Agent Properties window 168
dependent stored procedure 536
dependent trigger 536
derived cube property 803
derived tables 299
in INSERT statements 497–98
with UPDATE 502
WHERE clauses and 299
descending order 322
DESC keyword 322
DESCRIPTION option with the BACKUP statement 898
design and development responsibilities of the SQL Server DBA 45–46
design documentation 44
designers 46
Design Storage option in the Analysis Manager window 805
Design Table window 365, 366
adding columns 347, 347
altering columns in 344
creating a CHECK constraint 392–94
creating a FOREIGN KEY constraint 385–90
displaying 344, 344, 381
dropping columns 347–48
setting a PRIMARY KEY constraint in 384
Design View window 455
desktop system 6
Destination area of the SQL Server Backup dialog box 890, 891
destination database
selecting 716, 717, 722, 723, 752, 753
selecting for a push subscription 680, 681
selecting for replicated articles 674, 675
destination file 608
detail data 773
Detect Nonlogged Agent Shutdown step
in the Log Reader Agent’s Properties window 711, 711
for the Merge Agent 760, 761
developers 46
device drivers 2000, 18
device interrupts 130
Device Throughput Bytes/sec counter 1032
Dfs (distributed file system) 24
Diagram pane in the New View window 446
differential backups 9, 885, 886
performing during the week 905
restoring from 912
selecting 902, 902
setting the option for 891
using to improve backup performance 908
DIFFERENTIAL option with the BACKUP statement, 898
digital device support in Windows 2000 Professional 26
dimension
adding or removing 802
deleting 803
Dimension Manager 802
dimension tables 773–74
enhancements in SQL Server 2000 776
security-related changes to 777
selecting 793, 793
Dimension Wizard 791–96
directory replicas in Active Directory 31
dirty pages 879, 883
dirty read 470
Disable Publishing And Distribution Wizard 686, 765
DISABLE TRIGGER option with ALTER TABLE 565, 565
disaster recovery 41–42, 44–45, 922–25
Disk Administrator 137
diskadmin role 953
disk capacity 75
disk cylinders 72, 73
disk devices 892
disk drives
adding more 1005
caches contained in 80
calculating the load placed on 94–95
calculating the number needed for log files 133
calculating the number needed for the database 134–36
calculating the total needed for a system 136
characteristics of 73–75
comparing the performance of 1005
construction of 72–73
effect of utilization on 115
failure of 250
knee of the curve for 115
maximum storage capacity of 72
monitoring 1003
performance characteristics of 71–78
reliability of 84
specifications for 75–76
supporting more in external RAID systems 259–60
disk failure 876
disk heads in a disk drive 72, 73
DISK INIT command 198
Disk I/O Count Per Second counter 137
disk latency See latency
disk layout 97–101
Diskperf 129
DISKPERF command 1003
disk platters 72, 72
disk quotas 24
Disk Reads/Sec counter 1004
% Disk Read Time counter 136
disk seeks 74–75
Disk Space Available counter 137
disk space usage 40
Disk Space Used counter 137
disk stripe 84
disk striping 85, 100, 183–84
disk subsystem 131–38
% Disk Time counter 136, 142
disk usage data
analyzing 137–38
collecting 136–37
disk utilization 136
disk volume 78–79
Disk Writes/Sec counter 1004
% Disk Write Time counter 137
Display Estimated Execution Plan button 962
Dist: Delivered Cmds/sec counter 730, 1039
Dist: Delivered Trans/sec counter 730, 1039
Dist: Delivery Latency counter 730, 1039
DISTINCT argument in a SELECT clause 294, 295
DISTINCT keyword with aggregate functions 331
distributed file system (Dfs) 24
distributed partitioned views 7
defining on each member server 459
facilitating processing of 461
Distributed Transaction Coordinator. See MS DTC (Microsoft Distributed Transaction Coordinator)
Distributed Transaction Coordinator folder 632, 632
distributed transactions 623
committing as a set 626
initiating 630
invoking MS DTC to handle 629, 629
distribution 686
Distribution Agent 642
changing the schedule for 719
setting the update schedule for 680, 681, 681, 718–19, 718
distribution and publications 765
distribution database 726
enabling subscribers in 668–71
entries created by modifying the publication database 697
guidelines for configuring 727–28
relocating 648
scripting the creation of 728–29
setting the location manually 728
tables tracking replication changes and tasks 696
distribution statistics 827
distributor 726
configuring
the commit batch size on 733–34
the I/O subsystem on 688, 733, 767
on the same system as the publisher 690
to store the snapshot on the publisher 688–90
for transactional replication 727–29
defining 700
enabling 728
monitoring 729–30
performance of the I/O subsystem on 687
in the publish-and-subscribe replication metaphor 636, 637
selecting 644–45
specifying the SQL Server login ID and password for 716
tuning 730–31
DistributorSecurityMode parameter
for the Log Reader Agent 712
for the Merge Agent 762
Distributor tab of the Publisher And Distributor Properties window 668
DLLs (dynamic-link libraries) 515, 572
DML (data manipulation language) 279–81
documentation
of backups 908
categories of 43
of the hardware configuration 37, 43, 923
methods for 42
responsibilities of the SQL Server DBA 42–45
DOM (Document Object Model) 576
Domain text box in the SQL Server Login Properties window 932, 932
double quotation marks (““) 159, 307. See also quotation marks
Downloaded Changes/sec counter 1040
DownloadGenerationsPerBatch parameter for the Merge Agent 763, 763
DownloadReadChangesPerBatch parameter for the Merge Agent 763, 763
DownloadWriteChangesPerBatch parameter for the Merge Agent 763, 763
downtime 41
DRI column in the Database User Properties window 944, 944
driver certification in Windows 2000, 18
Drop All option in the Drop Objects dialog box 397
DROP DATABASE command 201, 1044
DROP DEFAULT statement 364
DROP_EXISTING clause with CREATE INDEX 416, 1044
dropping
clustered indexes 424
columns 342, 347–48
databases 1044
defaults 360
GetUnitPrice stored procedure 537
indexes 827
nonclustered indexes 425
PRIMARY KEY constraint 375, 375
Print-Update trigger 564, 564
procedures 352, 537
ROWGUIDCOL property 340
stored procedures 352, 516, 516
tables 278–79, 352–54, 504
triggers 564, 564
views 352, 453–56
Drop Objects dialog box 215, 215, 353, 353, 454, 454, 527, 527
DROP PROCEDURE command 352, 537
DROP TABLE command 278–79, 352, 504
DROP TRIGGER statement 564, 564
DROP VIEW command 352, 456
DSSs (decision support systems) 57
designing with large data block sizes 110
selecting a larger block size 120
DSS transactions 110–11
DTS (Data Transformation Services) 579, 596, 772
DTC Client Support See MS DTC (Microsoft Distributed Transaction Coordinator)
DTS Export Wizard 605–11
DTS Import Wizard 596–605
DTS package 603
DUMP statement 285
duplicate values 371–73
durability of transactions 472
durable messages 622
Dynamically Configure SQL Server Memory option 1009
dynamic configuration options 813–17
dynamic-link libraries See DLLs (dynamic-link libraries)
dynamic memory management 809–12
dynamic queue administration 622
dynamic volume management in Windows 2000 24
E
ease-of-use features in Windows 2000 20–22
e-commerce applications 626–28
Edit Job Schedule dialog box 667, 667
Edit Job Step dialog box 711–12, 711, 761–62, 761
Edit Recurring Job Schedule dialog box 828, 829, 850, 851
changing the Distribution Agent schedule 719
configuring a recurring schedule 724, 754
displaying 844
invoking 667
scheduling recurring backups 893, 894
scheduling snapshot jobs 663, 664
Edit Schedule dialog box 893, 893
Edit Stored Procedure Properties window 534
Edit Stored Procedure SQL dialog box 535
efficient SQL Server query 959
EFS (encrypting file system) 19
Eject Tape After Backup option 894, 895
Eject Tapes After Restoring Each Backup check box 916, 917
Elapsed Time counter 141
elevator sorting 82–83
ELSE clause 504, 505–6
e-mail messages 845, 865
empty table 504
Enable Constraint For INSERT And UPDATE check box 393, 393
Enable Constraint For Replication check box 392–93
enabled protocols 236
Enable New Subscriber dialog box 669, 669
Enable Publication Databases screen 649
Enable Publishers screen 648, 649
Enable Relationship For INSERT And UPDATE check box 389
Enable Relationship For Replication check box 388
Enable Subscribers screen 650, 650
ENABLE TRIGGER option with ALTER TABLE 565
encrypting file system (EFS) 19
encryption of passwords 935
END keyword 511
end users See users
English Query 772
enhancements in SQL Server 2000 777
installing 779–80
Enterprise Edition of SQL Server 62, 62
Enterprise Manager 40, 168, 993–98
affinity mask 1008
authentication mode 930–31
automatic file growth 822–23
backup
managing 895–96
performing a 890–95
backup devices 888
configuration options 813–14 814
configuration parameters
modifying 1007
setting 1013, 1021
constraints 381–94
database diagram 348–51
database information 198–200
databases
creating 193–95
deleting 200–201
database tables 343 343
defaults 364–70
default system administrator password 169, 173–75
Design Table window 381
distributor 728
event alert 859–63
expanded Current Activity in 994, 994
indexes 409–15
job history 854–55
jobs
creating 839–46
managing 853–54
lightweight pooling 1008
Management folder 175, 175
max server memory 1009
memory allocation parameters 812
Microsoft Distributed Transaction Coordinator 176–77
min server memory 1009
object permissions 943–44
operator 866–67
performance condition alert 863–64
recovery interval parameter
changing 884
configuring 1010
replication 683–86
replication agents 642
restore 913–18
roles 950–52
Rule objects 395–97
Select Wizard dialog box 188, 188
server groups 169, 170
servers
accessing 169, 173
linking 461–64
registering 169, 170–72
SQL Server Agent 175–76 176
SQL Server log 857
SQL Server logins 932–34
SQL Server services 168–77 169
statement permissions 947 948
stored procedures
assigning permissions for 529–30
creating 526–30
editing 530
managing permissions on 530
Support Services folder 177–78, 178
table management compared to T-SQL 335
tables
creating 223–27
dropping 353–54
modifying 343–51
triggers
creating 560–61
managing 566
T-SQL scripts 195
user-defined data types
creating 213–14, 213
deleting 214–16
users 940–41
views
altering and dropping 453–55
creating 446–49
Enter Transact-SQL Statement screen 850
equality and nonequality operators 306
err_file parameter with the BCP command 584
“Error 15180. Cannot drop...” message 216
Error Details option
for Merge Agent 758, 759
for replication agents 685
error file 589
error log file, closing and starting a new one, 282
error log in SQLServerAgent 868–71, 869, 870
error log messages 869, 870
error message 859
Error Message Contains This Text text box in the New Alert Properties window 862
error number 860, 860
errors
monitoring on a network 245
searching for specific 860, 861
error text 862–63, 862
ESCAPE keyword 311
Estimated Cost information 964
Estimated CPU Cost information 964
Estimated Execution Plan 429–30, 429, 430
Estimated Execution Plan pane 962–64, 963
access method displayed in 966, 967
aggregate operation shown in 969
join operation shown in 968
stored procedure shown in 970
Estimated I/O Cost information 964
Estimated Number Of Executes information 964
Estimated Row Count information 964
Estimated Row Size information 964
Estimated Subtree Cost information 964
Ethernet 230, 242–43
even parity 89
Event Alert Definition area 860, 860
event alerts 859–63
event logs 38, 619, 620
event messages 857–59
Event Processor 254
events 856
changing the logging status of 857
including or excluding from tracing 978, 978
severity level of 857
tracing 11, 977, 977
Events tab of the Trace Properties window 977, 977
Event Viewer services in Component Services 619, 620
exclusive lock mode 485
exclusive OR (XOR) operation in RAID 5 90
EXECUTE keyword with stored procedures 517
execute permissions
assigning for stored procedures 529–30
granting on stored procedures 537
Execute Query button 289, 961
EXECUTE statement with a stored procedure name to insert rows of data 498
Executing Package screen in the DTS Import/Export Wizard 604, 604, 610, 611
execution plans 964
cost of 959
determining for queries 817
displaying estimated 429
optimizing 979–80, 1006
viewing in the query optimizer 962–70
Exhaustive Data Integrity Verification check box 154
EXISTS keyword 316
EXPIREDATE option with the BACKUP statement 898
explicit mode 473–78
explicit transactions 473
committing 475
defining 474
nesting 476
scalability and 68
exponential growth 113–14, 114
Export Wizard in DTS 605–11
expressions 306
extended memory support in SQL Server 2000 6–7
extended stored procedures 515
Extensible Markup Language See XML
Extent Deallocations/sec counter 1031
extents 184
Extents Allocated/sec counter 1031
external failures 250
external RAID subsystem 257, 258–60, 258
external RAID system 80, 81
EXT lock type 996
F
fact tables 773
failback in MSCS 251
Failed Auto-Params/sec counter 1040
failed login attempts 931
failover 268
failover capacity 265
failover-clustering administration 7–8
Failover Clustering screen 270, 271
failover sites 45
fail-safe operator 865
failure See hardware, failures; system failures
FALSE value 307
FAST n hint 984
Fast Path for ASPs 28
FastRowCount parameter for the Merge Agent 763, 763
fatal hardware errors 861
fault tolerance 84–85
providing 124
of RAID 79
in a SAN 82
fault tolerance equipment 124
fault-tolerant environment 924
fault-tolerant RAID levels 86, 88, 91
“fault tolerant 250–51
faulty components 1005
federation of database servers 457, 457
fiber mode scheduling 1015
fibers 1008
Fibre Channel systems 255
field_term parameter 585
fieldterminator parameter for BULK INSERT 594
FILE_NAME function 284
File And Filegroup backup option 891
file format 598–99 599
filegroup backups 885, 886
FILEGROUP keyword with CREATE DATABASE 197
filegroups 180–84
controlling data placement 181, 182
creating tables in 218–20
developing a strategy for the use of 184–85
returning the names and attributes of 282
spreading data across several disks 182, 182
types of 180–81
Filegroups Or Files option 914, 914, 915, 915
File Growth area in a database’s Properties window 822
FILEGROWTH keyword with CREATE DATABASE 197, 198
file ID 284
FILE option with RESTORE 920
file or filegroups restore 919
files See also data files
configuring to grow automatically 821–23
in databases 179–80
developing a strategy for the use of 184–85
returning the physical names and attributes of 282
shrinking 828, 1045
file striping 183
file system cache 258. See also cache
fill factor 417
avoiding page splits 416–18
specifying for an index 417
specifying in Create Index Wizard 412, 413
value of 417–18
fill factor parameter 1015, 1020
setting in Enterprise Manager 1027, 1027
in sp_configure 417
Filter Data screen in the Create Publication Wizard 660, 660, 706, 706
| Top of Page |