Itzik Ben-Gan steps through an interesting reader submission for his "Special Islands" challenge from last month, with some surprising performance implications.
Aaron Bertrand talks about the top 10 wait types we see among our SentryOne customer base, and where to turn when you're experiencing one of them on your own system.
For this month's T-SQL Tuesday, Aaron Bertrand shows that when triggers are necessary, in some cases INSTEAD OF triggers can be better for performance than AFTER triggers.
Aaron Bertrand describes the process of migrating nearly 5,000 posts from the SQLPerformance.com Q&A site on AnswerHub to its new read-only home on WordPress.
Glenn Berry lays out a convincing argument to upgrade to a modern version of SQL Server – considering not only the platform improvements but also changes to Windows, storage, and hardware.
Jonathan Kehayias shares insight about new UDF information in showplan, and shows that only some tools will show it (SSMS 17+ & SentryOne Plan Explorer).
