I presented two sessions at TechInsight 2010 in Kuala Lumpur, Malaysia, from June 29 to July 1, 2010. The best part of the trip was the people and their response.
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.
SQL SERVER – Outer Join Not Allowed in Indexed Views
Why is OUTER JOIN not allowed in indexed views? A reader was confused by the white paper answer, so I explain it with an example and ask for yours.
SQL SERVER – Default Statistics on Column – Automatic Statistics on Column
Does a column need an index to have statistics? No. A quick demo shows automatic statistics on column data when AUTO_CREATE_STATISTICS is on.
SQL SERVER – MERGE Insert Update and Delete with an Isolated Example
Merge Operations can combine conditional inserts, updates and deletes. I inspect the plan before making any claim about scans or speed.
SQL SERVER – Subquery or Join – Various Options – SQL Server Engine Knows the Best – Part 2
In part 2, Paulo R. Pereira compares IN, EXISTS, SOME and JOIN plans, and shows again that the SQL Server Engine knows the best plan for a query.
SQL SERVER – Subquery or Join – Various Options – SQL Server Engine knows the Best
Subquery or join, IN or EXISTS? Four queries return the same result, and the execution plans show the SQL Server engine knows the best way to run them.