Download Sql Server - Troubleshooting Query Plan Quality Issues [2013, ENG] Torrent

Torrent Contents Size: 396.4 MB

Sql Server - Troubleshooting Query Plan Quality Issues [2013, ENG]

01.Course Introduction

	01.Course Introduction.wmv	WMV	1.58 MB
	02.Course Structure.wmv	WMV	906.25 KB

02.Why Query Plan Quality Matters

01.Module Introduction.wmv	WMV	1.43 MB
02.Which is the 'Good' Plan.wmv	WMV	4.16 MB
03.Cardinality Estimates.wmv	WMV	2.52 MB
04.Costing and Plan Quality.wmv	WMV	1.56 MB
05.Operator Cost (1).wmv	WMV	1.44 MB
06.Operator Cost (2).wmv	WMV	741.93 KB
07.Operator Cost (3).wmv	WMV	1.97 MB
08.Demo - Operator Cost.wmv	WMV	31.15 MB
09.Operator Memory.wmv	WMV	1.62 MB
10.Memory Operators.wmv	WMV	2.3 MB
11.Under-estimates and Spills.wmv	WMV	1.69 MB
12.Demo - Under-estimates and Spills.wmv	WMV	14.57 MB
13.Over-estimates and Concurrency.wmv	WMV	1.97 MB
14.Demo - Over-estimates and Concurrency.wmv	WMV	14.2 MB
15.Impacted Query Optimizer Decisions.wmv	WMV	3.19 MB
16.Excessive Resource Consumption.wmv	WMV	1.04 MB

03.Identifying Query Plan Quality Issues

01.Module Introduction.wmv	WMV	900.38 KB
02.Estimated Query Execution Plan.wmv	WMV	1.33 MB
03.Actual Query Execution Plan.wmv	WMV	1.19 MB
04.Capturing an Actual Plan.wmv	WMV	1.81 MB
05.Demo - Capturing an Actual Plan.wmv	WMV	10.34 MB
06.SQL Sentry Plan Explorer.wmv	WMV	1.36 MB
07.Demo - SQL Sentry Plan Explorer.wmv	WMV	3.99 MB
08.SQL Server 2012 Supplemental Information.wmv	WMV	2.29 MB
09.Demo - Inaccurate Cardinality Estimate Event Capture.wmv	WMV	7.62 MB
10.Demo - ConvertIssue Plan Attributes.wmv	WMV	6.03 MB
11.Demo - Row Count Statistics in sys.dm_exec_query_stats.wmv	WMV	13.68 MB

04.Query Plan Quality Patterns and Resolutions

01.Module Introduction.wmv	WMV	771.27 KB
02.Before Jumping In....wmv	WMV	1.91 MB
03.Issue Prioritization.wmv	WMV	1.46 MB
04.Missing or Stale Statistics (1).wmv	WMV	2.41 MB
05.Demo - Checking sys.databases.wmv	WMV	1.37 MB
06.Demo - Checking sys.stats and sp_helpstats.wmv	WMV	3.86 MB
07.Demo - Resolving NO_RECOMPUTE Issues.wmv	WMV	19.24 MB
08.Missing or Stale Statistics (2).wmv	WMV	1.99 MB
09.Demo - Checking STATS_DATE.wmv	WMV	4.16 MB
10.Demo - Manual Statistics Updates.wmv	WMV	28.48 MB
11.Demo - Using Trace Flag 2371.wmv	WMV	16.97 MB
12.Sampling Issues.wmv	WMV	2.38 MB
13.Demo - Using DBCC SHOW_STATISTICS.wmv	WMV	5.58 MB
14.Demo - Using sys.dm_db_stats_properties.wmv	WMV	7.15 MB
15.Demo - Using FULLSCAN Manual Statistics Updates.wmv	WMV	16.4 MB
16.Demo - Creating Filtered Statistics.wmv	WMV	11.4 MB
17.Demo - Filtered Statistics Threshold Update Problem.wmv	WMV	11.85 MB
18.Hidden Column Correlation.wmv	WMV	1.63 MB
19.Demo - Hidden Column Correlation.wmv	WMV	33.54 MB
20.Comparison of Intra-Table Columns.wmv	WMV	1.2 MB
21.Demo - Comparison of Intra-Table Columns.wmv	WMV	5.66 MB
22.Table Variable Usage.wmv	WMV	1.14 MB
23.Demo - Table Variable Usage.wmv	WMV	7.91 MB
24.Scalar and MSTV UDFs.wmv	WMV	1.86 MB
25.Demo - MSTV UDFs.wmv	WMV	6.79 MB
26.Parameter Sniffing.wmv	WMV	2.23 MB
27.Demo - Parameter Sniffing.wmv	WMV	14.61 MB
28.Implicit Data Type Conversion Issues.wmv	WMV	1.72 MB
29.Complex Predicates.wmv	WMV	1.34 MB
30.Demo - Complex Predicates.wmv	WMV	9.71 MB
31.Query Complexity.wmv	WMV	3.01 MB
32.Demo - Query Complexity.wmv	WMV	9.25 MB
33.Hints.wmv	WMV	1.35 MB
34.Demo - Hints.wmv	WMV	13.45 MB
35.Distributed Queries.wmv	WMV	1.66 MB
36.Query Optimizer Bugs.wmv	WMV	1.22 MB
37.Course Summary.wmv	WMV	1.23 MB

Description

Show full description

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 - Troubleshooting Query Plan Quality Issues [2013, ENG]

Torrent Contents Size: 396.4 MB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
http://bt4.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