Microsoft SQL Server 2008 R2 Unleashed- P243:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 2384 facets F facets creating conditions based on 697-698 explained 689 692 table of 690-692 failover 623 combining with scale-out options 538 testing from principal to mirror 645-646 FAST n hints 1284 Feature Selection page SQL Server Installation Center 200-201 fields format files lengths CD 2157-CD 2158 terminators CD 2158-CD 2162 file backups 381 400-401 file data types bcp utility CD 2153 file growth managing for databases 729-730 File locking level SQL Server 1364 FILE option RESTORE DATABASE 406 filegroup backups 381 400-401 filegroups 713-715 controlling table placement with 1098 FILESTREAM filegroups 1100-1101 overview 1097-1100 performance and 1415-1417 FILEGROWTH 722 files 1095 .BAT files 104 configuration files upgrading with 250-251 212-216 CSV files handling in PowerShell 501-502 sending as attachments with Database Mail 440-441 data files 710 database files 711-712 file management 1096-1097 format files bcp utility CD 2153-CD 2163 log files 1096 169 primary data files 712 1095 properties 1093 saving trace output to 133 secondary data files 712 1095 transaction log files 710 716-717 FILESTREAM filegroups 1100-1101 FILESTREAM storage 207-208 759 CD 1592-CD 1593 for data columns CD 1597-CD 1599 database setup CD 1596 defined 36 enabling CD 1593-CD 1596 filestream_access_level configuration option CD 2299 fill factor configuration option CD 2299-CD 2300 fill factors indexes setting 1179-1181 tuning guidelines 1540 FILLFACTOR argument CREATE INDEX 798 FillRowMethodName parameter TVFs CD 1839 Filter icon 1311 filtered indexes 38 advantages 1195-1196 creating 1196-1198 optimizing with 1239-1241 statistics 1198-1199 filtered statistics 38 filtering articles 550-551 553-554 horizontal filtering 592 594 MDS-based filtering CD 2095-CD 2096 vertical filtering 592 594 filtering cmdlets 499-500 FTS Full-Text Search 2385 filters traces SQL Server Profiler 130-132 finding foreign key references 774 FIRE TRIGGERS 956 .
