Advanced SQL Server Performance Tuning

  • CategoryOther
  • TypeTutorials
  • LanguageEnglish
  • Total size369.4 MB
  • Uploaded Bygroovymax123
  • Downloads198
  • Last checkedJun. 14th '18
  • Date uploadedJun. 20th '16
  • Seeders 2
  • Leechers0

Infohash : AFCB8D22FF83FB1FB45FC423C5DF17563278FAFA

Advanced SQL Server Performance Tuning

================
[COVER:]
================



================
[INFO:]
================

Advanced SQL Server Performance Tuning
MP4 | Video: 1280x720 | 53 kbps | 44 KHz | Duration: 2 Hours | 369 MB
Genre: eLearning | Language: English

A Pragmatic Real World Approach To Tuning SQL Server.


This course focuses on making SQL Server perform more optimally.

In my first course we laid the groundwork by tuning OUR instances with a top down approach.

WE will continue on that path with this course.

Even though the course has the word “Advanced" in it, there's NOTHING COMPLICATED about taking what's in the course and applying it in the real word.




Please use 7Zip/WinRAR/Universal Extractor to EXTRACT FILES

If You Like This Torrent Support the Authors by Purchasing It!.. Thanx






Files:

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)
  • 003 Section 1 Summary.html (1.8 KB)
  • 002 Instructor Introduction..html (2.6 KB)
  • 001 Whats In This Course.mp4 (4.5 MB)
07 Miscellaneous
  • 001 Enable Auto Update Stats Async.html (4.0 KB)
  • 002 Section 7 Summary.html (1.7 KB)
03 Caching Issues
  • 004 Simple Parameterization.mp4 (4.4 MB)
  • 005 Parameter Sniffing Demonstration.mp4 (32.1 MB)
  • 006 Fixing Parameter Sniffing.mp4 (31.5 MB)
  • 007 Plan Guides Demonstration.mp4 (10.5 MB)
  • 003 Procedure Cache Architecture.mp4 (8.6 MB)
  • 001 What Are Plan Guides.html (2.0 KB)
  • 002 Section 3 Summary.html (3.3 KB)
  • 001 What is the Buffer Pool.mp4 (3.5 MB)
  • 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 (13.8 MB)
  • 002 Filtered Indexes.mp4 (20.5 MB)
  • 003 Filtered Indexes With Sparse Columns.mp4 (6.0 MB)
  • 001 Section 4 Summary.html (2.7 KB)
  • 001 Using Index Hints For Comparing Index Effectiveness.mp4 (19.0 MB)
06 Real World Coding Best Practices Put To The Test
  • 003 Does SET NOCOUNT ON Really Help.mp4 (8.7 MB)
  • 002 Schema Qualified Objects.mp4 (38.1 MB)
  • 004 Batching Up Deletes And Updates Is A Must.mp4 (17.0 MB)
  • 005 Stop Sorting In The Database - Its Killing Your Queries.mp4 (37.6 MB)
  • 007 Taking The Load Off The Overburdened tempdb Database.mp4 (29.7 MB)
  • 006 Fixing Implicit Conversions.mp4 (14.2 MB)
  • 001 Section 6 Summary.html (2.9 KB)
  • 001 Does Using Fewer Columns Really Matter.mp4 (21.4 MB)
05 Trace Flags. If You Feel Safe Using Them - And I Do, Then Start Here
  • 001 Trace Flag -T4199.mp4 (10.0 MB)
  • 001 Trace Flag -T3226.html (2.3 KB)
  • 002 Section 5 Summary.html (2.4 KB)
  • 002 Trace Flag -T1117.mp4 (16.0 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)
  • 001 Adding AdventureWorks. Its Free and Easy. We Will Use It In Our Demos..html (2.0 KB)
  • 003 Summary 2 Summary.html (2.1 KB)
  • 002 Query Plans With Plan Explorer. The Second Best Free Tool On The Market..mp4 (12.2 MB)
  • 002 Download Content Here.html (1.2 KB)

Code:

  • udp://11.rarbg.com:80/announce
  • udp://11.rarbg.me/announce
  • udp://9.rarbg.com:2710/announce
  • udp://tracker.openbittorrent.com:80/announce
  • udp://glotorrents.pw:6969
  • udp://11.rarbg.com/announce
  • udp://9.rarbg.to:2710/announce
  • udp://tracker.opentrackr.org:1337/announce
  • udp://glotorrents.pw:6969/announce
  • http://tracker.aletorrenty.pl:2710/announce
  • http://tracker.pubt.net:2710/announce
  • udp://tracker.xelion.fr:6969/announce
  • udp://9.rarbg.me:2710/announce
  • udp://open.demonii.com:1337/announce
  • udp://tracker.flashtorrents.org:6969/announce