The Curious Engineer

All blogs / Databases

SQL Programmability & API Development Team Blog

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

All posts are AS IS, without any further guarantees or warranties.

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

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

2009 6

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

2008 10

  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. How to create an autonomous transaction in SQL Server 2008
  4. UPDATE with OUTPUT clause – Triggers – and SQLMoreResults
  5. Use SQL Server replay tools to reproduce and resolve customer issues
  6. SQL Server Intermittent Connectivity Issue
  7. Using time zone data in SQL Server 2008
  8. Increase your SQL Server performance by replacing cursors with set operations
  9. Appending Data Using SQL 2008 Filestream
  10. Now is time to try SQL Server 2008

2007 22

  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. why cannot i GRANT EXECUTE permission on assemblies anymore ?
  6. Best Practices for SQL Server 2005
  7. 4.0 Useful Queries on DMV’s to understand Plan Cache Behavior
  8. 3.0 Changes in Caching Behavior between SQL Server 2000, SQL Server 2005 RTM and SQL Server 2005 SP2
  9. 2.0 Diagnosing Plan Cache Related Performance Problems and Suggested Solutions
  10. Trouble Shooting Query Performance Issues Related to Plan Cache in SQL 2005 RTM and SP1
  11. 11.0 Temporary Tables, Table Variables and Recompiles
  12. 10.0 Plan Cache Flush
  13. 9.0 Memory Pressure Limits
  14. 8.0 Factors that Affect Batch Cache-ability
  15. 7.0 Costing Cache Entries
  16. 6.0 Best Programming Practices
  17. 5.0 Retrieving Query Plans from Plan Cache DMV’s
  18. 3.0 How Cache Lookups Work
  19. 2.0 Sql_Handle and Plan_Handle Explained
  20. 1.0 Structure of the Plan Cache and Types of Cached Objects
  21. Plan Cache Concepts Explained
  22. Case-insensitive Search Operations

2006 45

  1. Knowing about 'Forwarded Records' can help diagnose hard to find performance issues.
  2. How are GUIDs compared in SQL Server 2005?
  3. Resolving Login Errors with Duplicated Databases
  4. XML: Typed and Untyped
  5. Implementing Login Statistics Using SQL Server 2005 Trace Feature
  6. SQL Server 2005 UNICODE considerations.
  7. SQL Server 2005 Debugging Requirements
  8. Three significant Cursor changes in SQL Server 2005
  9. Introducing Multiple Active Result Sets (MARS) (2)
  10. Impersonation in SQL CLR
  11. Assembly redirection and CLR Integration
  12. T-SQL text hashing in SQL Servers 2000 and 2005
  13. Satellite assemblies in SQL Server 2005
  14. TSQL Basics II - Parameter Passing Semantics
  15. Creating a CLR user define aggregate (part 2). Use multiple columns in the aggregation function
  16. Diagnosing CLR Execution in SQL Server
  17. Programmatically receiving profiler events (in real time) from SQL Server 2005
  18. XML Data Type Limitations
  19. TSQL Basics I: Stored Procedures In An Intrepreted Language
  20. Improving query plans with the SCHEMABINDING option on T-SQL UDFs
  21. Predicate ordering is not guaranteed
  22. What are the different cached objects in the plan cache?
  23. Plan Guides Are Your Best Friends
  24. Introducing Multiple Active Result Sets (MARS) (1)
  25. Overview of T-SQL and CLR debugging in SQL Server 2005
  26. Cursors and memory scalability in SQL Server 2005
  27. Check Out Denis Ruckebusch's Blog
  28. Dealing with the Limitations of XSD Content Models
  29. Exception handling in SQLCLR
  30. XML processing with XQuery (part 1)
  31. An article on FOR XML in Microsoft SQL Server 2000 and 2005
  32. What does server side FOR XML return?
  33. Strong named assemblies and AllowPartiallyTrustedCallers
  34. Server Side Error Handling - Part 3 (Why do I still see error messages from inside tsql try-block?)
  35. Sorting undefined characters in Unicode and/or Windows collation
  36. SQL Server Identity column FAQs
  37. Name resolution, default schema, implicit schema Part IV
  38. Name resolution, default schema, implicit schema Part III
  39. Name resolution, default schema, implicit schema Part II
  40. Name resolution, default schema, implicit schema Part I
  41. Server Side Error Handling - Part 2 (Errors and Error Messages)
  42. Server Side Error Handling - Part 1 (Migrating from @@error to tsql try-catch)
  43. Host Policy level Permission Sets and their permissions
  44. Multiplication and Division with Numerics
  45. Newsequentialid (Histrory/Benefits and Implementation)