While we will briefly discuss advice you’ve probably heard before, like avoid SELECT * and don’t use NOLOCK, you will also learn some subtleties in SQL Server that might surprise you, how some shorthand can bite you in the long run, and a very easy way to improve cursor performance.
1 post, 2 Comments
Aaron is a Product Evangelist for SentryOne, who produce monitoring and optimization products for database, cloud, and virtualization throughout the Microsoft data platform. They also provide Plan Explorer, a free tool that greatly enhances execution plan analysis. Aaron has been wrangling T-SQL since SQL Server 6.5, has been a Microsoft MVP since 1997, and speaks frequently at conferences, user group meetings, and SQL Saturday events around the world.