[pluralsight-training.net] SQL Server - Myths and Misconceptions/1. Introduction/1. Introduction.wmv |
2.4 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/1. Introduction/2. Why is Some Information Incorrect.wmv |
3.3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/1. Introduction/3. Why Does Incorrect Information Cause Problems.wmv |
2.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/1. Introduction/4. Summary.wmv |
2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/1. Introduction/5. Course Structure.wmv |
3.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/10. High-Availability Myths and Misconceptions/1. Introduction.wmv |
1.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/10. High-Availability Myths and Misconceptions/10. Replication is a Valid High-Availability Choice.wmv |
2.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/10. High-Availability Myths and Misconceptions/2. Database Snapshot Size.wmv |
3.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/10. High-Availability Myths and Misconceptions/3. Database Snapshot Efficiency.wmv |
2.8 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/10. High-Availability Myths and Misconceptions/4. Demo - Database Snapshot Memory Usage.wmv |
10.4 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/10. High-Availability Myths and Misconceptions/5. Database Mirroring Failure Detection.wmv |
3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/10. High-Availability Myths and Misconceptions/6. Database Mirroring Failover Speed.wmv |
2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/10. High-Availability Myths and Misconceptions/7. Failover Clustering is the Best High-Availability Technology.wmv |
1.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/10. High-Availability Myths and Misconceptions/8. Multiple Database Mirrors.wmv |
947 KB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/10. High-Availability Myths and Misconceptions/9. Transactions After a Failover.wmv |
1.6 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/1. Introduction.wmv |
1.4 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/10. Updating Index Key Columns.wmv |
3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/11. Demo - Updating Index Key Columns.wmv |
5.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/12. Snapshot Isolation.wmv |
3.9 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/13. Checkpoints.wmv |
2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/14. NULL Bitmap.wmv |
3.8 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/15. Tempdb Data Files.wmv |
4.4 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/16. Solid State Disk Uses.wmv |
3.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/17. Disk Queue Length.wmv |
2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/18. Page Life Expectancy Threshold.wmv |
3.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/19. NUMA Effect on Page Life Expectancy.wmv |
2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/2. Controlling Instant File Initialization.wmv |
3.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/20. CXPACKET Waits.wmv |
3.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/21. ASYNC_NETWORK_IO Waits.wmv |
2.9 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/22. Demo - Wait Statistics.wmv |
7.3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/23. Overriding MAXDOP.wmv |
1.9 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/3. Demo - Enabling Instant File Initialization.wmv |
7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/4. Temporary Table Abuse.wmv |
3.1 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/5. Demo - Using Temporary Tables.wmv |
9.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/6. Tempdb Sizing.wmv |
2.6 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/7. Data Compression.wmv |
3.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/8. Data File Shrinking.wmv |
3.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/2. Performance Myths and Misconceptions/9. Demo - Effect of Data File Shrinking.wmv |
5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/1. Introduction.wmv |
1.3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/10. Transaction Log Sizing.wmv |
4.8 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/11. Log Record Removal.wmv |
2.1 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/12. Log Record Movement.wmv |
1.9 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/13. Using BULK_LOGGED to Reduce Log Backup Size.wmv |
3.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/14. Demo - Log Backup Size Using BULK_LOGGED.wmv |
5.3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/15. Log Backup Size vs. Log Size.wmv |
2.6 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/16. Disaster Recovery and BULK_LOGGED.wmv |
2.3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/17. Demo - Disaster Recovery and BULK_LOGGED.wmv |
17.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/2. Log Truncation and Clearing.wmv |
2.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/3. Transaction Log Analysis.wmv |
2.6 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/4. Demo - Analyzing the Transaction Log.wmv |
14.9 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/5. TRUNCATE TABLE Logging.wmv |
3.8 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/6. Efficient Logging of Index Operations.wmv |
2.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/7. Demo - Showing Efficient Logging.wmv |
6.4 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/8. Multiple Log Files.wmv |
2.4 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/3. Transaction Log Myths and Misconceptions/9. Instant File Initialization.wmv |
2.6 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/4. Indexing Myths and Misconceptions/1. Introduction.wmv |
1.3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/4. Indexing Myths and Misconceptions/2. FILLFACTOR Usage.wmv |
2.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/4. Indexing Myths and Misconceptions/3. Clustered Index Rebuilds.wmv |
2.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/4. Indexing Myths and Misconceptions/4. Nonclustered Index Choice.wmv |
3.1 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/4. Indexing Myths and Misconceptions/5. SSDs and Fragmentation.wmv |
3.1 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/4. Indexing Myths and Misconceptions/6. Removing Heap Fragmentation.wmv |
2.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/4. Indexing Myths and Misconceptions/7. GUIDs as a Cluster Key Choice.wmv |
3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/4. Indexing Myths and Misconceptions/8. Demo - GUID Cluster Keys.wmv |
8.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/4. Indexing Myths and Misconceptions/9. Rebuilding Indexes and Statistics.wmv |
1.8 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/5. Locking Myths and Misconceptions/1. Introduction.wmv |
991 KB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/5. Locking Myths and Misconceptions/2. Online Index Operations and Blocking.wmv |
3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/5. Locking Myths and Misconceptions/3. Demo - Locks held by Online Index Rebuild.wmv |
8.1 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/5. Locking Myths and Misconceptions/4. Backups and Blocking.wmv |
2.9 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/5. Locking Myths and Misconceptions/5. DBCC CHECKDB and Blocking.wmv |
2.6 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/5. Locking Myths and Misconceptions/6. Lock Escalation.wmv |
2.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/5. Locking Myths and Misconceptions/7. Demo - Lock Escalation.wmv |
12.1 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/5. Locking Myths and Misconceptions/8. Invalid Blocking and Deadlocks.wmv |
2.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/5. Locking Myths and Misconceptions/9. NOLOCK and READ UNCOMMITTED.wmv |
2.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/6. Transact-SQL Myths and Misconceptions/1. Introduction.wmv |
1 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/6. Transact-SQL Myths and Misconceptions/2. Nested Transactions.wmv |
3.1 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/6. Transact-SQL Myths and Misconceptions/3. Demo - Nested Transactions.wmv |
5.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/6. Transact-SQL Myths and Misconceptions/4. DDL Triggers.wmv |
2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/6. Transact-SQL Myths and Misconceptions/5. SELECT COUNT(star).wmv |
3.3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/6. Transact-SQL Myths and Misconceptions/6. Demo - SELECT COUNT(star).wmv |
6 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/6. Transact-SQL Myths and Misconceptions/7. Physical Record Location.wmv |
3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/6. Transact-SQL Myths and Misconceptions/8. Demo - Physical Record Location.wmv |
5.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/6. Transact-SQL Myths and Misconceptions/9. Running DMVs in 80 Compatibility Mode.wmv |
2.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/7. Backup Myths and Misconceptions/1. Introduction.wmv |
1.1 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/7. Backup Myths and Misconceptions/10. Replacing Backups with Database Snapshots.wmv |
3.4 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/7. Backup Myths and Misconceptions/2. Concurrent Data and Log Backups.wmv |
1.9 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/7. Backup Myths and Misconceptions/3. Data Backups and Log Clearing.wmv |
1.6 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/7. Backup Myths and Misconceptions/4. Demo - When Does the Log Clear.wmv |
11.8 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/7. Backup Myths and Misconceptions/5. Backup Completion Guarantees.wmv |
3.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/7. Backup Myths and Misconceptions/6. Differential Backups.wmv |
1.6 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/7. Backup Myths and Misconceptions/7. Planning a Backup Strategy.wmv |
2.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/7. Backup Myths and Misconceptions/8. Restarting the Log Backup Chain.wmv |
1.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/7. Backup Myths and Misconceptions/9. Demo - Log Backup Chain.wmv |
6.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/8. Restore Myths and Misconceptions/1. Introduction.wmv |
1.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/8. Restore Myths and Misconceptions/2. Mix-and-Match Filegroups.wmv |
2.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/8. Restore Myths and Misconceptions/3. Demo - Filegroup Restores.wmv |
7.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/8. Restore Myths and Misconceptions/4. Using WITH STOPAT for Data Backups.wmv |
1.9 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/8. Restore Myths and Misconceptions/5. Restoring to Older Versions of SQL Server.wmv |
3.1 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/8. Restore Myths and Misconceptions/6. Demo - Down-level Restore.wmv |
4.9 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/8. Restore Myths and Misconceptions/7. Restoring to Non-Enterprise Editions.wmv |
3.2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/8. Restore Myths and Misconceptions/8. 32-Bit vs. 64-Bit Compatibility.wmv |
2 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/1. Introduction.wmv |
1.3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/10. Repair Can Fix Everything.wmv |
2.8 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/11. Repairing System Databases and Tables.wmv |
2.8 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/12. Transaction Rollbacks.wmv |
2.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/13. Demo - Transaction Rollbacks.wmv |
4.5 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/2. Detaching and Attaching a SUSPECT Database.wmv |
2.8 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/3. Offloading Consistency Checks.wmv |
2.8 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/4. Causing Corruption Using T-SQL.wmv |
1.6 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/5. Enabling Page Checksums.wmv |
2.6 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/6. DBCC CHECKDB vs. BACKUP ... WITH CHECKSUM.wmv |
1.7 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/7. Restarting SQL Server to Fix Corruption.wmv |
1.8 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/8. Disappearing Corruptions.wmv |
3.3 MB |
[pluralsight-training.net] SQL Server - Myths and Misconceptions/9. Corruption Myths and Misconceptions/9. Corruption-Free Guarantee.wmv |
1.4 MB |