Skip to content

Pluralsight - Introduction to Query Tuning

Sign up to create lists
Report Pluralsight - Introduction to Query Tuning
Unverified source. This magnet is from an unverified source. The content may be unsafe or mislabeled. Proceed with caution.
Title: PluralsightGroup: NOGRPSource: Pluralsight
Info Hash
251C03ED21B26756C81DCF3469F60DD4B7835BC3
Source
Unverified
Total Size
370.21 MB
Total Files
49
Seeders
1
Leechers
0
Health
1.00
Score
2
Type
Bookware

File List

FileSize
1. Introduction/1. Introduction.wmv4.35 MB
1. Introduction/2. Query Tuning.wmv4.19 MB
1. Introduction/3. Demo.wmv7.62 MB
2. Execution Plan Basics/1. Introduction.wmv5.51 MB
2. Execution Plan Basics/10. Demo - Key Lookup.wmv5.88 MB
2. Execution Plan Basics/11. Index Seek vs Index Scan.wmv2.13 MB
2. Execution Plan Basics/12. Types of Joins.wmv2.74 MB
2. Execution Plan Basics/13. Demo - Types of Joins.wmv10.9 MB
2. Execution Plan Basics/14. Summary.wmv1.7 MB
2. Execution Plan Basics/2. Demo.wmv13.52 MB
2. Execution Plan Basics/3. Various Execution Plan Types.wmv3.95 MB
2. Execution Plan Basics/4. Demo - Execution Plan Types.wmv13.67 MB
2. Execution Plan Basics/5. Clustered Index.wmv6.01 MB
2. Execution Plan Basics/6. Demo - Clustered Index.wmv7.1 MB
2. Execution Plan Basics/7. Non-clustered Index.wmv2.43 MB
2. Execution Plan Basics/8. Demo - Non-clustered Index.wmv7.11 MB
2. Execution Plan Basics/9. Key Lookup.wmv1.14 MB
3. Essential Indexing Techniques/1. Introduction.wmv5.72 MB
3. Essential Indexing Techniques/2. Demo - Basics of Index.wmv10.55 MB
3. Essential Indexing Techniques/3. Index Behaviors.wmv1.39 MB
3. Essential Indexing Techniques/4. Demo - Included Columns.wmv12.2 MB
3. Essential Indexing Techniques/5. Demo - Seek vs Scan vs Lookup.wmv11.25 MB
3. Essential Indexing Techniques/6. Demo - WHERE clause and ORDERs of Column.wmv22.59 MB
3. Essential Indexing Techniques/7. Demo - Usage of Functions in WHERE clause.wmv10.55 MB
3. Essential Indexing Techniques/8. Summary.wmv3.22 MB
4. Query Design for Performance/1. Introduction.wmv2.91 MB
4. Query Design for Performance/10. Dynamic SQL and Performance.wmv1.55 MB
4. Query Design for Performance/11. Demo - Dynamic SQL and Performance.wmv10.3 MB
4. Query Design for Performance/12. User Defined Functions, Views and Performance.wmv2.77 MB
4. Query Design for Performance/13. Demo - UDFs, Views and Performance.wmv15.64 MB
4. Query Design for Performance/14. Summary.wmv1.1 MB
4. Query Design for Performance/2. EXISTS vs IN vs JOIN.wmv3.96 MB
4. Query Design for Performance/3. Demo - EXISTS vs IN vs JOIN.wmv21.95 MB
4. Query Design for Performance/4. Common Table Expression (CTE).wmv1.4 MB
4. Query Design for Performance/5. Demo - Common Table Expression (CTE).wmv11.37 MB
4. Query Design for Performance/6. Order of Table and Query Hints.wmv1.63 MB
4. Query Design for Performance/7. Demo - Order of Table and Query Hints.wmv15.66 MB
4. Query Design for Performance/8. Plan Guide and Parameter Sniffing.wmv2.15 MB
4. Query Design for Performance/9. Demo - Plan Guide and Parameter Sniffing.wmv16.5 MB
5. Performance Tuning Tools/1. Introduction.wmv2.29 MB
5. Performance Tuning Tools/10. Demo - SQL Server Profiler.wmv17.06 MB
5. Performance Tuning Tools/11. Demo - SQL Server Extended Events.wmv12.13 MB
5. Performance Tuning Tools/12. SQL Server Wait Stats.wmv4.97 MB
5. Performance Tuning Tools/13. Demo - SQL Server Wait Stats - CXPACKET.wmv14.3 MB
5. Performance Tuning Tools/14. Demo - Wait Stats - Identify Offending Query.wmv6.59 MB
5. Performance Tuning Tools/15. Demo - Dynamic Management Views (DMV).wmv15.91 MB
5. Performance Tuning Tools/16. Demo - SQLDiag.wmv8.04 MB
5. Performance Tuning Tools/17. Summary.wmv832.97 KB
5. Performance Tuning Tools/2. SSMS Performance Dashboard.wmv1.74 MB

Trackers

No trackers found.