Download link
File List
-
1. Introduction/1. Introduction.wmv 2.36 MB
1. Introduction/2. Why is Some Information Incorrect.wmv 3.27 MB
1. Introduction/3. Why Does Incorrect Information Cause Problems.wmv 2.47 MB
1. Introduction/4. Summary.wmv 2.04 MB
1. Introduction/5. Course Structure.wmv 3.18 MB
10. High-Availability Myths and Misconceptions/1. Introduction.wmv 1.2 MB
10. High-Availability Myths and Misconceptions/10. Replication is a Valid High-Availability Choice.wmv 2.16 MB
10. High-Availability Myths and Misconceptions/2. Database Snapshot Size.wmv 3.54 MB
10. High-Availability Myths and Misconceptions/3. Database Snapshot Efficiency.wmv 2.83 MB
10. High-Availability Myths and Misconceptions/4. Demo - Database Snapshot Memory Usage.wmv 10.38 MB
10. High-Availability Myths and Misconceptions/5. Database Mirroring Failure Detection.wmv 3.02 MB
10. High-Availability Myths and Misconceptions/6. Database Mirroring Failover Speed.wmv 2 MB
10. High-Availability Myths and Misconceptions/7. Failover Clustering is the Best High-Availability Technology.wmv 1.71 MB
10. High-Availability Myths and Misconceptions/8. Multiple Database Mirrors.wmv 947.38 KB
10. High-Availability Myths and Misconceptions/9. Transactions After a Failover.wmv 1.58 MB
2. Performance Myths and Misconceptions/1. Introduction.wmv 1.41 MB
2. Performance Myths and Misconceptions/10. Updating Index Key Columns.wmv 2.96 MB
2. Performance Myths and Misconceptions/11. Demo - Updating Index Key Columns.wmv 5.73 MB
2. Performance Myths and Misconceptions/12. Snapshot Isolation.wmv 3.9 MB
2. Performance Myths and Misconceptions/13. Checkpoints.wmv 1.97 MB
2. Performance Myths and Misconceptions/14. NULL Bitmap.wmv 3.77 MB
2. Performance Myths and Misconceptions/15. Tempdb Data Files.wmv 4.38 MB
2. Performance Myths and Misconceptions/16. Solid State Disk Uses.wmv 3.23 MB
2. Performance Myths and Misconceptions/17. Disk Queue Length.wmv 1.98 MB
2. Performance Myths and Misconceptions/18. Page Life Expectancy Threshold.wmv 3.47 MB
2. Performance Myths and Misconceptions/19. NUMA Effect on Page Life Expectancy.wmv 2.05 MB
2. Performance Myths and Misconceptions/2. Controlling Instant File Initialization.wmv 3.48 MB
2. Performance Myths and Misconceptions/20. CXPACKET Waits.wmv 3.74 MB
2. Performance Myths and Misconceptions/21. ASYNC_NETWORK_IO Waits.wmv 2.89 MB
2. Performance Myths and Misconceptions/22. Demo - Wait Statistics.wmv 7.28 MB
2. Performance Myths and Misconceptions/23. Overriding MAXDOP.wmv 1.89 MB
2. Performance Myths and Misconceptions/3. Demo - Enabling Instant File Initialization.wmv 6.99 MB
2. Performance Myths and Misconceptions/4. Temporary Table Abuse.wmv 3.13 MB
2. Performance Myths and Misconceptions/5. Demo - Using Temporary Tables.wmv 9.19 MB
2. Performance Myths and Misconceptions/6. Tempdb Sizing.wmv 2.61 MB
2. Performance Myths and Misconceptions/7. Data Compression.wmv 3.55 MB
2. Performance Myths and Misconceptions/8. Data File Shrinking.wmv 3.65 MB
2. Performance Myths and Misconceptions/9. Demo - Effect of Data File Shrinking.wmv 5 MB
3. Transaction Log Myths and Misconceptions/1. Introduction.wmv 1.32 MB
3. Transaction Log Myths and Misconceptions/10. Transaction Log Sizing.wmv 4.84 MB
3. Transaction Log Myths and Misconceptions/11. Log Record Removal.wmv 2.09 MB
3. Transaction Log Myths and Misconceptions/12. Log Record Movement.wmv 1.94 MB
3. Transaction Log Myths and Misconceptions/13. Using BULK_LOGGED to Reduce Log Backup Size.wmv 3.54 MB
3. Transaction Log Myths and Misconceptions/14. Demo - Log Backup Size Using BULK_LOGGED.wmv 5.31 MB
3. Transaction Log Myths and Misconceptions/15. Log Backup Size vs. Log Size.wmv 2.63 MB
3. Transaction Log Myths and Misconceptions/16. Disaster Recovery and BULK_LOGGED.wmv 2.26 MB
3. Transaction Log Myths and Misconceptions/17. Demo - Disaster Recovery and BULK_LOGGED.wmv 17.48 MB
3. Transaction Log Myths and Misconceptions/2. Log Truncation and Clearing.wmv 2.46 MB
3. Transaction Log Myths and Misconceptions/3. Transaction Log Analysis.wmv 2.6 MB
3. Transaction Log Myths and Misconceptions/4. Demo - Analyzing the Transaction Log.wmv 14.86 MB
3. Transaction Log Myths and Misconceptions/5. TRUNCATE TABLE Logging.wmv 3.76 MB
3. Transaction Log Myths and Misconceptions/6. Efficient Logging of Index Operations.wmv 2.7 MB
3. Transaction Log Myths and Misconceptions/7. Demo - Showing Efficient Logging.wmv 6.45 MB
3. Transaction Log Myths and Misconceptions/8. Multiple Log Files.wmv 2.42 MB
3. Transaction Log Myths and Misconceptions/9. Instant File Initialization.wmv 2.56 MB
4. Indexing Myths and Misconceptions/1. Introduction.wmv 1.3 MB
4. Indexing Myths and Misconceptions/2. FILLFACTOR Usage.wmv 2.7 MB
4. Indexing Myths and Misconceptions/3. Clustered Index Rebuilds.wmv 2.65 MB
4. Indexing Myths and Misconceptions/4. Nonclustered Index Choice.wmv 3.1 MB
4. Indexing Myths and Misconceptions/5. SSDs and Fragmentation.wmv 3.09 MB
4. Indexing Myths and Misconceptions/6. Removing Heap Fragmentation.wmv 2.21 MB
4. Indexing Myths and Misconceptions/7. GUIDs as a Cluster Key Choice.wmv 3.01 MB
4. Indexing Myths and Misconceptions/8. Demo - GUID Cluster Keys.wmv 8.68 MB
4. Indexing Myths and Misconceptions/9. Rebuilding Indexes and Statistics.wmv 1.78 MB
5. Locking Myths and Misconceptions/1. Introduction.wmv 991.38 KB
5. Locking Myths and Misconceptions/2. Online Index Operations and Blocking.wmv 2.98 MB
5. Locking Myths and Misconceptions/3. Demo - Locks held by Online Index Rebuild.wmv 8.06 MB
5. Locking Myths and Misconceptions/4. Backups and Blocking.wmv 2.95 MB
5. Locking Myths and Misconceptions/5. DBCC CHECKDB and Blocking.wmv 2.61 MB
5. Locking Myths and Misconceptions/6. Lock Escalation.wmv 2.74 MB
5. Locking Myths and Misconceptions/7. Demo - Lock Escalation.wmv 12.09 MB
5. Locking Myths and Misconceptions/8. Invalid Blocking and Deadlocks.wmv 2.48 MB
5. Locking Myths and Misconceptions/9. NOLOCK and READ UNCOMMITTED.wmv 2.16 MB
6. Transact-SQL Myths and Misconceptions/1. Introduction.wmv 1.03 MB
6. Transact-SQL Myths and Misconceptions/2. Nested Transactions.wmv 3.1 MB
6. Transact-SQL Myths and Misconceptions/3. Demo - Nested Transactions.wmv 5.67 MB
6. Transact-SQL Myths and Misconceptions/4. DDL Triggers.wmv 2.02 MB
6. Transact-SQL Myths and Misconceptions/5. SELECT COUNT(star).wmv 3.33 MB
6. Transact-SQL Myths and Misconceptions/6. Demo - SELECT COUNT(star).wmv 6.04 MB
6. Transact-SQL Myths and Misconceptions/7. Physical Record Location.wmv 2.97 MB
6. Transact-SQL Myths and Misconceptions/8. Demo - Physical Record Location.wmv 5.49 MB
6. Transact-SQL Myths and Misconceptions/9. Running DMVs in 80 Compatibility Mode.wmv 2.7 MB
7. Backup Myths and Misconceptions/1. Introduction.wmv 1.05 MB
7. Backup Myths and Misconceptions/10. Replacing Backups with Database Snapshots.wmv 3.41 MB
7. Backup Myths and Misconceptions/2. Concurrent Data and Log Backups.wmv 1.92 MB
7. Backup Myths and Misconceptions/3. Data Backups and Log Clearing.wmv 1.62 MB
7. Backup Myths and Misconceptions/4. Demo - When Does the Log Clear.wmv 11.82 MB
7. Backup Myths and Misconceptions/5. Backup Completion Guarantees.wmv 3.17 MB
7. Backup Myths and Misconceptions/6. Differential Backups.wmv 1.59 MB
7. Backup Myths and Misconceptions/7. Planning a Backup Strategy.wmv 2.22 MB
7. Backup Myths and Misconceptions/8. Restarting the Log Backup Chain.wmv 1.66 MB
7. Backup Myths and Misconceptions/9. Demo - Log Backup Chain.wmv 6.23 MB
8. Restore Myths and Misconceptions/1. Introduction.wmv 1.23 MB
8. Restore Myths and Misconceptions/2. Mix-and-Match Filegroups.wmv 2.72 MB
8. Restore Myths and Misconceptions/3. Demo - Filegroup Restores.wmv 7.48 MB
8. Restore Myths and Misconceptions/4. Using WITH STOPAT for Data Backups.wmv 1.87 MB
8. Restore Myths and Misconceptions/5. Restoring to Older Versions of SQL Server.wmv 3.08 MB
8. Restore Myths and Misconceptions/6. Demo - Down-level Restore.wmv 4.89 MB
8. Restore Myths and Misconceptions/7. Restoring to Non-Enterprise Editions.wmv 3.19 MB
8. Restore Myths and Misconceptions/8. 32-Bit vs. 64-Bit Compatibility.wmv 2 MB
9. Corruption Myths and Misconceptions/1. Introduction.wmv 1.33 MB
9. Corruption Myths and Misconceptions/10. Repair Can Fix Everything.wmv 2.83 MB
9. Corruption Myths and Misconceptions/11. Repairing System Databases and Tables.wmv 2.81 MB
9. Corruption Myths and Misconceptions/12. Transaction Rollbacks.wmv 2.55 MB
9. Corruption Myths and Misconceptions/13. Demo - Transaction Rollbacks.wmv 4.52 MB
9. Corruption Myths and Misconceptions/2. Detaching and Attaching a SUSPECT Database.wmv 2.77 MB
9. Corruption Myths and Misconceptions/3. Offloading Consistency Checks.wmv 2.75 MB
9. Corruption Myths and Misconceptions/4. Causing Corruption Using T-SQL.wmv 1.65 MB
9. Corruption Myths and Misconceptions/5. Enabling Page Checksums.wmv 2.59 MB
9. Corruption Myths and Misconceptions/6. DBCC CHECKDB vs. BACKUP ... WITH CHECKSUM.wmv 1.72 MB
9. Corruption Myths and Misconceptions/7. Restarting SQL Server to Fix Corruption.wmv 1.78 MB
9. Corruption Myths and Misconceptions/8. Disappearing Corruptions.wmv 3.32 MB
9. Corruption Myths and Misconceptions/9. Corruption-Free Guarantee.wmv 1.37 MB
Download Info
-
Tips
“[pluralsight-training.net] SQL Server - Myths and Misconceptions” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.