TorBT - Torrents and Magnet Links Search Engine
Pluralsight - SQL Server Common Query Tuning Problems and Solutions - Part 2
- Date: 2024-09-27
- Size: 558 MB
- Files: 47
File Name
Size
Exercise Files/sql-server-common-query-tuning-problems-solutions-part2.zip
378 kB
01-Course Introduction.mp4
1.6 MB
02-Course Structure.mp4
1.1 MB
03-Module Introduction.mp4
1.7 MB
04-Demo One-Row-At-A-Time-Processing.mp4
12 MB
05-Demo The Forgotten Trigger.mp4
16 MB
06-Demo Scalar Function Inhibited Parallelism.mp4
10 MB
07-Demo Scalar Function Row by Row Execution.mp4
13 MB
08-Demo Too Few Rows Per Batch.mp4
13 MB
09-Demo Not Using TOP When You Can.mp4
11 MB
10-Demo Unnecessary Many-To-Many.mp4
17 MB
11-Demo Excessive Fragmentation and Scans.mp4
15 MB
12-Module Summary.mp4
532 kB
13-Module Introduction.mp4
1.7 MB
14-Defining OLTP and DSS.mp4
1.9 MB
15-OLTP Characteristics.mp4
1.9 MB
16-Demo Stop-And-Go Operators.mp4
19 MB
17-Demo Finding Timeout-Prone Queries.mp4
10 MB
18-Demo Over-Indexing.mp4
12 MB
19-Demo OLTP and Parallelism.mp4
20 MB
20-Demo OLTP and Deep Trees.mp4
18 MB
21-DSS Characteristics.mp4
1.9 MB
22-Demo Expanding the AdventureWorksDW2012 Database.mp4
8.0 MB
23-Demo Unwanted Serial Plans.mp4
24 MB
24-Demo Gatekeeper Row Issue - Part 1.mp4
15 MB
25-Demo Gatekeeper Row Issue - Part 2.mp4
12 MB
26-Demo Gatekeeper Row Issue - Part 3.mp4
14 MB
27-Demo Aggregation Queries and Columnstore Index Opportunities.mp4
13 MB
28-Demo Distinct Aggregation Issue.mp4
14 MB
29-Module Summary.mp4
694 kB
30-Module Introduction.mp4
1.7 MB
31-Demo New-Feature Abuse.mp4
24 MB
32-Demo Recursive CTE Estimate Skews.mp4
20 MB
33-Demo Seeks, Scans, Predicates, and Filters - Part 1.mp4
15 MB
34-Demo Seeks, Scans, Predicates, and Filters - Part 2.mp4
13 MB
35-Demo Seeks, Scans, Predicates, and Filters - Part 3.mp4
14 MB
36-Demo Unmatched Indexes.mp4
18 MB
37-Demo Disused Filtered Statistics.mp4
14 MB
38-Demo Interpreting RetrievedFromCache.mp4
16 MB
39-Demo Amplification and Distinct Value Counts.mp4
23 MB
40-Demo Join Hints and Forced Order.mp4
26 MB
41-Demo CTEs vs. Derived Tables.mp4
18 MB
42-Demo One Procedure With Multiple Optional Input Parameters.mp4
26 MB
43-Demo Procedure Sub-Branching.mp4
17 MB
44-Demo Verifying Instance Workload Complexity.mp4
10 MB
45-Module Summary.mp4
650 kB
46-Course Summary.mp4
553 kB