The Curious Engineer

All blogs / Databases

Ian Jose's WebLog

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

This weblog is intended to help T-SQL developers get the best performing query plans from SQL Server. Some of the posts describe simple mistakes that can be easily avoided. Other posts describe complex solutions to limitations in SQL Server. Lastly, so

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’05’10’15’20’25
Posts
15 from 10 Nov 2005 to 24 Apr 2006
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/ianjo/feed.xml

2006 4

  1. Ascending Keys and Auto Quick Corrected Statistics
  2. Query Processor Modelling Extensions in SQL Server 2005 SP1
  3. Disabling Constant-Constant Comparison Estimation
  4. Make Functions Schema-bound

2005 11

  1. Regularly Update Statistics for Ascending Keys
  2. Create Statistics for All Union Inputs
  3. Create Multi-Column Statistics
  4. Auto-create and Auto-update Statistics
  5. Simplify statements with IF
  6. Limit Use of Multi-Statement TVFs and Table Variables
  7. Use Condition-Specific Stored Procedures
  8. Use Function Results
  9. Limit Non-order Preserving Expressions
  10. Avoid Unnecessary Data Type Conversions
  11. Use Parameters or Literals for Query Inputs