Pluralsight - SQL Server Common Query Tuning Problems and Solutions - Part 2

1. 42-Demo One Procedure With Multiple Optional Input Parameters.mp4 25.90 MB
2. 40-Demo Join Hints and Forced Order.mp4 25.88 MB
3. 23-Demo Unwanted Serial Plans.mp4 24.14 MB
4. 31-Demo New-Feature Abuse.mp4 23.58 MB
5. 39-Demo Amplification and Distinct Value Counts.mp4 23.06 MB
6. 32-Demo Recursive CTE Estimate Skews.mp4 20.13 MB
7. 19-Demo OLTP and Parallelism.mp4 19.72 MB
8. 16-Demo Stop-And-Go Operators.mp4 18.93 MB
9. 20-Demo OLTP and Deep Trees.mp4 18.32 MB
10. 36-Demo Unmatched Indexes.mp4 18.07 MB
11. 41-Demo CTEs vs. Derived Tables.mp4 17.68 MB
12. 10-Demo Unnecessary Many-To-Many.mp4 17.37 MB
13. 43-Demo Procedure Sub-Branching.mp4 17.19 MB
14. 38-Demo Interpreting RetrievedFromCache.mp4 16.21 MB
15. 05-Demo The Forgotten Trigger.mp4 15.52 MB
16. 24-Demo Gatekeeper Row Issue - Part 1.mp4 15.14 MB
17. 11-Demo Excessive Fragmentation and Scans.mp4 14.83 MB
18. 33-Demo Seeks, Scans, Predicates, and Filters - Part 1.mp4 14.60 MB
19. 35-Demo Seeks, Scans, Predicates, and Filters - Part 3.mp4 14.42 MB
20. 37-Demo Disused Filtered Statistics.mp4 14.33 MB
21. 26-Demo Gatekeeper Row Issue - Part 3.mp4 14.07 MB
22. 28-Demo Distinct Aggregation Issue.mp4 13.81 MB
23. 07-Demo Scalar Function Row by Row Execution.mp4 13.37 MB
24. 27-Demo Aggregation Queries and Columnstore Index Opportunities.mp4 13.35 MB
25. 08-Demo Too Few Rows Per Batch.mp4 13.30 MB
26. 34-Demo Seeks, Scans, Predicates, and Filters - Part 2.mp4 12.79 MB
27. 04-Demo One-Row-At-A-Time-Processing.mp4 12.32 MB
28. 25-Demo Gatekeeper Row Issue - Part 2.mp4 12.08 MB
29. 18-Demo Over-Indexing.mp4 12.08 MB
30. 09-Demo Not Using TOP When You Can.mp4 11.07 MB
31. 17-Demo Finding Timeout-Prone Queries.mp4 10.53 MB
32. 06-Demo Scalar Function Inhibited Parallelism.mp4 10.34 MB
33. 44-Demo Verifying Instance Workload Complexity.mp4 9.97 MB
34. 22-Demo Expanding the AdventureWorksDW2012 Database.mp4 8.00 MB
35. 14-Defining OLTP and DSS.mp4 1.89 MB
36. 21-DSS Characteristics.mp4 1.88 MB
37. 15-OLTP Characteristics.mp4 1.86 MB
38. 13-Module Introduction.mp4 1.73 MB
39. 30-Module Introduction.mp4 1.72 MB
40. 03-Module Introduction.mp4 1.70 MB
41. 01-Course Introduction.mp4 1.59 MB
42. 02-Course Structure.mp4 1.07 MB
43. 29-Module Summary.mp4 694 KB
44. 45-Module Summary.mp4 651 KB
45. 46-Course Summary.mp4 553 KB
46. 12-Module Summary.mp4 533 KB
47. Exercise Files/sql-server-common-query-tuning-problems-solutions-part2.zip 378 KB