Udemy - Mastering The Basics of SQL Server Query Optimization

294.26 MB | 4min 35s | mp4 | 1152X720 | 1.6:1
Genre:eLearning |Language:English

Files Included :
001 An Introduction to This Course.mp4 (7.91 MB)
004 The SQL Engine.mp4 (3.2 MB)
005 The Query Processing Process.mp4 (5.06 MB)
006 The Search Space.mp4 (5.18 MB)
007 Whats In the Cost.mp4 (2.27 MB)
008 Plan Cache Reuse.mp4 (3.84 MB)
009 What Causes Recompilation.mp4 (2.23 MB)
010 Terminology.mp4 (2.52 MB)
002 Anatomy of Execution Plan.mp4 (7.14 MB)
004 Execution Plan Output Options.mp4 (6.14 MB)
005 Scan VS Seek.mp4 (5.95 MB)
006 Scanning Demos.mp4 (7.76 MB)
007 Seeking Demos.mp4 (17.25 MB)
008 The Bookmark Lookup.mp4 (21.18 MB)
009 Aggregations.mp4 (9.91 MB)
010 Hash Match Operator.mp4 (21.79 MB)
011 Joins - The Nested Loop.mp4 (11.82 MB)
012 Join - The Merge Join.mp4 (6.29 MB)
013 Joins - The Hash Join.mp4 (7.01 MB)
014 Parallelism Introduction.mp4 (3.45 MB)
001 Statistics Contain 3 Key Pieces of Information in DBCC SHOW STATISTICS.mp4 (5.77 MB)
003 Anatomy of a Statistic Header,Vector and Histogram.mp4 (11.94 MB)
004 Out of Date Statistics.mp4 (6.74 MB)
005 Stale Statistics Demo.mp4 (9.7 MB)
006 Maintaining Statistics.mp4 (3.73 MB)
007 Setting Up Statistics Maintenance Job.mp4 (28.68 MB)
001 The Scan On Large Tables.mp4 (16.46 MB)
002 Using SET STATISTICS IO ON.mp4 (12.51 MB)
004 Non-Clustered Indexes on Heaps.mp4 (11.61 MB)
005 The No Good Sort Operator.mp4 (15.29 MB)
006 Unwinding The Spool.mp4 (13.42 MB)]
Screenshot