Pluralsight Introduction to Query Tuning | 251C03ED21B26756C81DCF3469F60DD4B7835BC3

Pluralsight Introduction to Query Tuning

Name	Pluralsight - Introduction to Query Tuning	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	388.2 MB
Total Files	49
Hash	251C03ED21B26756C81DCF3469F60DD4B7835BC3

/1. Introduction/
1. Introduction.wmv	4.6 MB
2. Query Tuning.wmv	4.4 MB
3. Demo.wmv	8.0 MB
/2. Execution Plan Basics/
1. Introduction.wmv	5.8 MB
10. Demo - Key Lookup.wmv	6.2 MB
11. Index Seek vs Index Scan.wmv	2.2 MB
12. Types of Joins.wmv	2.9 MB
13. Demo - Types of Joins.wmv	11.4 MB
14. Summary.wmv	1.8 MB
2. Demo.wmv	14.2 MB
3. Various Execution Plan Types.wmv	4.1 MB
4. Demo - Execution Plan Types.wmv	14.3 MB
5. Clustered Index.wmv	6.3 MB
6. Demo - Clustered Index.wmv	7.4 MB
7. Non-clustered Index.wmv	2.5 MB
8. Demo - Non-clustered Index.wmv	7.5 MB
9. Key Lookup.wmv	1.2 MB
/3. Essential Indexing Techniques/
1. Introduction.wmv	6.0 MB
2. Demo - Basics of Index.wmv	11.1 MB
3. Index Behaviors.wmv	1.5 MB
4. Demo - Included Columns.wmv	12.8 MB
5. Demo - Seek vs Scan vs Lookup.wmv	11.8 MB
6. Demo - WHERE clause and ORDERs of Column.wmv	23.7 MB
7. Demo - Usage of Functions in WHERE clause.wmv	11.1 MB
8. Summary.wmv	3.4 MB
/4. Query Design for Performance/
1. Introduction.wmv	3.1 MB
10. Dynamic SQL and Performance.wmv	1.6 MB
11. Demo - Dynamic SQL and Performance.wmv	10.8 MB
12. User Defined Functions, Views and Performance.wmv	2.9 MB
13. Demo - UDFs, Views and Performance.wmv	16.4 MB
14. Summary.wmv	1.2 MB
2. EXISTS vs IN vs JOIN.wmv	4.2 MB
3. Demo - EXISTS vs IN vs JOIN.wmv	23.0 MB
4. Common Table Expression (CTE).wmv	1.5 MB
5. Demo - Common Table Expression (CTE).wmv	11.9 MB
6. Order of Table and Query Hints.wmv	1.7 MB
7. Demo - Order of Table and Query Hints.wmv	16.4 MB
8. Plan Guide and Parameter Sniffing.wmv	2.3 MB
9. Demo - Plan Guide and Parameter Sniffing.wmv	17.3 MB
/5. Performance Tuning Tools/
1. Introduction.wmv	2.4 MB
10. Demo - SQL Server Profiler.wmv	17.9 MB
11. Demo - SQL Server Extended Events.wmv	12.7 MB
12. SQL Server Wait Stats.wmv	5.2 MB
13. Demo - SQL Server Wait Stats - CXPACKET.wmv	15.0 MB
14. Demo - Wait Stats - Identify Offending Query.wmv	6.9 MB
15. Demo - Dynamic Management Views (DMV).wmv	16.7 MB
16. Demo - SQLDiag.wmv	8.4 MB
17. Summary.wmv	853.0 KB
2. SSMS Performance Dashboard.wmv	1.8 MB
Total files 49