The Sort that Spills to Level 15,000 Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations. Paul White ◆ September 27, 2016 7
Memory/Storage Technology Hierarchy and SQL Server Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers. Glenn Berry ◆ September 21, 2016 1
Plan Explorer 3.0 Webinar – Samples and Q & A Aaron Bertrand (@AaronBertrand) follows up a recent webinar on Plan Explorer 3.0 with answers to about two dozen audience questions. Aaron Bertrand ◆ September 15, 2016 0
Pattern Matching : More Fun When I Was a Kid Aaron Bertrand (@AaronBertrand) runs some tests to challenge an assertion that CHARINDEX is always faster at pattern matching than LEFT and LIKE. Aaron Bertrand ◆ September 6, 2016 10