The Curious Engineer

All blogs / Databases

Jimmy May, Aspiring Geek: SQL Server Performance, Best Practices, & Pr

learn.microsoft.com/en-us/archive/blogs/jimmymay

News you can use on implementation of the elusive sqlservr.exe /faster switch & personal effectiveness

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
44 from 1 Sep 2008 to 6 Nov 2014
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/jimmymay/feed.xml

2014 9

  1. #SQLPASS: To The Cloud, Infinity, & Beyond: Top 10 Lessons Learned at MSIT
  2. Spooked by Columnstore? See My Halloween Weekend Preso at #SQLSatOregon
  3. AdventureWorks 2014 Sample Databases Are Now Available
  4. Columnstore Case Study #2: Columnstore faster than SSAS Cube at DevCon Security
  5. Columnstore Case Study #1: MSIT SONAR Aggregations
  6. MSDN Whitepaper: More Cowbell—Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
  7. Columnstore Preso to the Oregon SQL Server User Group
  8. SQL Server 2014 Columnstore Indexes: The Big Deck
  9. Disk Partition Alignment: It Still Matters--DPA for Windows Server 2012, SQL Server 2012, and SQL Server 2014

2009 24

  1. Xperf: Install Windows Performance Toolkit (WPT) with 242MB Download, Not 2.5GB Windows 7 SDK: Part 2
  2. Xperf: Install Windows Performance Toolkit (WPT) with 242MB Download, Not the Entire 2.5GB Windows 7 SDK: Part 1
  3. SQLIOSim Parser by Jens Suessmeyer & Yours Truly
  4. Aspiring Geek Speaks This Week: PASS Minnesota
  5. xPerf: Once I Was Blind and Now I See
  6. SQL CAT New Whitepaper: Data Compression: Strategy, Capacity Planning and Best Practices by Sanjay Mishra, et al.
  7. Lured by Ward Pond, Chris Shaw’s Notorious SQL Quiz Ensnares Me In Its Web
  8. A World Without Google
  9. New Article on SQL CAT: Initializing a Transactional Replication Subscriber from an Array-Based Snapshot by Benjamin Wright-Jones
  10. Disk Partition Alignment (Sector Alignment): Make the Case: Save Hundreds of Thousands of Dollars
  11. A Language for Software Architecture by JD Meier in The Architecture Journal
  12. Wait Stats by Joe Sack
  13. Wait Stats Introductory References
  14. MSDN Blog Box Beefed Up and SProcs Tweaked For New! Improved! User Experience
  15. SQL Server 2008 SP1: Available Now at an Internet Near You
  16. Analyzing Storage Performance by Robert Smith on the Counter-of-the-Week (COTW) Blog
  17. Office Outlook 2007 CU/HotFix f/u: "Best version of Outlook ever" per MS VP Will Kennedy
  18. Disk I/O Case Study: Classic Case of SAN Over-Subscription
  19. Office Outlook 2007 CU: Hurry-Up-&-Wait Demon of Delay Begone!
  20. Does Your Blog Wordle Up?
  21. Disk I/O: Microsoft SQL Server on SAN Best Practices from SQL CAT's Mike Ruthruff (& Prem Mehra)
  22. VSTS Web Test Step-by-Step Primer: 7-Minute Video by Microsoft A.C.E. Performance Engineer Chris Lundquist (with Copious Notes and Screen Shots from Your Humble Correspondent)
  23. SSMS Query Results: “Include column headers when copying or saving the results"
  24. sp_reset_connection Does NOT Reset TRANSACTION ISOLATION LEVEL: Unexpected Behavior By Design

2008 11

  1. SQL Server Schema Best Practices from the SQL Server Customer Advisory Team (SQL CAT)
  2. Disk Partition Alignment (Sector Alignment) for SQL Server: Part 4: Essentials (Cheat Sheet)
  3. Case Study: Part 2: CXPACKET Wait Stats & 'max degree of parallelism' Option: Suppressing Query Parallelism Eliminated CXPACKET Waits & Liberated 30% of CPU
  4. Case Study: Part 1: CXPACKET Wait Stats & 'max degree of parallelism' Option: Introduction to Using Wait Stats to Identify & Remediate Query Parallelism Bottlenecks
  5. Disk Partition Alignment (Sector Alignment) for SQL Server: Part 3: PASS 2008
  6. Disk Partition Alignment (Sector Alignment) for SQL Server: Part 2: Adding HP EVA 8000 to Veritas Enterprise Administrator “Track Alignment Settings” Dialog
  7. Drum Roll, Please...The Debut of The SQL DMV All-Stars Dream Team!
  8. Is Twitter the YouTube of 2008?
  9. PerfMon Objects, Counters, Thresholds, & Utilities for SQL Server
  10. Disk Partition Alignment (Sector Alignment) for SQL Server: Part 1: Slide Deck
  11. SQL Server: 4-Step Performance Troubleshooting Methodology--Introduction