Pluralsight - SQL Server - Index Fragmentation Internals, Analysis, and Solutions - TorrentBank

File Name:Pluralsight - SQL Server - Index Fragmentation Internals, Analysis, and Solutions

Create Tool:Tixati v2.12

Create Time:2015-06-13 22:03:27

File Size:277.71 MB

File Count:60

File Hash:ff75ae7dbd4894913b2c29b69d8a6256b1e1b01f

Magnet Link:

Magnet Link:

Torrent File:

01. Introduction/01_01-Introduction and Why Index Fragmentation Is Important.mp4 4.25 MB
01. Introduction/01_02-Common Myths Around Index Fragmentation.mp4 4.63 MB
01. Introduction/01_03-Course Structure and Module Summary.mp4 2.65 MB
02. Index Structure and Index Uses/02_01-Introduction.mp4 1.14 MB
02. Index Structure and Index Uses/02_02-Index Structure.mp4 3.57 MB
02. Index Structure and Index Uses/02_03-Demo Index Structure.mp4 9.23 MB
02. Index Structure and Index Uses/02_04-Singleton Lookup.mp4 2.46 MB
02. Index Structure and Index Uses/02_05-Scan.mp4 2.75 MB
02. Index Structure and Index Uses/02_06-Allocation Order Scan.mp4 2.41 MB
02. Index Structure and Index Uses/02_07-Side Note Merrygoround Scans.mp4 2.20 MB
02. Index Structure and Index Uses/02_08-Readahead.mp4 5.39 MB
02. Index Structure and Index Uses/02_09-Module Summary.mp4 1.66 MB
03. Types of Index Fragmentation/03_01-Introduction.mp4 1.05 MB
03. Types of Index Fragmentation/03_02-Fragmentation in Action.mp4 2.54 MB
03. Types of Index Fragmentation/03_03-Demo Fragmentation Example.mp4 8.69 MB
03. Types of Index Fragmentation/03_04-Logical Fragmentation Details.mp4 3.00 MB
03. Types of Index Fragmentation/03_05-Extent Fragmentation.mp4 5.19 MB
03. Types of Index Fragmentation/03_06-Low Page Density.mp4 3.93 MB
03. Types of Index Fragmentation/03_07-Increased Buffer Pool Usage.mp4 4.50 MB
03. Types of Index Fragmentation/03_08-Demo Examining Buffer Pool Usage.mp4 16.98 MB
03. Types of Index Fragmentation/03_09-Module Summary.mp4 1.20 MB
04. Causes of Index Fragmentation/04_01-Introduction.mp4 1.20 MB
04. Causes of Index Fragmentation/04_02-Page Splits.mp4 3.40 MB
04. Causes of Index Fragmentation/04_03-Page Split Causes.mp4 5.43 MB
04. Causes of Index Fragmentation/04_04-Demo Page Split Causes.mp4 15.67 MB
04. Causes of Index Fragmentation/04_05-Page Split Mechanism.mp4 5.53 MB
04. Causes of Index Fragmentation/04_06-Demo Extra Logging From PageSplits.mp4 8.82 MB
04. Causes of Index Fragmentation/04_07-Can DML Cause Fragmentation.mp4 2.61 MB
04. Causes of Index Fragmentation/04_08-Module Summary.mp4 1.30 MB
05. Detecting Index Fragmentation/05_01-Introduction and Page Split Types.mp4 2.14 MB
05. Detecting Index Fragmentation/05_02-Tracking Page Splits.mp4 3.46 MB
05. Detecting Index Fragmentation/05_03-Demo Tracking Page Splits.mp4 15.61 MB
05. Detecting Index Fragmentation/05_04-Symptoms of Index Fragmentation.mp4 1.38 MB
05. Detecting Index Fragmentation/05_05-sys.dm_db_index_physical_stats DMV.mp4 2.76 MB
05. Detecting Index Fragmentation/05_06-sys.dm_db_index_physical_stats Modes.mp4 2.56 MB
05. Detecting Index Fragmentation/05_07-Interpreting DMV Results.mp4 2.76 MB
05. Detecting Index Fragmentation/05_08-Demo Using sys.dm_db_index_physical_stats.mp4 20.38 MB
05. Detecting Index Fragmentation/05_09-Module Summary.mp4 1.64 MB
06. Avoiding Index Fragmentation/06_01-Introduction.mp4 1.28 MB
06. Avoiding Index Fragmentation/06_02-Avoiding Index Fragmentation.mp4 3.65 MB
06. Avoiding Index Fragmentation/06_03-Using Index Fill Factors.mp4 3.15 MB
06. Avoiding Index Fragmentation/06_04-Setting and Choosing a Fill Factor.mp4 4.51 MB
06. Avoiding Index Fragmentation/06_05-Demo Viewing and Setting Index Fill Factors.mp4 12.76 MB
06. Avoiding Index Fragmentation/06_06-Removing Dead Weight.mp4 2.46 MB
06. Avoiding Index Fragmentation/06_07-Using the E Startup Option.mp4 2.88 MB
06. Avoiding Index Fragmentation/06_08-Module Summary.mp4 2.09 MB
07. Removing Index Fragmentation/07_01-Introduction.mp4 1.07 MB
07. Removing Index Fragmentation/07_02-Comparing REBUILD and REORGANIZE.mp4 7.47 MB
07. Removing Index Fragmentation/07_03-When to Use REBUILD vs. REORGANIZE.mp4 1.92 MB
07. Removing Index Fragmentation/07_04-Demo REBUILD and REORGANIZE.mp4 8.19 MB
07. Removing Index Fragmentation/07_05-Useful Index Rebuild Options.mp4 3.77 MB
07. Removing Index Fragmentation/07_06-Online Index Operation Restrictions.mp4 2.83 MB
07. Removing Index Fragmentation/07_07-Demo Low Priority Lock Waits for Online Operations.mp4 9.92 MB
07. Removing Index Fragmentation/07_08-Removing Index Fragmentation.mp4 4.55 MB
07. Removing Index Fragmentation/07_09-Methodologies.mp4 5.23 MB
07. Removing Index Fragmentation/07_10-Inside Online Index REBUILD.mp4 2.97 MB
07. Removing Index Fragmentation/07_11-Inside REORGANIZE.mp4 3.69 MB
07. Removing Index Fragmentation/07_12-Module Summary.mp4 1.59 MB
07. Removing Index Fragmentation/07_13-Resources and Course Summary.mp4 4.29 MB
Exercise files/sqlserverindexfragmentationinternalsanalysissolutions.zip 1.37 MB
http://bt4.rutracker.org/ann?uk=XoGCyU1PVl
http://retracker.local/announce

TorrentBank
Copyright © 2024