SQL Shack
JUNE 21, 2019
Summary There are few topics so widely misunderstood and that generates such frequent bad advice as that of the decision of how to index a table. Specifically, the decision to use a heap over a clustered index is one where misinformation spreads quite frequently. This article is a dive into SQL Server internals, performance testing, […].
SQL Performance
JUNE 21, 2019
I've been teaching and writing about common SQL Server mistakes for many years. I wrote a blog about it years ago too, however as time has marched on, guidance has changed a bit. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. For many years I've found users making the same mistakes.
Expert insights. Personalized for you.
48 
Let's personalize your content