Pluralsight training net SQL Server Myths and Misconceptions | D16EEB905D205C82DD33ED2DDAE2E5CF90788D66

Pluralsight training net SQL Server Myths and Misconceptions

Name	[pluralsight-training.net] SQL Server - Myths and Misconceptions	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	420.7 MB
Total Files	113
Hash	D16EEB905D205C82DD33ED2DDAE2E5CF90788D66

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