Pluralsight SQL Server Common Query Tuning Problems and Solutions Part

Pluralsight SQL Server Common Query Tuning Problems and Solutions Part

Name	Pluralsight - SQL Server Common Query Tuning Problems and Solutions - Part 2	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	585.4 MB
Total Files	47
Hash	26B00ECC7F959048B0A2E7A41FA9BE3B6F591713

/Exercise Files/
sql-server-common-query-tuning-problems-solutions-part2.zip	386.5 KB
/
01-Course Introduction.mp4	1.7 MB
02-Course Structure.mp4	1.1 MB
03-Module Introduction.mp4	1.8 MB
04-Demo One-Row-At-A-Time-Processing.mp4	12.9 MB
05-Demo The Forgotten Trigger.mp4	16.3 MB
06-Demo Scalar Function Inhibited Parallelism.mp4	10.8 MB
07-Demo Scalar Function Row by Row Execution.mp4	14.0 MB
08-Demo Too Few Rows Per Batch.mp4	13.9 MB
09-Demo Not Using TOP When You Can.mp4	11.6 MB
10-Demo Unnecessary Many-To-Many.mp4	18.2 MB
11-Demo Excessive Fragmentation and Scans.mp4	15.5 MB
12-Module Summary.mp4	544.8 KB
13-Module Introduction.mp4	1.8 MB
14-Defining OLTP and DSS.mp4	2.0 MB
15-OLTP Characteristics.mp4	2.0 MB
16-Demo Stop-And-Go Operators.mp4	19.8 MB
17-Demo Finding Timeout-Prone Queries.mp4	11.0 MB
18-Demo Over-Indexing.mp4	12.7 MB
19-Demo OLTP and Parallelism.mp4	20.7 MB
20-Demo OLTP and Deep Trees.mp4	19.2 MB
21-DSS Characteristics.mp4	2.0 MB
22-Demo Expanding the AdventureWorksDW2012 Database.mp4	8.4 MB
23-Demo Unwanted Serial Plans.mp4	25.3 MB
24-Demo Gatekeeper Row Issue - Part 1.mp4	15.9 MB
25-Demo Gatekeeper Row Issue - Part 2.mp4	12.7 MB
26-Demo Gatekeeper Row Issue - Part 3.mp4	14.7 MB
27-Demo Aggregation Queries and Columnstore Index Opportunities.mp4	14.0 MB
28-Demo Distinct Aggregation Issue.mp4	14.5 MB
29-Module Summary.mp4	710.6 KB
30-Module Introduction.mp4	1.8 MB
31-Demo New-Feature Abuse.mp4	24.7 MB
32-Demo Recursive CTE Estimate Skews.mp4	21.1 MB
33-Demo Seeks, Scans, Predicates, and Filters - Part 1.mp4	15.3 MB
34-Demo Seeks, Scans, Predicates, and Filters - Part 2.mp4	13.4 MB
35-Demo Seeks, Scans, Predicates, and Filters - Part 3.mp4	15.1 MB
36-Demo Unmatched Indexes.mp4	18.9 MB
37-Demo Disused Filtered Statistics.mp4	15.0 MB
38-Demo Interpreting RetrievedFromCache.mp4	17.0 MB
39-Demo Amplification and Distinct Value Counts.mp4	24.2 MB
40-Demo Join Hints and Forced Order.mp4	27.1 MB
41-Demo CTEs vs. Derived Tables.mp4	18.5 MB
42-Demo One Procedure With Multiple Optional Input Parameters.mp4	27.2 MB
43-Demo Procedure Sub-Branching.mp4	18.0 MB
44-Demo Verifying Instance Workload Complexity.mp4	10.5 MB
45-Module Summary.mp4	665.9 KB
46-Course Summary.mp4	565.9 KB
Total files 47