589689.xyz

[] SQL Server - Myths and Misconceptions

  • 收录时间:2020-03-05 19:21:46
  • 文件大小:401MB
  • 下载次数:15
  • 最近下载:2020-12-26 00:07:28
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 3. Transaction Log Myths and Misconceptions/17. Demo - Disaster Recovery and BULK_LOGGED.wmv 17MB
  2. 3. Transaction Log Myths and Misconceptions/4. Demo - Analyzing the Transaction Log.wmv 15MB
  3. 5. Locking Myths and Misconceptions/7. Demo - Lock Escalation.wmv 12MB
  4. 7. Backup Myths and Misconceptions/4. Demo - When Does the Log Clear.wmv 12MB
  5. 10. High-Availability Myths and Misconceptions/4. Demo - Database Snapshot Memory Usage.wmv 10MB
  6. 2. Performance Myths and Misconceptions/5. Demo - Using Temporary Tables.wmv 9MB
  7. 4. Indexing Myths and Misconceptions/8. Demo - GUID Cluster Keys.wmv 9MB
  8. 5. Locking Myths and Misconceptions/3. Demo - Locks held by Online Index Rebuild.wmv 8MB
  9. 8. Restore Myths and Misconceptions/3. Demo - Filegroup Restores.wmv 7MB
  10. 2. Performance Myths and Misconceptions/22. Demo - Wait Statistics.wmv 7MB
  11. 2. Performance Myths and Misconceptions/3. Demo - Enabling Instant File Initialization.wmv 7MB
  12. 3. Transaction Log Myths and Misconceptions/7. Demo - Showing Efficient Logging.wmv 6MB
  13. 7. Backup Myths and Misconceptions/9. Demo - Log Backup Chain.wmv 6MB
  14. 6. Transact-SQL Myths and Misconceptions/6. Demo - SELECT COUNT(star).wmv 6MB
  15. 2. Performance Myths and Misconceptions/11. Demo - Updating Index Key Columns.wmv 6MB
  16. 6. Transact-SQL Myths and Misconceptions/3. Demo - Nested Transactions.wmv 6MB
  17. 6. Transact-SQL Myths and Misconceptions/8. Demo - Physical Record Location.wmv 5MB
  18. 3. Transaction Log Myths and Misconceptions/14. Demo - Log Backup Size Using BULK_LOGGED.wmv 5MB
  19. 2. Performance Myths and Misconceptions/9. Demo - Effect of Data File Shrinking.wmv 5MB
  20. 8. Restore Myths and Misconceptions/6. Demo - Down-level Restore.wmv 5MB
  21. 3. Transaction Log Myths and Misconceptions/10. Transaction Log Sizing.wmv 5MB
  22. 9. Corruption Myths and Misconceptions/13. Demo - Transaction Rollbacks.wmv 5MB
  23. 2. Performance Myths and Misconceptions/15. Tempdb Data Files.wmv 4MB
  24. 2. Performance Myths and Misconceptions/12. Snapshot Isolation.wmv 4MB
  25. 2. Performance Myths and Misconceptions/14. NULL Bitmap.wmv 4MB
  26. 3. Transaction Log Myths and Misconceptions/5. TRUNCATE TABLE Logging.wmv 4MB
  27. 2. Performance Myths and Misconceptions/20. CXPACKET Waits.wmv 4MB
  28. 2. Performance Myths and Misconceptions/8. Data File Shrinking.wmv 4MB
  29. 2. Performance Myths and Misconceptions/7. Data Compression.wmv 4MB
  30. 10. High-Availability Myths and Misconceptions/2. Database Snapshot Size.wmv 4MB
  31. 3. Transaction Log Myths and Misconceptions/13. Using BULK_LOGGED to Reduce Log Backup Size.wmv 4MB
  32. 2. Performance Myths and Misconceptions/2. Controlling Instant File Initialization.wmv 3MB
  33. 2. Performance Myths and Misconceptions/18. Page Life Expectancy Threshold.wmv 3MB
  34. 7. Backup Myths and Misconceptions/10. Replacing Backups with Database Snapshots.wmv 3MB
  35. 6. Transact-SQL Myths and Misconceptions/5. SELECT COUNT(star).wmv 3MB
  36. 9. Corruption Myths and Misconceptions/8. Disappearing Corruptions.wmv 3MB
  37. 1. Introduction/2. Why is Some Information Incorrect.wmv 3MB
  38. 2. Performance Myths and Misconceptions/16. Solid State Disk Uses.wmv 3MB
  39. 8. Restore Myths and Misconceptions/7. Restoring to Non-Enterprise Editions.wmv 3MB
  40. 1. Introduction/5. Course Structure.wmv 3MB
  41. 7. Backup Myths and Misconceptions/5. Backup Completion Guarantees.wmv 3MB
  42. 2. Performance Myths and Misconceptions/4. Temporary Table Abuse.wmv 3MB
  43. 6. Transact-SQL Myths and Misconceptions/2. Nested Transactions.wmv 3MB
  44. 4. Indexing Myths and Misconceptions/4. Nonclustered Index Choice.wmv 3MB
  45. 4. Indexing Myths and Misconceptions/5. SSDs and Fragmentation.wmv 3MB
  46. 8. Restore Myths and Misconceptions/5. Restoring to Older Versions of SQL Server.wmv 3MB
  47. 10. High-Availability Myths and Misconceptions/5. Database Mirroring Failure Detection.wmv 3MB
  48. 4. Indexing Myths and Misconceptions/7. GUIDs as a Cluster Key Choice.wmv 3MB
  49. 5. Locking Myths and Misconceptions/2. Online Index Operations and Blocking.wmv 3MB
  50. 6. Transact-SQL Myths and Misconceptions/7. Physical Record Location.wmv 3MB
  51. 2. Performance Myths and Misconceptions/10. Updating Index Key Columns.wmv 3MB
  52. 5. Locking Myths and Misconceptions/4. Backups and Blocking.wmv 3MB
  53. 2. Performance Myths and Misconceptions/21. ASYNC_NETWORK_IO Waits.wmv 3MB
  54. 9. Corruption Myths and Misconceptions/10. Repair Can Fix Everything.wmv 3MB
  55. 10. High-Availability Myths and Misconceptions/3. Database Snapshot Efficiency.wmv 3MB
  56. 9. Corruption Myths and Misconceptions/11. Repairing System Databases and Tables.wmv 3MB
  57. 9. Corruption Myths and Misconceptions/2. Detaching and Attaching a SUSPECT Database.wmv 3MB
  58. 9. Corruption Myths and Misconceptions/3. Offloading Consistency Checks.wmv 3MB
  59. 5. Locking Myths and Misconceptions/6. Lock Escalation.wmv 3MB
  60. 8. Restore Myths and Misconceptions/2. Mix-and-Match Filegroups.wmv 3MB
  61. 4. Indexing Myths and Misconceptions/2. FILLFACTOR Usage.wmv 3MB
  62. 6. Transact-SQL Myths and Misconceptions/9. Running DMVs in 80 Compatibility Mode.wmv 3MB
  63. 3. Transaction Log Myths and Misconceptions/6. Efficient Logging of Index Operations.wmv 3MB
  64. 4. Indexing Myths and Misconceptions/3. Clustered Index Rebuilds.wmv 3MB
  65. 3. Transaction Log Myths and Misconceptions/15. Log Backup Size vs. Log Size.wmv 3MB
  66. 5. Locking Myths and Misconceptions/5. DBCC CHECKDB and Blocking.wmv 3MB
  67. 2. Performance Myths and Misconceptions/6. Tempdb Sizing.wmv 3MB
  68. 3. Transaction Log Myths and Misconceptions/3. Transaction Log Analysis.wmv 3MB
  69. 9. Corruption Myths and Misconceptions/5. Enabling Page Checksums.wmv 3MB
  70. 3. Transaction Log Myths and Misconceptions/9. Instant File Initialization.wmv 3MB
  71. 9. Corruption Myths and Misconceptions/12. Transaction Rollbacks.wmv 3MB
  72. 5. Locking Myths and Misconceptions/8. Invalid Blocking and Deadlocks.wmv 2MB
  73. 1. Introduction/3. Why Does Incorrect Information Cause Problems.wmv 2MB
  74. 3. Transaction Log Myths and Misconceptions/2. Log Truncation and Clearing.wmv 2MB
  75. 3. Transaction Log Myths and Misconceptions/8. Multiple Log Files.wmv 2MB
  76. 1. Introduction/1. Introduction.wmv 2MB
  77. 3. Transaction Log Myths and Misconceptions/16. Disaster Recovery and BULK_LOGGED.wmv 2MB
  78. 7. Backup Myths and Misconceptions/7. Planning a Backup Strategy.wmv 2MB
  79. 4. Indexing Myths and Misconceptions/6. Removing Heap Fragmentation.wmv 2MB
  80. 10. High-Availability Myths and Misconceptions/10. Replication is a Valid High-Availability Choice.wmv 2MB
  81. 5. Locking Myths and Misconceptions/9. NOLOCK and READ UNCOMMITTED.wmv 2MB
  82. 3. Transaction Log Myths and Misconceptions/11. Log Record Removal.wmv 2MB
  83. 2. Performance Myths and Misconceptions/19. NUMA Effect on Page Life Expectancy.wmv 2MB
  84. 1. Introduction/4. Summary.wmv 2MB
  85. 6. Transact-SQL Myths and Misconceptions/4. DDL Triggers.wmv 2MB
  86. 10. High-Availability Myths and Misconceptions/6. Database Mirroring Failover Speed.wmv 2MB
  87. 8. Restore Myths and Misconceptions/8. 32-Bit vs. 64-Bit Compatibility.wmv 2MB
  88. 2. Performance Myths and Misconceptions/17. Disk Queue Length.wmv 2MB
  89. 2. Performance Myths and Misconceptions/13. Checkpoints.wmv 2MB
  90. 3. Transaction Log Myths and Misconceptions/12. Log Record Movement.wmv 2MB
  91. 7. Backup Myths and Misconceptions/2. Concurrent Data and Log Backups.wmv 2MB
  92. 2. Performance Myths and Misconceptions/23. Overriding MAXDOP.wmv 2MB
  93. 8. Restore Myths and Misconceptions/4. Using WITH STOPAT for Data Backups.wmv 2MB
  94. 4. Indexing Myths and Misconceptions/9. Rebuilding Indexes and Statistics.wmv 2MB
  95. 9. Corruption Myths and Misconceptions/7. Restarting SQL Server to Fix Corruption.wmv 2MB
  96. 9. Corruption Myths and Misconceptions/6. DBCC CHECKDB vs. BACKUP ... WITH CHECKSUM.wmv 2MB
  97. 10. High-Availability Myths and Misconceptions/7. Failover Clustering is the Best High-Availability Technology.wmv 2MB
  98. 7. Backup Myths and Misconceptions/8. Restarting the Log Backup Chain.wmv 2MB
  99. 9. Corruption Myths and Misconceptions/4. Causing Corruption Using T-SQL.wmv 2MB
  100. 7. Backup Myths and Misconceptions/3. Data Backups and Log Clearing.wmv 2MB
  101. 7. Backup Myths and Misconceptions/6. Differential Backups.wmv 2MB
  102. 10. High-Availability Myths and Misconceptions/9. Transactions After a Failover.wmv 2MB
  103. 2. Performance Myths and Misconceptions/1. Introduction.wmv 1MB
  104. 9. Corruption Myths and Misconceptions/9. Corruption-Free Guarantee.wmv 1MB
  105. 9. Corruption Myths and Misconceptions/1. Introduction.wmv 1MB
  106. 3. Transaction Log Myths and Misconceptions/1. Introduction.wmv 1MB
  107. 4. Indexing Myths and Misconceptions/1. Introduction.wmv 1MB
  108. 8. Restore Myths and Misconceptions/1. Introduction.wmv 1MB
  109. 10. High-Availability Myths and Misconceptions/1. Introduction.wmv 1MB
  110. 7. Backup Myths and Misconceptions/1. Introduction.wmv 1MB
  111. 6. Transact-SQL Myths and Misconceptions/1. Introduction.wmv 1MB
  112. 5. Locking Myths and Misconceptions/1. Introduction.wmv 991KB
  113. 10. High-Availability Myths and Misconceptions/8. Multiple Database Mirrors.wmv 947KB