geometry MakeValid returns a valid geometry from an invalid instance, but the result can change type. I keep the original beside the proposed repair. A validity flag alone does not describe everything that changed.
SQL SERVER – Computed Column and Performance – Part 3
Part 3 of my series on computed column and performance shows how an index improves the performance of a computed column. Read the earlier parts first.
SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server
A query tuning visit turned into a lesson on why running SHRINKDATABASE for every database is a bad idea. Here is what happened at the client’s office.
SQL SERVER – Parallelism Query in Database
Feodor asked how to get a parallelism query plan on a dual core computer using AdventureWorks. Here is the T-SQL I used to reproduce a parallel plan.
SQL SERVER – Computed Column – PERSISTED and Performance – Part 2
Part 2 on PERSISTED and performance shows the other side: when non-persisted computed columns give better performance than PERSISTED ones.
SQL SERVER – Computed Column – PERSISTED and Performance
My computed column series in one list: PERSISTED versus non-persisted for storage and speed, and how an index on the column improves performance.
Relational Division in T-SQL: Customers Who Bought Every Product
Solve relational division with counts and double NOT EXISTS, then handle duplicates, NULL values, empty requirements, and exact matching.







