The Curious Engineer

All blogs / Databases

Microsoft SQLCAT ISV Program Management Team

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

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’10’15’20’25
Posts
35 from 15 Mar 2006 to 29 Jul 2009
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/mssqlisv/feed.xml

2009 7

  1. Asynchronous Population of a Cursor May Result in Performance Degradation
  2. Interesting issue with Filtered indexes.
  3. Why did the size of my indexes expand when I rebuilt my indexes?
  4. SQL Server 2005 / 2008 table partitioning : Important things to consider when switching-out partitions.
  5. Avoid using JDK Date APIs to handle timezone sensitive date and time
  6. Zeroing in on blocking on seemingly unrelated tables
  7. Using SQL Server 2008 Management Data Warehouse for database monitoring in my application

2008 11

  1. OPTIMIZE FOR UNKNOWN – a little known SQL Server 2008 feature
  2. SQL Server 2008 : new binary – hex string conversion functionality can dramatically improve related query performance by orders of magnitude.
  3. Designing Composite Indexes
  4. How to create an autonomous transaction in SQL Server 2008
  5. UPDATE with OUTPUT clause – Triggers – and SQLMoreResults
  6. Use SQL Server replay tools to reproduce and resolve customer issues
  7. SQL Server Intermittent Connectivity Issue
  8. Using time zone data in SQL Server 2008
  9. Increase your SQL Server performance by replacing cursors with set operations
  10. Appending Data Using SQL 2008 Filestream
  11. Now is time to try SQL Server 2008

2007 6

  1. Detecting Overlapping Indexes in SQL Server 2005
  2. New SQL Best Practice Articles now available
  3. Will 64-bit increase the performance of my SQL Server application?
  4. Upgrading to SQL Server 2005 and DEFAULT_SCHEMA setting.
  5. Best Practices for SQL Server 2005
  6. Case-insensitive Search Operations

2006 11

  1. Knowing about 'Forwarded Records' can help diagnose hard to find performance issues.
  2. Resolving Login Errors with Duplicated Databases
  3. SQL Server 2005 UNICODE considerations.
  4. Three significant Cursor changes in SQL Server 2005
  5. The Perils of Multi-valued logic
  6. SQL 2000 SP4 behavior change when using API cursors to be aware of.
  7. SQL Optimizations - Manual Update statistics on small tables may provide a big impact.
  8. SQL Optimizations – A well concealed transform that can cut that much needed millisecond out of your query.
  9. SQL Server 2005 Service Pack 1 Released
  10. How to Block fetch over a Default Result Set
  11. Stay tuned for the SQL Server ISV Program Management Team BLOG