Pluralsight training net SQL Server Performance Introduction to Query Tuning

Pluralsight training net SQL Server Performance Introduction to Query Tuning

Name	[pluralsight-training.net] SQL Server Performance - Introduction to Query Tuning	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	564.7 MB
Total Files	66
Hash	DD70843C22C3B73AAD16E3525E0E87CF3A7987F8

/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
3. Demo - SSMS Performance Dashboard.wmv	28.1 MB
4. Demo - Error Logs.wmv	7.0 MB
5. Demo - SQL Server Best Practices Analyzer.wmv	7.5 MB
6. Demo - Database Tuning Advisor.wmv	13.4 MB
7. Demo - Perfmon Counters.wmv	12.5 MB
8. Demo - Performance Analysis of Logs (PAL) Tool.wmv	30.5 MB
9. Demo - SQL Space Map.wmv	3.8 MB
/6. Tips and Tricks/
1. Introduction.wmv	1.9 MB
2. Demo - Columnstore Index.wmv	5.8 MB
3. Demo - Functions and Computed Columns.wmv	3.6 MB
4. Demo - Cursors and Performance.wmv	9.6 MB
5. Demo - Multi Statement Table Value Functions.wmv	9.3 MB
6. Demo - Stored Procedure and Dynamic Query.wmv	7.0 MB
7. Demo - Stored Procedure and Transaction.wmv	4.0 MB
8. Demo - Stored Procedure and Compilation.wmv	9.2 MB
9. Demo - Performance Tips and Tricks.wmv	11.9 MB
/7. Checklist - Performance Tuning/
1. Checklist.wmv	11.2 MB
Total files 66