Download SQL Server: Common Query Tuning Problems and Solutions - Part 1 [2014, ENG] Torrent

SQL Server: Common Query Tuning Problems and Solutions - Part 1 [2014, ENG]

01. Course Introduction

02. Validating Assumptions

02_01-Module Introduction.mp4	MP4	1.68 MB
02_02-Downstream Impact of Bad Assumptions.mp4	MP4	2.08 MB
02_03-Cardinality Estimation and Predicates.mp4	MP4	1.91 MB
02_04-Selectivity.mp4	MP4	1.12 MB
02_05-Query Cardinality Questions.mp4	MP4	1.88 MB
02_06-Cardinality Estimate Inputs.mp4	MP4	1.08 MB
02_07-Statistics.mp4	MP4	1.16 MB
02_08-Demo DBCC SHOW_STATISTICS STAT_HEADER.mp4	MP4	14.67 MB
02_09-Demo DBCC SHOW_STATISTICS DENSITY_VECTOR.mp4	MP4	7.71 MB
02_10-Demo DBCC SHOW_STATISTICS HISTOGRAM.mp4	MP4	19.23 MB
02_11-Demo Histogram Direct Step Hit.mp4	MP4	14.68 MB
02_12-Demo Scaling the Estimate.mp4	MP4	21.73 MB
02_13-Demo Histogram Intra-Step Hit.mp4	MP4	16.71 MB
02_14-Demo Density Vector With an Unknown Runtime Value.mp4	MP4	20.91 MB
02_15-Demo Parameter Sniffed Value Estimation.mp4	MP4	22.46 MB
02_16-Demo Distinct Value Estimation.mp4	MP4	10.8 MB
02_17-Impact to Query Execution and Performance.mp4	MP4	1.2 MB
02_18-Identifying Bad Assumptions - 1.mp4	MP4	1.38 MB
02_19-Demo Viewing Estimated Vs. Actual Row Counts.mp4	MP4	19.02 MB
02_20-Identifying Bad Assumptions - 2.mp4	MP4	1.31 MB
02_21-Demo sys.dm_exec_query_profiles.mp4	MP4	6.32 MB
02_22-Demo Root-level Skews via sys.dm_exec_query_stats.mp4	MP4	29.2 MB
02_23-What Variance is Problematic.mp4	MP4	1.5 MB
02_24-Module Summary.mp4	MP4	1.35 MB

03. Troubleshooting Bad Assumptions

03_01-Module Introduction.mp4	MP4	1.31 MB
03_02-Model Assumptions.mp4	MP4	2.43 MB
03_03-Demo Jagged Distributions.mp4	MP4	36.46 MB
03_04-Demo Correlated Predicates.mp4	MP4	28.23 MB
03_05-Demo Correlated Predicates in SQL Server 2014.mp4	MP4	31.14 MB
03_06-Demo Correlated Join Predicates, Independent Filter Predicates.mp4	MP4	20.82 MB
03_07-Demo Searching for Off-Histogram Values.mp4	MP4	21.35 MB
03_08-Demo Searching for Off-Histogram Values in SQL Server 2014.mp4	MP4	20.47 MB
03_09-Troubleshooting Questions - 1.mp4	MP4	1.84 MB
03_10-Demo Missing Statistics.mp4	MP4	18.58 MB
03_11-Demo Selectivity Guesses.mp4	MP4	23.63 MB
03_12-Demo Stale Statistics.mp4	MP4	26.07 MB
03_13-Demo Inadequate Sampling.mp4	MP4	36.22 MB
03_14-Demo Parameter Sensitivity.mp4	MP4	27.42 MB
03_15-Demo Table Variable Usage.mp4	MP4	11.3 MB
03_16-Demo MSTVF Usage - Part 1.mp4	MP4	21.26 MB
03_17-Demo MSTVF Usage - Part 2.mp4	MP4	13.22 MB
03_18-Demo MSTVF Usage - Part 3.mp4	MP4	7.25 MB
03_19-Troubleshooting Questions - 2.mp4	MP4	2.66 MB
03_20-Demo Data Type Conversions.mp4	MP4	24.17 MB
03_21-Demo Buried Predicates - Part 1.mp4	MP4	10.6 MB
03_22-Demo Buried Predicates - Part 2.mp4	MP4	11.75 MB
03_23-Module Summary.mp4	MP4	820.44 KB

04. Tuning Imprecision Problems

04_01-Module Introduction.mp4	MP4	1.91 MB
04_02-Demo SELECT .mp4	MP4	14.45 MB
04_03-Demo Unnecessary Sorts.mp4	MP4	11.99 MB
04_04-Demo Needless DISTINCT.mp4	MP4	13.95 MB
04_05-Demo UNION Vs. UNION ALL.mp4	MP4	14.83 MB
04_06-Demo Leading Wildcards.mp4	MP4	14.55 MB
04_07-Demo Hidden Cartesian Products.mp4	MP4	11.34 MB
04_08-Demo Data Type Conversion Issues.mp4	MP4	17.7 MB
04_09-Demo Redundant Logic and Overlapping Object References.mp4	MP4	18.39 MB
04_10-Module and Course Summary.mp4	MP4	1.26 MB

Exercise files

ZIP

2.02 MB

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Optimize Vector Search with Indexes in SQL Server 2025 Posted by freecoursewb in Other Posted in Other 3 262.4 MB 4 months ago freecoursewb	Size 262.4 MB	Files 30	Age 4 months ago	Seeds 3	Leechs 4	Source
Udemy - SCADA Reports with SQL Server reporting service(SSRS) Posted by freecoursewb in Other Posted in Other 7 1.8 GB 7 months ago freecoursewb	Size 1.8 GB	Files 9	Age 7 months ago	Seeds 7	Leechs 8	Source
Udemy - Ultimate SQL Beginner to Intermediate Guide using SQL Server Posted by freecoursewb in Other Posted in Other 5 3 GB 8 months ago freecoursewb	Size 3 GB	Files 71	Age 8 months ago	Seeds 5	Leechs 1	Source
Udemy - SQL Server Triggers Part7- Advance Level Posted by freecoursewb in Other Posted in Other 4 1.3 GB 11 months ago freecoursewb	Size 1.3 GB	Files 11	Age 11 months ago	Seeds 4	Leechs 3	Source
Learn Microsoft SQL Server 2025 Posted by freecoursewb in Other Posted in Other 0 1.6 GB 1 year ago freecoursewb	Size 1.6 GB	Files 24	Age 1 year ago	Seeds 0	Leechs 0	Source

SQL Server: Common Query Tuning Problems and Solutions - Part 1 [2014, ENG]

Tracker name
http://bt3.t-ru.org/ann?magnet
http://bt1.t-ru.org/ann
http://bt2.t-ru.org/ann
http://bt4.t-ru.org/ann
udp://tracker.opentrackr.org:1337
udp://open.stealth.si:80/announce
udp://tracker.torrent.eu.org:451/announce
udp://exodus.desync.com:6969
udp://open.demonii.com:1337/announce
udp://tracker.coppersurfer.tk:6969
udp://p4p.arenabg.com:1337
udp://tracker.internetwarriors.net:1337