Advanced SQL Server Performance Tuning

File Name

Size

08 Conclusion/001 Thank you Lets Wrap Up This Course..html

2.5 kB

01 Introduction/001 Content Warning. Please Dont Skip. Thanks..html

2.6 kB

01 Introduction/003 Section 1 Summary.html

1.8 kB

01 Introduction/002 Instructor Introduction..html

2.6 kB

01 Introduction/001 Whats In This Course.mp4

4.5 MB

07 Miscellaneous/001 Enable Auto Update Stats Async.html

4.0 kB

07 Miscellaneous/002 Section 7 Summary.html

1.7 kB

03 Caching Issues/004 Simple Parameterization.mp4

4.4 MB

03 Caching Issues/005 Parameter Sniffing Demonstration.mp4

32 MB

03 Caching Issues/006 Fixing Parameter Sniffing.mp4

32 MB

03 Caching Issues/007 Plan Guides Demonstration.mp4

10 MB

03 Caching Issues/003 Procedure Cache Architecture.mp4

8.6 MB

03 Caching Issues/001 What Are Plan Guides.html

2.0 kB

03 Caching Issues/002 Section 3 Summary.html

3.3 kB

03 Caching Issues/001 What is the Buffer Pool.mp4

3.5 MB

03 Caching Issues/002 High Level Structure of Procedure Cache.mp4

2.6 MB

04 Hints and Filters/004 Filtered Index With Massive Reduction In Logical Reads.mp4

14 MB

04 Hints and Filters/002 Filtered Indexes.mp4

20 MB

04 Hints and Filters/003 Filtered Indexes With Sparse Columns.mp4

6.0 MB

04 Hints and Filters/001 Section 4 Summary.html

2.7 kB

04 Hints and Filters/001 Using Index Hints For Comparing Index Effectiveness.mp4

19 MB

06 Real World Coding Best Practices Put To The Test/003 Does SET NOCOUNT ON Really Help.mp4

8.7 MB

06 Real World Coding Best Practices Put To The Test/002 Schema Qualified Objects.mp4

38 MB

06 Real World Coding Best Practices Put To The Test/004 Batching Up Deletes And Updates Is A Must.mp4

17 MB

06 Real World Coding Best Practices Put To The Test/005 Stop Sorting In The Database - Its Killing Your Queries.mp4

38 MB

06 Real World Coding Best Practices Put To The Test/007 Taking The Load Off The Overburdened tempdb Database.mp4

30 MB

06 Real World Coding Best Practices Put To The Test/006 Fixing Implicit Conversions.mp4

14 MB

06 Real World Coding Best Practices Put To The Test/001 Section 6 Summary.html

2.9 kB

06 Real World Coding Best Practices Put To The Test/001 Does Using Fewer Columns Really Matter.mp4

21 MB

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

10 MB

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

2.3 kB

05 Trace Flags. If You Feel Safe Using Them - And I Do, Then Start Here/002 Section 5 Summary.html

2.4 kB

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

16 MB

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

7.6 MB

02 Tools. These Two Tools Really Help Us Get A Deeper Grain To Our Tuning/001 Adding AdventureWorks. Its Free and Easy. We Will Use It In Our Demos..html

2.0 kB

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

2.1 kB

02 Tools. These Two Tools Really Help Us Get A Deeper Grain To Our Tuning/002 Query Plans With Plan Explorer. The Second Best Free Tool On The Market..mp4

12 MB

02 Tools. These Two Tools Really Help Us Get A Deeper Grain To Our Tuning/002 Download Content Here.html

1.2 kB