SQL-Server-Myths-and-Mis-4OZ7
1. Introduction1. Introduction.wmv2.36MB
1. Introduction2. Why is Some Infortion Incorrect.wmv3.27MB
1. Introduction3. Why Does Incorrect Infortion Cause Problems.wmv2.47MB
1. Introduction4. Sumry.wmv2.04MB
1. Introduction5. Course Structure.wmv3.18MB
10. High-ailability Myths and Misconceptions1. Introduction.wmv1.20MB
10. High-ailability Myths and Misconceptions10. Replication is a Valid High-Availability Choice.wmv2.16MB
10. High-ailability Myths and Misconceptions2. Database Snapshot Size.wmv3.54MB
10. High-ailability Myths and Misconceptions3. Database Snapshot Efficiency.wmv2.83MB
10. High-ailability Myths and Misconceptions4. Demo - Database Snapshot Memory Usage.wmv10.38MB
10. High-ailability Myths and Misconceptions5. Database Mirroring Failure Detection.wmv3.02MB
10. High-ailability Myths and Misconceptions6. Database Mirroring Failover Speed.wmv2.00MB
10. High-ailability Myths and Misconceptions7. Failover Clustering is the Best High-Availability Technology.wmv1.71MB
10. High-ailability Myths and Misconceptions8. Multiple Database Mirrors.wmv947.38KB
10. High-ailability Myths and Misconceptions9. Transactions After a Failover.wmv1.58MB
2. Perfornce Myths and Misconceptions1. Introduction.wmv1.41MB
2. Perfornce Myths and Misconceptions10. Updating Index Key Columns.wmv2.96MB
2. Perfornce Myths and Misconceptions11. Demo - Updating Index Key Columns.wmv5.73MB
2. Perfornce Myths and Misconceptions12. Snapshot Isolation.wmv3.90MB
2. Perfornce Myths and Misconceptions13. Checkpoints.wmv1.97MB
2. Perfornce Myths and Misconceptions14. NULL Bitmap.wmv3.77MB
2. Perfornce Myths and Misconceptions15. Tempdb Data Files.wmv4.38MB
2. Perfornce Myths and Misconceptions16. Solid State Disk Uses.wmv3.23MB
2. Perfornce Myths and Misconceptions17. Disk Queue Length.wmv1.98MB
2. Perfornce Myths and Misconceptions18. Page Life Expectancy Threshold.wmv3.47MB
2. Perfornce Myths and Misconceptions19. NUMA Effect on Page Life Expectancy.wmv2.05MB
2. Perfornce Myths and Misconceptions2. Controlling Instant File Initialization.wmv3.48MB
2. Perfornce Myths and Misconceptions20. CXPACKET Waits.wmv3.74MB
2. Perfornce Myths and Misconceptions21. ASYNC_NETWORK_IO Waits.wmv2.89MB
2. Perfornce Myths and Misconceptions22. Demo - Wait Statistics.wmv7.28MB
2. Perfornce Myths and Misconceptions23. Overriding MAXDOP.wmv1.89MB
2. Perfornce Myths and Misconceptions3. Demo - Enabling Instant File Initialization.wmv6.99MB
2. Perfornce Myths and Misconceptions4. Temporary Table Abuse.wmv3.13MB
2. Perfornce Myths and Misconceptions5. Demo - Using Temporary Tables.wmv9.19MB
2. Perfornce Myths and Misconceptions6. Tempdb Sizing.wmv2.61MB
2. Perfornce Myths and Misconceptions7. Data Compression.wmv3.55MB
2. Perfornce Myths and Misconceptions8. Data File Shrinking.wmv3.65MB
2. Perfornce Myths and Misconceptions9. Demo - Effect of Data File Shrinking.wmv5.00MB
3. Transaction Log Myths and Misconceptions1. Introduction.wmv1.32MB
3. Transaction Log Myths and Misconceptions10. Transaction Log Sizing.wmv4.84MB
3. Transaction Log Myths and Misconceptions11. Log Record Removal.wmv2.09MB
3. Transaction Log Myths and Misconceptions12. Log Record Movement.wmv1.94MB
3. Transaction Log Myths and Misconceptions13. Using BULK_LOGGED to Reduce Log Backup Size.wmv3.54MB
3. Transaction Log Myths and Misconceptions14. Demo - Log Backup Size Using BULK_LOGGED.wmv5.31MB
3. Transaction Log Myths and Misconceptions15. Log Backup Size vs. Log Size.wmv2.63MB
3. Transaction Log Myths and Misconceptions16. Disaster Recovery and BULK_LOGGED.wmv2.26MB
3. Transaction Log Myths and Misconceptions17. Demo - Disaster Recovery and BULK_LOGGED.wmv17.48MB
3. Transaction Log Myths and Misconceptions2. Log Truncation and Clearing.wmv2.46MB
3. Transaction Log Myths and Misconceptions3. Transaction Log Analysis.wmv2.60MB
3. Transaction Log Myths and Misconceptions4. Demo - Analyzing the Transaction Log.wmv14.86MB
3. Transaction Log Myths and Misconceptions5. TRUNCATE TABLE Logging.wmv3.76MB
3. Transaction Log Myths and Misconceptions6. Efficient Logging of Index Operations.wmv2.70MB
3. Transaction Log Myths and Misconceptions7. Demo - Showing Efficient Logging.wmv6.45MB
3. Transaction Log Myths and Misconceptions8. Multiple Log Files.wmv2.42MB
3. Transaction Log Myths and Misconceptions9. Instant File Initialization.wmv2.56MB
4. Indexing Myths and Misconceptions1. Introduction.wmv1.30MB
4. Indexing Myths and Misconceptions2. FILLFACTOR Usage.wmv2.70MB
4. Indexing Myths and Misconceptions3. Clustered Index Rebuilds.wmv2.65MB
4. Indexing Myths and Misconceptions4. Nonclustered Index Choice.wmv3.10MB
4. Indexing Myths and Misconceptions5. SSDs and Fragmentation.wmv3.09MB
4. Indexing Myths and Misconceptions6. Removing Heap Fragmentation.wmv2.21MB
4. Indexing Myths and Misconceptions7. GUIDs as a Cluster Key Choice.wmv3.01MB
4. Indexing Myths and Misconceptions8. Demo - GUID Cluster Keys.wmv8.68MB
4. Indexing Myths and Misconceptions9. Rebuilding Indexes and Statistics.wmv1.78MB
5. Locking Myths and Misconceptions1. Introduction.wmv991.38KB
5. Locking Myths and Misconceptions2. Online Index Operations and Blocking.wmv2.98MB
5. Locking Myths and Misconceptions3. Demo - Locks held by Online Index Rebuild.wmv8.06MB
5. Locking Myths and Misconceptions4. Backups and Blocking.wmv2.95MB
5. Locking Myths and Misconceptions5. DBCC CHECKDB and Blocking.wmv2.61MB
5. Locking Myths and Misconceptions6. Lock Escalation.wmv2.74MB
5. Locking Myths and Misconceptions7. Demo - Lock Escalation.wmv12.09MB
5. Locking Myths and Misconceptions8. Invalid Blocking and Deadlocks.wmv2.48MB
5. Locking Myths and Misconceptions9. NOLOCK and READ UNCOMMITTED.wmv2.16MB
6. Transact-SQL Myths and Misconceptions1. Introduction.wmv1.03MB
6. Transact-SQL Myths and Misconceptions2. Nested Transactions.wmv3.10MB
6. Transact-SQL Myths and Misconceptions3. Demo - Nested Transactions.wmv5.67MB
6. Transact-SQL Myths and Misconceptions4. DDL Triggers.wmv2.02MB
6. Transact-SQL Myths and Misconceptions5. SELECT COUNT(star).wmv3.33MB
6. Transact-SQL Myths and Misconceptions6. Demo - SELECT COUNT(star).wmv6.04MB
6. Transact-SQL Myths and Misconceptions7. Physical Record Location.wmv2.97MB
6. Transact-SQL Myths and Misconceptions8. Demo - Physical Record Location.wmv5.49MB
6. Transact-SQL Myths and Misconceptions9. Running DMVs in 80 Compatibility Mode.wmv2.70MB
7. Backup Myths and Misconceptions1. Introduction.wmv1.05MB
7. Backup Myths and Misconceptions10. Replacing Backups with Database Snapshots.wmv3.41MB
7. Backup Myths and Misconceptions2. Concurrent Data and Log Backups.wmv1.92MB
7. Backup Myths and Misconceptions3. Data Backups and Log Clearing.wmv1.62MB
7. Backup Myths and Misconceptions4. Demo - When Does the Log Clear.wmv11.82MB
7. Backup Myths and Misconceptions5. Backup Completion Guarantees.wmv3.17MB
7. Backup Myths and Misconceptions6. Differential Backups.wmv1.59MB
7. Backup Myths and Misconceptions7. Planning a Backup Strategy.wmv2.22MB
7. Backup Myths and Misconceptions8. Restarting the Log Backup Chain.wmv1.66MB
7. Backup Myths and Misconceptions9. Demo - Log Backup Chain.wmv6.23MB
8. Restore Myths and Misconceptions1. Introduction.wmv1.23MB
8. Restore Myths and Misconceptions2. Mix-and-tch Filegroups.wmv2.72MB
8. Restore Myths and Misconceptions3. Demo - Filegroup Restores.wmv7.48MB
8. Restore Myths and Misconceptions4. Using WITH SAT for Data Backups.wmv1.87MB
8. Restore Myths and Misconceptions5. Restoring to Older Versions of SQL Server.wmv3.08MB
8. Restore Myths and Misconceptions6. Demo - Down-level Restore.wmv4.89MB
8. Restore Myths and Misconceptions7. Restoring to Non-Enterprise Editions.wmv3.19MB
8. Restore Myths and Misconceptions8. 32-Bit vs. -Bit Compatibility.wmv2.00MB
9. Corruption Myths and Misconceptions1. Introduction.wmv1.33MB
9. Corruption Myths and Misconceptions10. Repair Can Fix Everything.wmv2.83MB
9. Corruption Myths and Misconceptions11. Repairing System Databases and Tables.wmv2.81MB
9. Corruption Myths and Misconceptions12. Transaction Rollbacks.wmv2.55MB
9. Corruption Myths and Misconceptions13. Demo - Transaction Rollbacks.wmv4.52MB
9. Corruption Myths and Misconceptions2. Detaching and Attaching a SUSPECT Database.wmv2.77MB
9. Corruption Myths and Misconceptions3. Offloading Consistency Checks.wmv2.75MB
9. Corruption Myths and Misconceptions4. Causing Corruption Using T-SQL.wmv1.65MB
9. Corruption Myths and Misconceptions5. Enabling Page Checksums.wmv2.59MB
9. Corruption Myths and Misconceptions6. DBCC CHECKDB vs. BACKUP ... WITH CHECKSUM.wmv1.72MB
9. Corruption Myths and Misconceptions7. Restarting SQL Server to Fix Corruption.wmv1.78MB
9. Corruption Myths and Misconceptions8. Disappearing Corruptions.wmv3.32MB
9. Corruption Myths and Misconceptions9. Corruption-Free Guarantee.wmv1.37MB
- CreateTime2016-06-06
- UpdateTime2017-08-18
- FileTotalCount113
- TotalSize401.48MBHotTimes5ViewTimes12DMCA Report EmailmagnetLinkThunderTorrent DownBaiduYunLatest Search: 1.UMD-325 2.WNZ-292 3.DVH-426 4.HODV-20629 5.FSET-420 6.JUSD-418 7.OPDD-33 8.KRBV-179 9.TBD-016 10.ASW-115 11.JFB-015 12.REAL-412 13.MIBD-584 14.YSN-065 15.KIBD-073 16.ONSD-546 17.RKI-201 18.ONSD-501 19.DV-948 20.ONSD-472 21.ONSD-489 22.CRZ-306 23.JUSD-242 24.SBNS-029 25.BNDV-00572 26.REBD-012 27.MIBD-542 28.ONSD-573 29.SBNS-050 30.ZATD-01 31.MBD-155 32.DV-1410 33.BIB-016 34.AAJB-130 35.BOMN-048 36.JUSD-484 37.DANDY-271 38.JUKD-363 39.IBW-158 40.JKRD-18 41.TBD-028 42.KCPW-014 43.IDBD-416 44.DIV-146 45.KTDS-470 46.NFDM-284 47.KIBD-096 48.SAL-136 49.BS-22 50.PPPD-251 51.KWBD-096 52.XV-1082 53.SMT-008 54.YFE-001 55.JAPD-004 56.SDMS-392 57.LGD-046 58.EXD-036 59.STD-007 60.ARK-002 61.OYVD-104 62.GBVD-041 63.OKAS-066 64.ODV-281 65.SWF-169 66.DJNG-003 67.GST-014 68.ARMD-894 69.MARD-248 70.GESD-007 71.255 72.044 73.006 74.093 75.359 76.369 77.009 78.208 79.450 80.463 81.014 82.020 83.177 84.003 85.143 86.192 87.534 88.480 89.590 90.136 91.682 92.256 93.322 94.053 95.342 96.279 97.921 98.005 99.881 100.084 101.024 102.183 103.245 104.329 105.047 106.017 107.058 108.30 109.001 110.376 111.009 112.217 113.513 114.143 115.56231 116.024 117.018 118.1005 119.1117 120.102 121.006 122.762 123.234 124.004 125.200033 126.248 127.149 128.744 129.058 130.070 131.052 132.026 133.088 134.034 135.8712 136.329 137.622 138.956 139.097 140.237