589689.xyz

Lynda - SQL Server Performance for Developers

  • 收录时间:2018-08-20 09:30:26
  • 文件大小:426MB
  • 下载次数:111
  • 最近下载:2020-12-25 03:54:54
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 6.5. Indexing/28.Overview of nonclustered indexes.mp4 18MB
  2. 3.2. What Not to Do with SQL Server/15.Views and vested views.mp4 18MB
  3. 5.4. Temporary Objects/24.In-memory temp tables.mp4 18MB
  4. 7.6. Columnstore/32.Clustered columnstore and DW.mp4 17MB
  5. 2.1. Query Execution/08.Query Store.mp4 16MB
  6. 6.5. Indexing/29.Included column explanation.mp4 15MB
  7. 7.6. Columnstore/34.Using filtered nonclustered columnstore for HTAP.mp4 14MB
  8. 5.4. Temporary Objects/22.Temp tables.mp4 14MB
  9. 7.6. Columnstore/31.What is a columnstore index.mp4 14MB
  10. 6.5. Indexing/26.Why you want a clustered index.mp4 14MB
  11. 6.5. Indexing/30.Filtered indexes.mp4 14MB
  12. 5.4. Temporary Objects/23.Table variables.mp4 13MB
  13. 3.2. What Not to Do with SQL Server/16.Why stored procedures are better than views for reports.mp4 13MB
  14. 4.3. Datatypes and Design/21.What datatype conversions do to your query performance.mp4 13MB
  15. 3.2. What Not to Do with SQL Server/14.Why scalar UDFs are expensive.mp4 12MB
  16. 2.1. Query Execution/10.Missing index warnings.mp4 12MB
  17. 2.1. Query Execution/04.How to read an execution plan.mp4 11MB
  18. 3.2. What Not to Do with SQL Server/12.Why while loops are cursors.mp4 11MB
  19. 8.7. Isolation Levels/35.Transaction isolation.mp4 11MB
  20. 6.5. Indexing/25.Choosing a PK or clustered index key.mp4 11MB
  21. 4.3. Datatypes and Design/18.GUIDs vs. INT_BIGINT.mp4 10MB
  22. 8.7. Isolation Levels/36.RCSI - Why it's good.mp4 10MB
  23. 4.3. Datatypes and Design/20.The perils of storing files in your database.mp4 10MB
  24. 2.1. Query Execution/09.Stored procedures vs. dynamic SQL.mp4 10MB
  25. 4.3. Datatypes and Design/17.The importance of datatypes.mp4 10MB
  26. 4.3. Datatypes and Design/19.Unicode data.mp4 10MB
  27. 6.5. Indexing/27.Where you might not want a clustered index.mp4 9MB
  28. 2.1. Query Execution/07.Nested loop vs. hash join.mp4 9MB
  29. 2.1. Query Execution/05.Execution plan XMLs.mp4 9MB
  30. 8.7. Isolation Levels/37.Implicit transactions - Why they're terrible.mp4 9MB
  31. 2.1. Query Execution/06.Key lookup - When it's good and when it's bad.mp4 8MB
  32. 3.2. What Not to Do with SQL Server/13.What to do instead of cursors.mp4 8MB
  33. 2.1. Query Execution/03.Execution plans introduction.mp4 7MB
  34. 7.6. Columnstore/33.Nonclustered columnstore - Why.mp4 7MB
  35. 3.2. What Not to Do with SQL Server/11.Why cursors are bad.mp4 7MB
  36. 1.Introduction/02.What you should know.mp4 5MB
  37. 1.Introduction/01.Welcome.mp4 4MB
  38. 9.Conclusion/38.Next steps.mp4 3MB
  39. Exercise Files/Ex_Files_SQL_Server_Performance_Developers.zip 29KB
  40. 3.2. What Not to Do with SQL Server/15.Views and vested views.en.srt 17KB
  41. 5.4. Temporary Objects/24.In-memory temp tables.en.srt 17KB
  42. 6.5. Indexing/28.Overview of nonclustered indexes.en.srt 17KB
  43. 5.4. Temporary Objects/22.Temp tables.en.srt 16KB
  44. 2.1. Query Execution/08.Query Store.en.srt 15KB
  45. 7.6. Columnstore/31.What is a columnstore index.en.srt 15KB
  46. 4.3. Datatypes and Design/17.The importance of datatypes.en.srt 15KB
  47. 7.6. Columnstore/32.Clustered columnstore and DW.en.srt 14KB
  48. 6.5. Indexing/25.Choosing a PK or clustered index key.en.srt 14KB
  49. 8.7. Isolation Levels/35.Transaction isolation.en.srt 14KB
  50. 6.5. Indexing/29.Included column explanation.en.srt 14KB
  51. 5.4. Temporary Objects/23.Table variables.en.srt 13KB
  52. 6.5. Indexing/30.Filtered indexes.en.srt 12KB
  53. 7.6. Columnstore/34.Using filtered nonclustered columnstore for HTAP.en.srt 12KB
  54. 6.5. Indexing/26.Why you want a clustered index.en.srt 12KB
  55. 4.3. Datatypes and Design/19.Unicode data.en.srt 12KB
  56. 2.1. Query Execution/04.How to read an execution plan.en.srt 12KB
  57. 4.3. Datatypes and Design/18.GUIDs vs. INT_BIGINT.en.srt 12KB
  58. 2.1. Query Execution/10.Missing index warnings.en.srt 12KB
  59. 3.2. What Not to Do with SQL Server/16.Why stored procedures are better than views for reports.en.srt 11KB
  60. 8.7. Isolation Levels/37.Implicit transactions - Why they're terrible.en.srt 11KB
  61. 4.3. Datatypes and Design/21.What datatype conversions do to your query performance.en.srt 11KB
  62. 3.2. What Not to Do with SQL Server/14.Why scalar UDFs are expensive.en.srt 11KB
  63. 8.7. Isolation Levels/36.RCSI - Why it's good.en.srt 11KB
  64. 4.3. Datatypes and Design/20.The perils of storing files in your database.en.srt 10KB
  65. 2.1. Query Execution/09.Stored procedures vs. dynamic SQL.en.srt 10KB
  66. 6.5. Indexing/27.Where you might not want a clustered index.en.srt 10KB
  67. 3.2. What Not to Do with SQL Server/12.Why while loops are cursors.en.srt 10KB
  68. 2.1. Query Execution/03.Execution plans introduction.en.srt 9KB
  69. 2.1. Query Execution/07.Nested loop vs. hash join.en.srt 9KB
  70. 2.1. Query Execution/06.Key lookup - When it's good and when it's bad.en.srt 8KB
  71. 7.6. Columnstore/33.Nonclustered columnstore - Why.en.srt 8KB
  72. 3.2. What Not to Do with SQL Server/13.What to do instead of cursors.en.srt 7KB
  73. 3.2. What Not to Do with SQL Server/11.Why cursors are bad.en.srt 7KB
  74. 1.Introduction/02.What you should know.en.srt 6KB
  75. 2.1. Query Execution/05.Execution plan XMLs.en.srt 5KB
  76. 9.Conclusion/38.Next steps.en.srt 5KB
  77. 1.Introduction/01.Welcome.en.srt 1KB