I show that, in some cases, INSTEAD OF triggers can be better for performance than AFTER triggers.

In this post, see what it took to migrate nearly 5,000 posts from the SQLPerformance.com Q&A site on AnswerHub to WordPress.

I talk about the pros and cons of letting SQL Server wait to get a more accurate cardinality estimate from a table variable.