The Curious Engineer

All blogs / Databases

Craig Freedman's SQL Server Blog

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

A discussion of query processing, query execution, and query plans in SQL Server.

DatabasesPerformance / optimizationAlgorithms / data structuresMicrosoft blogsMSDN archive

’10’15’20’25
Posts
74 from 7 Jun 2006 to 29 Mar 2019
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/craigfr/feed.xml

2019 1

  1. We have moved!

2010 1

  1. More on Implicit Conversions

2009 6

  1. Correction to my prior post on sys.dm_db_index_operational_stats
  2. Maximum Row Size and Query Hints
  3. Implied Predicates and Query Hints
  4. OPTIMIZED Nested Loops Joins
  5. Optimizing I/O Performance by Sorting – Part 2
  6. Optimizing I/O Performance by Sorting – Part 1

2008 16

  1. What is the difference between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats?
  2. Random Prefetching
  3. Sequential Read Ahead
  4. Dynamic Partition Elimination Performance
  5. Partitioned Indexes in SQL Server 2008
  6. Partitioned Tables in SQL Server 2008
  7. Subqueries in BETWEEN and CASE Statements
  8. Implicit Conversions
  9. Query Processing Presentation
  10. Conversion and Arithmetic Errors: Change between SQL Server 2000 and 2005
  11. Conversion and Arithmetic Errors
  12. Ranking Functions: RANK, DENSE_RANK, and NTILE
  13. Ranking Functions: ROW_NUMBER
  14. Halloween Protection
  15. Maintaining Unique Indexes with IGNORE_DUP_KEY
  16. Partial Aggregation

2007 22

  1. Recursive CTEs continued ...
  2. Recursive CTEs
  3. CTEs (Common Table Expressions)
  4. GROUPING SETS in SQL Server 2008
  5. Aggregation WITH CUBE
  6. Aggregation WITH ROLLUP
  7. Maintaining Unique Indexes
  8. Optimized Non-clustered Index Maintenance in Per-Index Plans
  9. Optimized Non-clustered Index Maintenance
  10. More on TOP
  11. ROWCOUNT Top
  12. The UNPIVOT Operator
  13. PIVOT Query Plans
  14. The PIVOT Operator
  15. Read Committed and Bookmark Lookup
  16. Read Committed and Large Objects
  17. Read Committed and Updates
  18. Serializable vs. Snapshot Isolation Level
  19. Repeatable Read Isolation Level
  20. Query Plans and Read Committed Isolation Level
  21. Read Committed Isolation Level
  22. Parallel Query Execution Presentation

2006 28

  1. Semi-join Transformation
  2. Introduction to Partitioned Tables
  3. Parallel Hash Join
  4. Parallel Nested Loops Join
  5. Parallel Scan
  6. The Parallelism Operator (aka Exchange)
  7. Index Union
  8. Introduction to Parallel Query Execution
  9. Decorrelating Subqueries
  10. Scalar Subqueries
  11. Hash Aggregate
  12. Stream Aggregate
  13. Aggregation
  14. Subqueries: ANDs and ORs
  15. Subqueries in CASE Expressions
  16. Summary of Join Properties
  17. Hash Join
  18. Merge Join
  19. Nested Loops Join
  20. Introduction to Joins
  21. Index Examples and Tradeoffs
  22. Seek Predicates
  23. Bookmark Lookup
  24. Scans vs. Seeks
  25. Properties of Iterators
  26. Viewing Query Plans
  27. The Building Blocks of Query Execution
  28. Why am I starting this blog?