589689.xyz

[] SQL Server Performance - Introduction to Query Tuning

  • 收录时间:2018-03-31 09:18:43
  • 文件大小:539MB
  • 下载次数:90
  • 最近下载:2021-01-14 15:22:31
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 5. Performance Tuning Tools/8. Demo - Performance Analysis of Logs (PAL) Tool.wmv 29MB
  2. 5. Performance Tuning Tools/3. Demo - SSMS Performance Dashboard.wmv 27MB
  3. 3. Essential Indexing Techniques/6. Demo - WHERE clause and ORDERs of Column.wmv 23MB
  4. 4. Query Design for Performance/3. Demo - EXISTS vs IN vs JOIN.wmv 22MB
  5. 5. Performance Tuning Tools/10. Demo - SQL Server Profiler.wmv 17MB
  6. 4. Query Design for Performance/9. Demo - Plan Guide and Parameter Sniffing.wmv 17MB
  7. 5. Performance Tuning Tools/15. Demo - Dynamic Management Views (DMV).wmv 16MB
  8. 4. Query Design for Performance/7. Demo - Order of Table and Query Hints.wmv 16MB
  9. 4. Query Design for Performance/13. Demo - UDFs, Views and Performance.wmv 16MB
  10. 5. Performance Tuning Tools/13. Demo - SQL Server Wait Stats - CXPACKET.wmv 14MB
  11. 2. Execution Plan Basics/4. Demo - Execution Plan Types.wmv 14MB
  12. 2. Execution Plan Basics/2. Demo.wmv 14MB
  13. 5. Performance Tuning Tools/6. Demo - Database Tuning Advisor.wmv 13MB
  14. 3. Essential Indexing Techniques/4. Demo - Included Columns.wmv 12MB
  15. 5. Performance Tuning Tools/11. Demo - SQL Server Extended Events.wmv 12MB
  16. 5. Performance Tuning Tools/7. Demo - Perfmon Counters.wmv 12MB
  17. 4. Query Design for Performance/5. Demo - Common Table Expression (CTE).wmv 11MB
  18. 6. Tips and Tricks/9. Demo - Performance Tips and Tricks.wmv 11MB
  19. 3. Essential Indexing Techniques/5. Demo - Seek vs Scan vs Lookup.wmv 11MB
  20. 2. Execution Plan Basics/13. Demo - Types of Joins.wmv 11MB
  21. 7. Checklist - Performance Tuning/1. Checklist.wmv 11MB
  22. 3. Essential Indexing Techniques/7. Demo - Usage of Functions in WHERE clause.wmv 11MB
  23. 3. Essential Indexing Techniques/2. Demo - Basics of Index.wmv 11MB
  24. 4. Query Design for Performance/11. Demo - Dynamic SQL and Performance.wmv 10MB
  25. 6. Tips and Tricks/4. Demo - Cursors and Performance.wmv 9MB
  26. 6. Tips and Tricks/5. Demo - Multi Statement Table Value Functions.wmv 9MB
  27. 6. Tips and Tricks/8. Demo - Stored Procedure and Compilation.wmv 9MB
  28. 5. Performance Tuning Tools/16. Demo - SQLDiag.wmv 8MB
  29. 1. Introduction/3. Demo.wmv 8MB
  30. 5. Performance Tuning Tools/5. Demo - SQL Server Best Practices Analyzer.wmv 7MB
  31. 2. Execution Plan Basics/8. Demo - Non-clustered Index.wmv 7MB
  32. 2. Execution Plan Basics/6. Demo - Clustered Index.wmv 7MB
  33. 5. Performance Tuning Tools/4. Demo - Error Logs.wmv 7MB
  34. 6. Tips and Tricks/6. Demo - Stored Procedure and Dynamic Query.wmv 7MB
  35. 5. Performance Tuning Tools/14. Demo - Wait Stats - Identify Offending Query.wmv 7MB
  36. 2. Execution Plan Basics/5. Clustered Index.wmv 6MB
  37. 2. Execution Plan Basics/10. Demo - Key Lookup.wmv 6MB
  38. 3. Essential Indexing Techniques/1. Introduction.wmv 6MB
  39. 6. Tips and Tricks/2. Demo - Columnstore Index.wmv 6MB
  40. 2. Execution Plan Basics/1. Introduction.wmv 6MB
  41. 5. Performance Tuning Tools/12. SQL Server Wait Stats.wmv 5MB
  42. 1. Introduction/1. Introduction.wmv 4MB
  43. 1. Introduction/2. Query Tuning.wmv 4MB
  44. 4. Query Design for Performance/2. EXISTS vs IN vs JOIN.wmv 4MB
  45. 2. Execution Plan Basics/3. Various Execution Plan Types.wmv 4MB
  46. 6. Tips and Tricks/7. Demo - Stored Procedure and Transaction.wmv 4MB
  47. 5. Performance Tuning Tools/9. Demo - SQL Space Map.wmv 4MB
  48. 6. Tips and Tricks/3. Demo - Functions and Computed Columns.wmv 3MB
  49. 3. Essential Indexing Techniques/8. Summary.wmv 3MB
  50. 4. Query Design for Performance/1. Introduction.wmv 3MB
  51. 4. Query Design for Performance/12. User Defined Functions, Views and Performance.wmv 3MB
  52. 2. Execution Plan Basics/12. Types of Joins.wmv 3MB
  53. 2. Execution Plan Basics/7. Non-clustered Index.wmv 2MB
  54. 5. Performance Tuning Tools/1. Introduction.wmv 2MB
  55. 4. Query Design for Performance/8. Plan Guide and Parameter Sniffing.wmv 2MB
  56. 2. Execution Plan Basics/11. Index Seek vs Index Scan.wmv 2MB
  57. 6. Tips and Tricks/1. Introduction.wmv 2MB
  58. 5. Performance Tuning Tools/2. SSMS Performance Dashboard.wmv 2MB
  59. 2. Execution Plan Basics/14. Summary.wmv 2MB
  60. 4. Query Design for Performance/6. Order of Table and Query Hints.wmv 2MB
  61. 4. Query Design for Performance/10. Dynamic SQL and Performance.wmv 2MB
  62. 4. Query Design for Performance/4. Common Table Expression (CTE).wmv 1MB
  63. 3. Essential Indexing Techniques/3. Index Behaviors.wmv 1MB
  64. 2. Execution Plan Basics/9. Key Lookup.wmv 1MB
  65. 4. Query Design for Performance/14. Summary.wmv 1MB
  66. 5. Performance Tuning Tools/17. Summary.wmv 833KB