SWITCHOFFSET changes a datetimeoffset value from its stored time zone offset to a new one. Here is a quick example of how it works in SQL Server 2008.
Row Goals: Why TOP and EXISTS Change the Plan
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?
SQL Server: Why INSERT OUTPUT Does Not Prove a Commit
INSERT OUTPUT can return an identifier before a transaction commits. These tested examples show a rollback after a returned row and a pattern that returns results after commit.