Designing and Implementing SQL Server Database Indexes
大小
268.49 MB
文件数
69
Info Hash:
2A448F15870625363E0358921EDFF6D882EA25A6
收录时间
2025-12-23 23:02:13
更新时间
2025-12-23 23:45:53
文件列表 (69)
01. Course Overview/01. Course Overview.mp4
2.89 MB
01. Course Overview/01. Course Overview.srt
2.46 KB
02. General Indexing Guidelines/01. Course Intro.mp4
7.52 MB
02. General Indexing Guidelines/01. Course Intro.srt
10.35 KB
03. Understanding Basic Index Architecture and Index Usage/01. SQL Server Index Architecture.mp4
4.7 MB
03. Understanding Basic Index Architecture and Index Usage/01. SQL Server Index Architecture.srt
4.4 KB
03. Understanding Basic Index Architecture and Index Usage/02. How SQL Server Uses Indexes.mp4
5.58 MB
03. Understanding Basic Index Architecture and Index Usage/02. How SQL Server Uses Indexes.srt
5.6 KB
03. Understanding Basic Index Architecture and Index Usage/03. How Index Operations Appear in Execution Plans.mp4
13.53 MB
03. Understanding Basic Index Architecture and Index Usage/03. How Index Operations Appear in Execution Plans.srt
7.77 KB
04. Designing Indexes to Organize Tables/01. What Is a Clustered Index-.mp4
4.47 MB
04. Designing Indexes to Organize Tables/01. What Is a Clustered Index-.srt
4.37 KB
04. Designing Indexes to Organize Tables/02. Clustered Index Guidelines Narrow.mp4
3.42 MB
04. Designing Indexes to Organize Tables/02. Clustered Index Guidelines Narrow.srt
4.22 KB
04. Designing Indexes to Organize Tables/03. Clustered Index Guidelines Unique and Unchanging.mp4
3.31 MB
04. Designing Indexes to Organize Tables/03. Clustered Index Guidelines Unique and Unchanging.srt
3.61 KB
04. Designing Indexes to Organize Tables/04. Clustered Index Guidelines Ever Increasing.mp4
3.94 MB
04. Designing Indexes to Organize Tables/04. Clustered Index Guidelines Ever Increasing.srt
3.89 KB
04. Designing Indexes to Organize Tables/05. Demo- Effects of Different Clustered Indexes.mp4
10.45 MB
04. Designing Indexes to Organize Tables/05. Demo- Effects of Different Clustered Indexes.srt
6.67 KB
04. Designing Indexes to Organize Tables/06. Clustered Index Guidelines Trade Offs and Compromise.mp4
4.31 MB
04. Designing Indexes to Organize Tables/06. Clustered Index Guidelines Trade Offs and Compromise.srt
5.35 KB
05. Designing Indexes to Improve Query Performance- Part 1/01. Introducing Nonclustered Indexes.mp4
5.97 MB
05. Designing Indexes to Improve Query Performance- Part 1/01. Introducing Nonclustered Indexes.srt
7.48 KB
05. Designing Indexes to Improve Query Performance- Part 1/02. Equality Predicates.mp4
13.68 MB
05. Designing Indexes to Improve Query Performance- Part 1/02. Equality Predicates.srt
13.32 KB
05. Designing Indexes to Improve Query Performance- Part 1/03. Inequality Predicates.mp4
10.07 MB
05. Designing Indexes to Improve Query Performance- Part 1/03. Inequality Predicates.srt
10.39 KB
05. Designing Indexes to Improve Query Performance- Part 1/04. Demo- Equality Predicates.mp4
10.05 MB
05. Designing Indexes to Improve Query Performance- Part 1/04. Demo- Equality Predicates.srt
5.51 KB
05. Designing Indexes to Improve Query Performance- Part 1/05. Demo- Inequality Predicates.mp4
11.69 MB
05. Designing Indexes to Improve Query Performance- Part 1/05. Demo- Inequality Predicates.srt
5.13 KB
05. Designing Indexes to Improve Query Performance- Part 1/06. Indexing for Predicates with ORs.mp4
3.64 MB
05. Designing Indexes to Improve Query Performance- Part 1/06. Indexing for Predicates with ORs.srt
4.06 KB
05. Designing Indexes to Improve Query Performance- Part 1/07. Demo- Predicates with ORs.mp4
11.97 MB
05. Designing Indexes to Improve Query Performance- Part 1/07. Demo- Predicates with ORs.srt
6.83 KB
06. Designing Indexes to Improve Query Performance- Part 2/01. Indexing for Joins.mp4
2.44 MB
06. Designing Indexes to Improve Query Performance- Part 2/01. Indexing for Joins.srt
3.45 KB
06. Designing Indexes to Improve Query Performance- Part 2/02. Demo- Indexing for Joins.mp4
7.42 MB
06. Designing Indexes to Improve Query Performance- Part 2/02. Demo- Indexing for Joins.srt
4.51 KB
06. Designing Indexes to Improve Query Performance- Part 2/03. Include Columns.mp4
5.03 MB
06. Designing Indexes to Improve Query Performance- Part 2/03. Include Columns.srt
5.68 KB
06. Designing Indexes to Improve Query Performance- Part 2/04. Demo- Include Columns.mp4
8.03 MB
06. Designing Indexes to Improve Query Performance- Part 2/04. Demo- Include Columns.srt
4.79 KB
06. Designing Indexes to Improve Query Performance- Part 2/05. Filtered Indexes.mp4
2.41 MB
06. Designing Indexes to Improve Query Performance- Part 2/05. Filtered Indexes.srt
3.38 KB
06. Designing Indexes to Improve Query Performance- Part 2/06. Demo- Filtered Indexes.mp4
6.88 MB
06. Designing Indexes to Improve Query Performance- Part 2/06. Demo- Filtered Indexes.srt
4.1 KB
06. Designing Indexes to Improve Query Performance- Part 2/07. Nonclustered Index Summary.mp4
2.34 MB
06. Designing Indexes to Improve Query Performance- Part 2/07. Nonclustered Index Summary.srt
3.38 KB
07. Designing Indexed Views/01. Introducing Indexed Views.mp4
2.05 MB
07. Designing Indexed Views/01. Introducing Indexed Views.srt
2.55 KB
07. Designing Indexed Views/02. Indexed View Limitations and Uses.mp4
8.07 MB
07. Designing Indexed Views/02. Indexed View Limitations and Uses.srt
8.15 KB
07. Designing Indexed Views/03. Demo- Creating and Using Indexed Views.mp4
9.59 MB
07. Designing Indexed Views/03. Demo- Creating and Using Indexed Views.srt
6.68 KB
07. Designing Indexed Views/04. Downsides of Indexed Views.mp4
2.15 MB
07. Designing Indexed Views/04. Downsides of Indexed Views.srt
2.89 KB
08. Designing Columnstore Indexes for Analytic Queries/01. Introducing Columnstore Indexes.mp4
7.03 MB
08. Designing Columnstore Indexes for Analytic Queries/01. Introducing Columnstore Indexes.srt
8.07 KB
08. Designing Columnstore Indexes for Analytic Queries/02. Demo- Creating Columnstore Indexes.mp4
12.04 MB
08. Designing Columnstore Indexes for Analytic Queries/02. Demo- Creating Columnstore Indexes.srt
7.63 KB
08. Designing Columnstore Indexes for Analytic Queries/03. Where to Use Columnstore Indexes.mp4
10.6 MB
08. Designing Columnstore Indexes for Analytic Queries/03. Where to Use Columnstore Indexes.srt
12.89 KB
08. Designing Columnstore Indexes for Analytic Queries/04. Demo- How SQL Server Uses Columnstore Indexes.mp4
18.73 MB
08. Designing Columnstore Indexes for Analytic Queries/04. Demo- How SQL Server Uses Columnstore Indexes.srt
9.85 KB
09. Summary and Further Reading/01. Course Summary and Further Reading.mp4
10.06 MB
09. Summary and Further Reading/01. Course Summary and Further Reading.srt
12.47 KB
design-build-sql-server-indexes.zip
22.23 MB