[pluralsight-training.net] SQL Server - Myths and Misconceptions

Creation Time	Sept. 18, 2023, 7:35 a.m.
Last Access Time	Sept. 26, 2024, 1:42 a.m.
File Size	401.2 MB
Keywords	and pluralsight-training - Server Myths SQL Misconceptions net
Total Requests	60
Total Files	113
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

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

[pluralsight-training.net] SQL Server - Myths and Misconceptions

File List

Download Torrent

Related Resources

Copyright Infringement