Create Tool:
Create Time:2012-06-02 01:33:24
File Size:538.51 MB
File Count:66
File Hash:dd70843c22c3b73aad16e3525e0e87cf3a7987f8
1. Introduction/1. Introduction.wmv | 4.35 MB |
1. Introduction/2. Query Tuning.wmv | 4.19 MB |
1. Introduction/3. Demo.wmv | 7.62 MB |
2. Execution Plan Basics/1. Introduction.wmv | 5.51 MB |
2. Execution Plan Basics/10. Demo - Key Lookup.wmv | 5.88 MB |
2. Execution Plan Basics/11. Index Seek vs Index Scan.wmv | 2.13 MB |
2. Execution Plan Basics/12. Types of Joins.wmv | 2.74 MB |
2. Execution Plan Basics/13. Demo - Types of Joins.wmv | 10.90 MB |
2. Execution Plan Basics/14. Summary.wmv | 1.70 MB |
2. Execution Plan Basics/2. Demo.wmv | 13.52 MB |
2. Execution Plan Basics/3. Various Execution Plan Types.wmv | 3.95 MB |
2. Execution Plan Basics/4. Demo - Execution Plan Types.wmv | 13.67 MB |
2. Execution Plan Basics/5. Clustered Index.wmv | 6.01 MB |
2. Execution Plan Basics/6. Demo - Clustered Index.wmv | 7.10 MB |
2. Execution Plan Basics/7. Non-clustered Index.wmv | 2.43 MB |
2. Execution Plan Basics/8. Demo - Non-clustered Index.wmv | 7.11 MB |
2. Execution Plan Basics/9. Key Lookup.wmv | 1.14 MB |
3. Essential Indexing Techniques/1. Introduction.wmv | 5.72 MB |
3. Essential Indexing Techniques/2. Demo - Basics of Index.wmv | 10.55 MB |
3. Essential Indexing Techniques/3. Index Behaviors.wmv | 1.39 MB |
3. Essential Indexing Techniques/4. Demo - Included Columns.wmv | 12.20 MB |
3. Essential Indexing Techniques/5. Demo - Seek vs Scan vs Lookup.wmv | 11.25 MB |
3. Essential Indexing Techniques/6. Demo - WHERE clause and ORDERs of Column.wmv | 22.59 MB |
3. Essential Indexing Techniques/7. Demo - Usage of Functions in WHERE clause.wmv | 10.55 MB |
3. Essential Indexing Techniques/8. Summary.wmv | 3.22 MB |
4. Query Design for Performance/1. Introduction.wmv | 2.91 MB |
4. Query Design for Performance/10. Dynamic SQL and Performance.wmv | 1.55 MB |
4. Query Design for Performance/11. Demo - Dynamic SQL and Performance.wmv | 10.30 MB |
4. Query Design for Performance/12. User Defined Functions, Views and Performance.wmv | 2.77 MB |
4. Query Design for Performance/13. Demo - UDFs, Views and Performance.wmv | 15.64 MB |
4. Query Design for Performance/14. Summary.wmv | 1.10 MB |
4. Query Design for Performance/2. EXISTS vs IN vs JOIN.wmv | 3.96 MB |
4. Query Design for Performance/3. Demo - EXISTS vs IN vs JOIN.wmv | 21.95 MB |
4. Query Design for Performance/4. Common Table Expression (CTE).wmv | 1.40 MB |
4. Query Design for Performance/5. Demo - Common Table Expression (CTE).wmv | 11.37 MB |
4. Query Design for Performance/6. Order of Table and Query Hints.wmv | 1.63 MB |
4. Query Design for Performance/7. Demo - Order of Table and Query Hints.wmv | 15.66 MB |
4. Query Design for Performance/8. Plan Guide and Parameter Sniffing.wmv | 2.15 MB |
4. Query Design for Performance/9. Demo - Plan Guide and Parameter Sniffing.wmv | 16.50 MB |
5. Performance Tuning Tools/1. Introduction.wmv | 2.29 MB |
5. Performance Tuning Tools/10. Demo - SQL Server Profiler.wmv | 17.06 MB |
5. Performance Tuning Tools/11. Demo - SQL Server Extended Events.wmv | 12.13 MB |
5. Performance Tuning Tools/12. SQL Server Wait Stats.wmv | 4.97 MB |
5. Performance Tuning Tools/13. Demo - SQL Server Wait Stats - CXPACKET.wmv | 14.30 MB |
5. Performance Tuning Tools/14. Demo - Wait Stats - Identify Offending Query.wmv | 6.59 MB |
5. Performance Tuning Tools/15. Demo - Dynamic Management Views (DMV).wmv | 15.91 MB |
5. Performance Tuning Tools/16. Demo - SQLDiag.wmv | 8.04 MB |
5. Performance Tuning Tools/17. Summary.wmv | 832.97 KB |
5. Performance Tuning Tools/2. SSMS Performance Dashboard.wmv | 1.74 MB |
5. Performance Tuning Tools/3. Demo - SSMS Performance Dashboard.wmv | 26.78 MB |
5. Performance Tuning Tools/4. Demo - Error Logs.wmv | 6.72 MB |
5. Performance Tuning Tools/5. Demo - SQL Server Best Practices Analyzer.wmv | 7.13 MB |
5. Performance Tuning Tools/6. Demo - Database Tuning Advisor.wmv | 12.82 MB |
5. Performance Tuning Tools/7. Demo - Perfmon Counters.wmv | 11.95 MB |
5. Performance Tuning Tools/8. Demo - Performance Analysis of Logs (PAL) Tool.wmv | 29.13 MB |
5. Performance Tuning Tools/9. Demo - SQL Space Map.wmv | 3.63 MB |
6. Tips and Tricks/1. Introduction.wmv | 1.78 MB |
6. Tips and Tricks/2. Demo - Columnstore Index.wmv | 5.58 MB |
6. Tips and Tricks/3. Demo - Functions and Computed Columns.wmv | 3.44 MB |
6. Tips and Tricks/4. Demo - Cursors and Performance.wmv | 9.17 MB |
6. Tips and Tricks/5. Demo - Multi Statement Table Value Functions.wmv | 8.89 MB |
6. Tips and Tricks/6. Demo - Stored Procedure and Dynamic Query.wmv | 6.63 MB |
6. Tips and Tricks/7. Demo - Stored Procedure and Transaction.wmv | 3.83 MB |
6. Tips and Tricks/8. Demo - Stored Procedure and Compilation.wmv | 8.80 MB |
6. Tips and Tricks/9. Demo - Performance Tips and Tricks.wmv | 11.33 MB |
7. Checklist - Performance Tuning/1. Checklist.wmv | 10.68 MB |
http://bt.rutracker.org/ann?uk=sGH75QGSdD |
http://retracker.local/announce |
http://ix.rutracker.net/ann?uk=sGH75QGSdD |
TorrentBank
Copyright © 2024