|
RAR-files |
| e-posqlssi.rar |
15,000,000 |
81F25187 |
| e-posqlssi.r00 |
15,000,000 |
C8025C03 |
| e-posqlssi.r01 |
15,000,000 |
86A22CBC |
| e-posqlssi.r02 |
15,000,000 |
25851203 |
| e-posqlssi.r03 |
15,000,000 |
76432761 |
| e-posqlssi.r04 |
15,000,000 |
4658FC01 |
| e-posqlssi.r05 |
15,000,000 |
80B48E99 |
| e-posqlssi.r06 |
15,000,000 |
CB7004F9 |
| e-posqlssi.r07 |
15,000,000 |
6BEFD2F8 |
| e-posqlssi.r08 |
15,000,000 |
12E7A755 |
| e-posqlssi.r09 |
15,000,000 |
2DE88A1B |
| e-posqlssi.r10 |
15,000,000 |
ABAE6156 |
| e-posqlssi.r11 |
15,000,000 |
B608318F |
| e-posqlssi.r12 |
15,000,000 |
16537F7D |
| e-posqlssi.r13 |
15,000,000 |
BE32A3D7 |
| e-posqlssi.r14 |
15,000,000 |
D476AD0E |
| e-posqlssi.r15 |
2,369,530 |
CCF2772D |
|
| Total size: |
242,369,530 |
|
|
| Archived
files |
|
1. Course Overview\1. Course Overview.mp4 |
2,260,117 |
3D43007F |
|
2. Overview of Index Maintenance\1. Course Introduction.mp4 |
4,728,286 |
E6BC1DA1 |
|
3. Review Index Usage and Identify Potential Missing Indexes\01. Why Do You Have Missing Indexes.mp4 |
5,851,700 |
05846DF9 |
|
3. Review Index Usage and Identify Potential Missing Indexes\02. The Missing Index DMVs.mp4 |
6,555,218 |
BAF6DD69 |
|
3. Review Index Usage and Identify Potential Missing Indexes\03. Demo. Identifying Missing Indexes via the DMVs.mp4 |
12,996,082 |
E0BE0970 |
|
3. Review Index Usage and Identify Potential Missing Indexes\04. Database Tuning Advisor.mp4 |
8,688,891 |
C0ACB95C |
|
3. Review Index Usage and Identify Potential Missing Indexes\05. Demo. Database Tuning Advisor.mp4 |
42,503,733 |
31A25079 |
|
3. Review Index Usage and Identify Potential Missing Indexes\06. Summary of Missing Indexes.mp4 |
876,471 |
C2BC5806 |
|
3. Review Index Usage and Identify Potential Missing Indexes\07. Identfying Unused Indexes.mp4 |
6,652,329 |
9576154A |
|
3. Review Index Usage and Identify Potential Missing Indexes\08. Demo. Using the Index Usage DMV.mp4 |
12,870,509 |
D1236928 |
|
3. Review Index Usage and Identify Potential Missing Indexes\09. Identifying Redundant Indexes.mp4 |
2,528,857 |
9E5FD584 |
|
3. Review Index Usage and Identify Potential Missing Indexes\10. Demo. Redundant Indexes.mp4 |
16,097,415 |
C7984730 |
|
3. Review Index Usage and Identify Potential Missing Indexes\11. Summary.mp4 |
1,347,439 |
08520E4E |
|
4. Maintaining Rowstore Indexes\1. Introduction and Cause of Index Fragmentation.mp4 |
5,225,293 |
5A5C8685 |
|
4. Maintaining Rowstore Indexes\2. Effects of Fragmentation.mp4 |
3,755,657 |
86152F0E |
|
4. Maintaining Rowstore Indexes\3. Identifying Fragmented Indexes.mp4 |
2,452,943 |
D6C89A1E |
|
4. Maintaining Rowstore Indexes\4. Demo. Identifying Fragmented Indexes.mp4 |
12,717,805 |
BE7154DF |
|
4. Maintaining Rowstore Indexes\5. Fixing Fragmentation.mp4 |
12,626,623 |
9533530C |
|
4. Maintaining Rowstore Indexes\6. Demo. Fixing Fragmentation.mp4 |
11,323,258 |
8E725275 |
|
4. Maintaining Rowstore Indexes\7. Summary.mp4 |
583,498 |
11158E53 |
|
5. Maintaining Columnstore Indexes\1. Introduction and Why Columnstore Indexes Need Maintenance.mp4 |
7,425,972 |
8593E023 |
|
5. Maintaining Columnstore Indexes\2. Demo. Identifying Columnstore Indexes in Need of Maintenance.mp4 |
7,346,474 |
B0BDD6CC |
|
5. Maintaining Columnstore Indexes\3. Effects of Rebuild and Reorganize on Columnstore Indexes.mp4 |
3,177,054 |
2D453A07 |
|
5. Maintaining Columnstore Indexes\4. Demo. Maintaining Columnstore Indexes.mp4 |
8,939,512 |
3D06E685 |
|
5. Maintaining Columnstore Indexes\5. Summary.mp4 |
600,919 |
022935E3 |
|
6. Maintaining Statistics\1. Introduction and What Are Statistics.mp4 |
5,378,474 |
00270F5B |
|
6. Maintaining Statistics\2. Demo. Reading Statistics and Their Effects on the Execution Plan.mp4 |
21,009,459 |
E9BC8436 |
|
6. Maintaining Statistics\3. How Statistics Get Updated.mp4 |
6,526,831 |
5BBDFCE9 |
|
6. Maintaining Statistics\4. Demo. Updating Statistics.mp4 |
8,417,669 |
96AF75ED |
|
6. Maintaining Statistics\5. Summary.mp4 |
4,801,399 |
829058D8 |
|
7. Summary and Further Reading\1. Course Summary.mp4 |
10,725,105 |
54D07E21 |
|
7. Summary and Further Reading\2. Further Reading and Additional Courses.mp4 |
4,428,343 |
3B827F7A |
|
Exercise Files\02\overview-of-index-maintenance-slides.pdf |
345,748 |
CF92AB74 |
|
Exercise Files\03\demos\MissingIndexes.sql |
566 |
6A9BFC62 |
|
Exercise Files\03\demos\RedundantIndexes.sql |
625 |
BDD57D60 |
|
Exercise Files\03\demos\UnusedIndexes.sql |
448 |
5D0DA434 |
|
Exercise Files\03\review-index-usage-and-identify-potential-missing-indexes-slides.pdf |
900,007 |
EA4311D0 |
|
Exercise Files\04\demos\IndexPhysicalStats.sql |
490 |
1BAEB833 |
|
Exercise Files\04\maintaining-rowstore-indexes-slides.pdf |
508,883 |
5AC2CEB7 |
|
Exercise Files\05\demos\Columnstores with deleted rows.sql |
731 |
FB200D45 |
|
Exercise Files\05\demos\OpenRowgroups.sql |
614 |
D6BE0FE8 |
|
Exercise Files\05\maintaining-columnstore-indexes-slides.pdf |
386,191 |
1ED7AE76 |
|
Exercise Files\06\demos\CauseIncorrectStatistics.sql |
269 |
BA8F6A70 |
|
Exercise Files\06\demos\QuerySensitivetoBadStatistics.sql |
1,503 |
8A1F40EF |
|
Exercise Files\06\demos\ShowStatistics.sql |
76 |
E3A7921C |
|
Exercise Files\06\maintaining-statistics-slides.pdf |
3,962,683 |
9FA9C6EC |
|
Exercise Files\07\summary-and-further-reading-slides.pdf |
403,192 |
4403DE5E |
|
Exercise Files\IST.bak |
50,491,392 |
30B1114F |
|
Exercise Files\03\demos |
0 |
00000000 |
|
Exercise Files\04\demos |
0 |
00000000 |
|
Exercise Files\05\demos |
0 |
00000000 |
|
Exercise Files\06\demos |
0 |
00000000 |
|
Exercise Files\02 |
0 |
00000000 |
|
Exercise Files\03 |
0 |
00000000 |
|
Exercise Files\04 |
0 |
00000000 |
|
Exercise Files\05 |
0 |
00000000 |
|
Exercise Files\06 |
0 |
00000000 |
|
Exercise Files\07 |
0 |
00000000 |
|
1. Course Overview |
0 |
00000000 |
|
2. Overview of Index Maintenance |
0 |
00000000 |
|
3. Review Index Usage and Identify Potential Missing Indexes |
0 |
00000000 |
|
4. Maintaining Rowstore Indexes |
0 |
00000000 |
|
5. Maintaining Columnstore Indexes |
0 |
00000000 |
|
6. Maintaining Statistics |
0 |
00000000 |
|
7. Summary and Further Reading |
0 |
00000000 |
|
Exercise Files |
0 |
00000000 |
|
| Total size: |
318,422,753 |
|
|
