Inspect row goals from TOP and EXISTS, read EstimateRowsWithoutRowGoal, and compare a targeted optimizer hint using actual plans.
SQL SERVER – How do I Learn and How do I Teach
How do I learn and how do I teach? My T-SQL Tuesday answer looks back at my teachers and books as a kid and at what I am learning and teaching today.
Unsigned Integers: Safe Type and Range Mapping
Map unsigned integers to SQL Server types without narrowing their range. Keep strict source-text validation separate from destination CHECK constraints.
SQL SERVER – Parallelism – Row per Processor – Row per Thread – Thread 0
What does Thread 0 in a parallel execution plan mean? Reader Marko Parkkola gave the best answer: it synchronizes the other threads. Here it is in detail.
SQLAuthority News – Milestone – 1400th Post and Why do I blog
My 1400th post looks back at the journey I started on Nov 1, 2006, and gives an honest answer to a question I hear a lot: why do I blog?
SQLAuthority News – I am a MVP and I Love SQL Server
Yes, I am a MVP for the third year in a row. I thank everyone who helped me and answer the questions I often get about the MVP Program.
SQL SERVER – The Self Join – Inner Join and Outer Join
Is a Self Join an inner join or an outer join? It can be either. I build a small new example that shows Self Join as inner join and outer join.