Đang chuẩn bị liên kết để tải về tài liệu:
Microsoft SQL Server 2008 R2 Unleashed- P249

Microsoft SQL Server 2008 R2 Unleashed- P249: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 releases.Microsoft SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 2444 traces executing 132 exporting 132 filters 130-132 importing 135-136 inserting trace data into trace tables 136-137 monitoring running traces 153-154 replaying trace data 138-140 saving 132 Profiler GUI output 134-135 to files 133 to tables 134 server-side traces defining 140-141 148-152 stopping 155-156 trace events and categories 141-147 tracked changes identifying CD 1630-CD 1633 traffic tuning guidelines 1535 @@trancount function 1001 1003 CD 1735 Transact-SQL. See T-SQL transaction isolation-level hints 1393-1395 transaction logs 393 710 716-717 backups 382 418 creating with SSMS 394 creating with T-SQL 394-395 data rows 1104 full database backups 396-397 restoring 416 419 restoring with T-SQL 407-408 Transaction.Current object CD 1861 transactional replication 16 573-575 transactions ACID properties 996 batches 1007-1009 bound connections 1039-1040 calling stored procedures from CD 1735-CD 1738 coding 1022-1023 defined 52 995 distributed transactions linked servers CD 2252-CD 2253 managing 1040 explicit transactions 997 implicit transactions 997 isolation levels 1342-1344 dirty reads 1343 lost updates 1343 nonrepeatable reads 1343 phantom reads 1343 read committed isolation 1344-1345 read committed snapshot isolation 1345-1346 read uncommitted isolation 1344 repeatable read isolation 1346 serializable read isolation 1346-1347 snapshot isolation 1347-1349 locks 1021-1022 long-running transactions 1037-1039 managed database objects developing CD 1861-CD 1863 nested transactions CD 1736 processing 997 1253 AutoCommit 997-998 explicit user-defined transactions 998-1003 1006 implicit transactions 1003-1006 stored procedures 1009-1014 transaction logging 1023-1037 transaction management AutoCommit 997-998 batches 1007-1009 bound connections 1039-1040 coding 1022-1023 distributed transactions 1040 explicit user-defined transactions 998-1006 TRUNCATEONLY option DBCC SHRINKDATABASE 2445 implicit transactions 1003-1006 locks 1021-1022 long-running transactions .