Pluralsight SQL Server Index Fragmentation Internals Analysis and Solutions

Pluralsight SQL Server Index Fragmentation Internals Analysis and Solutions

Name	Pluralsight - SQL Server - Index Fragmentation Internals, Analysis, and Solutions	DOWNLOAD Copy Link
Total Size	291.2 MB
Total Files	60
Hash	FF75AE7DBD4894913B2C29B69D8A6256B1E1B01F

/01. Introduction/
01_01-Introduction and Why Index Fragmentation Is Important.mp4	4.5 MB
01_02-Common Myths Around Index Fragmentation.mp4	4.8 MB
01_03-Course Structure and Module Summary.mp4	2.8 MB
/02. Index Structure and Index Uses/
02_01-Introduction.mp4	1.2 MB
02_02-Index Structure.mp4	3.7 MB
02_03-Demo Index Structure.mp4	9.7 MB
02_04-Singleton Lookup.mp4	2.6 MB
02_05-Scan.mp4	2.9 MB
02_06-Allocation Order Scan.mp4	2.5 MB
02_07-Side Note Merrygoround Scans.mp4	2.3 MB
02_08-Readahead.mp4	5.6 MB
02_09-Module Summary.mp4	1.7 MB
/03. Types of Index Fragmentation/
03_01-Introduction.mp4	1.1 MB
03_02-Fragmentation in Action.mp4	2.7 MB
03_03-Demo Fragmentation Example.mp4	9.1 MB
03_04-Logical Fragmentation Details.mp4	3.1 MB
03_05-Extent Fragmentation.mp4	5.4 MB
03_06-Low Page Density.mp4	4.1 MB
03_07-Increased Buffer Pool Usage.mp4	4.7 MB
03_08-Demo Examining Buffer Pool Usage.mp4	17.8 MB
03_09-Module Summary.mp4	1.3 MB
/04. Causes of Index Fragmentation/
04_01-Introduction.mp4	1.3 MB
04_02-Page Splits.mp4	3.6 MB
04_03-Page Split Causes.mp4	5.7 MB
04_04-Demo Page Split Causes.mp4	16.4 MB
04_05-Page Split Mechanism.mp4	5.8 MB
04_06-Demo Extra Logging From PageSplits.mp4	9.3 MB
04_07-Can DML Cause Fragmentation.mp4	2.7 MB
04_08-Module Summary.mp4	1.4 MB
/05. Detecting Index Fragmentation/
05_01-Introduction and Page Split Types.mp4	2.2 MB
05_02-Tracking Page Splits.mp4	3.6 MB
05_03-Demo Tracking Page Splits.mp4	16.4 MB
05_04-Symptoms of Index Fragmentation.mp4	1.4 MB
05_05-sys.dm_db_index_physical_stats DMV.mp4	2.9 MB
05_06-sys.dm_db_index_physical_stats Modes.mp4	2.7 MB
05_07-Interpreting DMV Results.mp4	2.9 MB
05_08-Demo Using sys.dm_db_index_physical_stats.mp4	21.4 MB
05_09-Module Summary.mp4	1.7 MB
/06. Avoiding Index Fragmentation/
06_01-Introduction.mp4	1.3 MB
06_02-Avoiding Index Fragmentation.mp4	3.8 MB
06_03-Using Index Fill Factors.mp4	3.3 MB
06_04-Setting and Choosing a Fill Factor.mp4	4.7 MB
06_05-Demo Viewing and Setting Index Fill Factors.mp4	13.4 MB
06_06-Removing Dead Weight.mp4	2.6 MB
06_07-Using the E Startup Option.mp4	3.0 MB
06_08-Module Summary.mp4	2.2 MB
/07. Removing Index Fragmentation/
07_01-Introduction.mp4	1.1 MB
07_02-Comparing REBUILD and REORGANIZE.mp4	7.8 MB
07_03-When to Use REBUILD vs. REORGANIZE.mp4	2.0 MB
07_04-Demo REBUILD and REORGANIZE.mp4	8.6 MB
07_05-Useful Index Rebuild Options.mp4	4.0 MB
07_06-Online Index Operation Restrictions.mp4	3.0 MB
07_07-Demo Low Priority Lock Waits for Online Operations.mp4	10.4 MB
07_08-Removing Index Fragmentation.mp4	4.8 MB
07_09-Methodologies.mp4	5.5 MB
07_10-Inside Online Index REBUILD.mp4	3.1 MB
07_11-Inside REORGANIZE.mp4	3.9 MB
07_12-Module Summary.mp4	1.7 MB
07_13-Resources and Course Summary.mp4	4.5 MB
/Exercise files/
sqlserverindexfragmentationinternalsanalysissolutions.zip	1.4 MB
Total files 60