Advanced SQL Server Performance Tuning

/08 Conclusion/

001 Thank you Lets Wrap Up This Course..html

/01 Introduction/

001 Content Warning. Please Dont Skip. Thanks..html

003 Section 1 Summary.html

002 Instructor Introduction..html

001 Whats In This Course.mp4

/07 Miscellaneous/

001 Enable Auto Update Stats Async.html

002 Section 7 Summary.html

/03 Caching Issues/

004 Simple Parameterization.mp4

005 Parameter Sniffing Demonstration.mp4

006 Fixing Parameter Sniffing.mp4

007 Plan Guides Demonstration.mp4

003 Procedure Cache Architecture.mp4

001 What Are Plan Guides.html

002 Section 3 Summary.html

001 What is the Buffer Pool.mp4

002 High Level Structure of Procedure Cache.mp4

/04 Hints and Filters/

004 Filtered Index With Massive Reduction In Logical Reads.mp4

002 Filtered Indexes.mp4

003 Filtered Indexes With Sparse Columns.mp4

001 Section 4 Summary.html

001 Using Index Hints For Comparing Index Effectiveness.mp4

/06 Real World Coding Best Practices Put To The Test/

003 Does SET NOCOUNT ON Really Help.mp4

002 Schema Qualified Objects.mp4

004 Batching Up Deletes And Updates Is A Must.mp4

005 Stop Sorting In The Database - Its Killing Your Queries.mp4

007 Taking The Load Off The Overburdened tempdb Database.mp4

006 Fixing Implicit Conversions.mp4

001 Section 6 Summary.html

001 Does Using Fewer Columns Really Matter.mp4

/05 Trace Flags. If You Feel Safe Using Them - And I Do, Then Start Here/

001 Trace Flag -T4199.mp4

001 Trace Flag -T3226.html

002 Section 5 Summary.html

002 Trace Flag -T1117.mp4

/02 Tools. These Two Tools Really Help Us Get A Deeper Grain To Our Tuning/

001 SET Statistics IO and SET Statistics Time On. What Do They Mean.mp4

001 Adding AdventureWorks. Its Free and Easy. We Will Use It In Our Demos..html

003 Summary 2 Summary.html

002 Query Plans With Plan Explorer. The Second Best Free Tool On The Market..mp4

002 Download Content Here.html

Total files 38