396.4 MB | 7min 39s | wmv | 1024X768 | 4:3
Genre:eLearning |Language:English

Files Included :
FileName :01 Course Introduction.wmv | Size: (1.58 MB)
FileName :02 Course Structure.wmv | Size: (906.25 KB)
FileName :01 Module Introduction.wmv | Size: (1.43 MB)
FileName :02 Which is the 'Good' Plan.wmv | Size: (4.16 MB)
FileName :03 Cardinality Estimates.wmv | Size: (2.52 MB)
FileName :04 Costing and Plan Quality.wmv | Size: (1.56 MB)
FileName :05 Operator Cost.wmv | Size: (1.44 MB)
FileName :06 Operator Cost.wmv | Size: (741.93 KB)
FileName :07 Operator Cost.wmv | Size: (1.97 MB)
FileName :08 Demo - Operator Cost.wmv | Size: (31.15 MB)
FileName :09 Operator Memory.wmv | Size: (1.62 MB)
FileName :10 Memory Operators.wmv | Size: (2.3 MB)
FileName :11 Under-estimates and Spills.wmv | Size: (1.69 MB)
FileName :12 Demo - Under-estimates and Spills.wmv | Size: (14.57 MB)
FileName :13 Over-estimates and Concurrency.wmv | Size: (1.97 MB)
FileName :14 Demo - Over-estimates and Concurrency.wmv | Size: (14.2 MB)
FileName :15 Impacted Query Optimizer Decisions.wmv | Size: (3.19 MB)
FileName :16 Excessive Resource Consumption.wmv | Size: (1.04 MB)
FileName :01 Module Introduction.wmv | Size: (900.38 KB)
FileName :02 Estimated Query Execution Plan.wmv | Size: (1.33 MB)
FileName :03 Actual Query Execution Plan.wmv | Size: (1.19 MB)
FileName :04 Capturing an Actual Plan.wmv | Size: (1.81 MB)
FileName :05 Demo - Capturing an Actual Plan.wmv | Size: (10.34 MB)
FileName :06 SQL Sentry Plan Explorer.wmv | Size: (1.36 MB)
FileName :07 Demo - SQL Sentry Plan Explorer.wmv | Size: (3.99 MB)
FileName :08 SQL Server 2012 Supplemental Information.wmv | Size: (2.29 MB)
FileName :09 Demo - Inaccurate Cardinality Estimate Event Capture.wmv | Size: (7.62 MB)
FileName :10 Demo - ConvertIssue Plan Attributes.wmv | Size: (6.03 MB)
FileName :11 Demo - Row Count Statistics in sys dm exec query stats.wmv | Size: (13.68 MB)
FileName :01 Module Introduction.wmv | Size: (771.27 KB)
FileName :02 Before Jumping In.wmv | Size: (1.91 MB)
FileName :03 Issue Prioritization.wmv | Size: (1.46 MB)
FileName :04 Missing or Stale Statistics.wmv | Size: (2.41 MB)
FileName :05 Demo - Checking sys databases.wmv | Size: (1.37 MB)
FileName :06 Demo - Checking sys stats and sp helpstats.wmv | Size: (3.86 MB)
FileName :07 Demo - Resolving NO RECOMPUTE Issues.wmv | Size: (19.24 MB)
FileName :08 Missing or Stale Statistics.wmv | Size: (1.99 MB)
FileName :09 Demo - Checking STATS DATE.wmv | Size: (4.16 MB)
FileName :10 Demo - Manual Statistics Updates.wmv | Size: (28.48 MB)
FileName :11 Demo - Using Trace Flag 2371.wmv | Size: (16.97 MB)
FileName :12 Sampling Issues.wmv | Size: (2.38 MB)
FileName :13 Demo - Using DBCC SHOW STATISTICS.wmv | Size: (5.58 MB)
FileName :14 Demo - Using sys dm db stats properties.wmv | Size: (7.15 MB)
FileName :15 Demo - Using FULLSCAN Manual Statistics Updates.wmv | Size: (16.4 MB)
FileName :16 Demo - Creating Filtered Statistics.wmv | Size: (11.4 MB)
FileName :17 Demo - Filtered Statistics Threshold Update Problem.wmv | Size: (11.85 MB)
FileName :18 Hidden Column Correlation.wmv | Size: (1.63 MB)
FileName :19 Demo - Hidden Column Correlation.wmv | Size: (33.54 MB)
FileName :20 Comparison of Intra-Table Columns.wmv | Size: (1.2 MB)
FileName :21 Demo - Comparison of Intra-Table Columns.wmv | Size: (5.66 MB)
FileName :22 Table Variable Usage.wmv | Size: (1.14 MB)
FileName :23 Demo - Table Variable Usage.wmv | Size: (7.91 MB)
FileName :24 Scalar and MSTV UDFs.wmv | Size: (1.86 MB)
FileName :25 Demo - MSTV UDFs.wmv | Size: (6.79 MB)
FileName :26 Parameter Sniffing.wmv | Size: (2.23 MB)
FileName :27 Demo - Parameter Sniffing.wmv | Size: (14.61 MB)
FileName :28 Implicit Data Type Conversion Issues.wmv | Size: (1.72 MB)
FileName :29 Complex Predicates.wmv | Size: (1.34 MB)
FileName :30 Demo - Complex Predicates.wmv | Size: (9.71 MB)
FileName :31 Query Complexity.wmv | Size: (3.01 MB)
FileName :32 Demo - Query Complexity.wmv | Size: (9.25 MB)
FileName :33 Hints.wmv | Size: (1.35 MB)
FileName :34 Demo - Hints.wmv | Size: (13.45 MB)
FileName :35 Distributed Queries.wmv | Size: (1.66 MB)
FileName :36 Query Optimizer Bugs.wmv | Size: (1.22 MB)
FileName :37 Course Summary.wmv | Size: (1.23 MB)]
Screenshot