The Curious Engineer

All blogs / Databases

SQL Server Performance

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

Best Practices, Tips, Benchmarks, Troubleshooting and Monitoring - SQL Server, ADO.NET, Analysis Services, and SSIS

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
35 from 24 Jan 2007 to 25 May 2011
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqlperf/feed.xml

2011 1

  1. The “Balanced Data Distributor” for SSIS

2010 1

  1. Kilimanjaro Ships!

2009 5

  1. New TPC Results on SQL Server 2008 R2
  2. Great New TPC-H Results with SQL Server 2008
  3. Using SSIS to get data out of Oracle: A big surprise!
  4. Great new SQL Server performance on Intel's Xeon 5500 series, aka Nehalem-EP
  5. An ETL World Record Revealed (Finally)

2008 6

  1. Windows Server 2008 + SQL Server 2008 = Geo-replication Benefits
  2. SQL Server is Movin' On Up!
  3. TPC-E – Raising the Bar in OLTP Performance
  4. SQL Server 2008 is on its way with great performance
  5. SQL Server 2008 launched today, with great performance and scalability
  6. ETL World Record!

2007 22

  1. Spool operators in query plan...
  2. What's swimming in your bufferpool?
  3. Adjust buffer size in SSIS data flow task
  4. Implement Parallel Execution in SSIS
  5. Something about SSIS Performance Counters
  6. Set BLOBTempStoragePath and BufferTempStoragePath to Fast Drives
  7. Set up OLE DB source to read from View efficiently
  8. Getting Optimal Performance with Integration Services Lookups
  9. What’s so temporary about tempdb?
  10. SQL Server 2005 SP2 Re-release and post fixes
  11. Microbenchmarking
  12. New MSDN Books Online search functionality
  13. SQL Server 2005 Performance Dashboard Reports
  14. OBJECT_NAME enhancement and OBJECT_SCHEMA_NAME addition in SQL Server 2005 SP2
  15. Two handy papers on common database performance considerations
  16. SQL Server 2005 SP2 has been released...
  17. High Volume Update Performance
  18. Storage Modes in Analysis Services
  19. Using SAN Volumes in Project REAL
  20. Analysis Services 2005 Performance Guide
  21. Database Applications Profile Survey
  22. Welcome!