SQL Server Common Query Tuning Problems and Solutions - Part 2

558.28 MB | 00:05:20 | mp4 | 1024X768 | 4:3
Genre:eLearning |Language:English

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