The Curious Engineer

All blogs / Databases

Tips, Tricks, and Advice from the SQL Server Query Optimization Team

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

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
24 from 24 Mar 2006 to 20 Sep 2006
Posting
archived, read-only
Kind
project news
Feed
https://learn.microsoft.com/en-us/archive/blogs/queryoptteam/feed.xml

2006 24

  1. Renaming/Moving Blog
  2. SQL Customer Advisory Team
  3. How to Read Statistics Profile
  4. Locking Backgrounder
  5. UPDATE STATISTICS undocumented options
  6. Hints for DML queries
  7. Non updating updates
  8. Fun for the day - Automated Auto-Indexing!
  9. Row Goals revisited - FAST hint guidance
  10. Ordering Guarantees in SQL Server 2005
  11. Local-Global Aggregation
  12. T-SQL Procedural Blog
  13. Sorted Seeks
  14. Indexed Views in SQL Server 2005
  15. Optimizing Distributed Queries
  16. Why should I create an index?
  17. I Smell a Parameter!
  18. Row Goals in Action
  19. Migrating Cardinality Eestimation Posts from Previous Blog
  20. TOP 100 Percent ORDER BY Considered Harmful.
  21. Using Computed Columns to Fix Scalar Expression Estimation Errors
  22. Query Recompilation Details
  23. Statistics in SQL Server 2005 White Paper
  24. Greetings!