Impact of Fragmentation on Execution Plans Jonathan Kehayias explains why, among other reasons, the impact on execution plans can make index fragmentation something you should care about. Jonathan Kehayias ◆ December 18, 2017 16
New Azure SQL Database Standard Tier Sizes Tim Radney of SQLskills talks about the various Standard tiers available in Azure SQL Database – what they get you, and how much they cost. Tim Radney ◆ December 4, 2017 1
Wait Statistics and Query Store Erin Stellato shows how to use Query Store to troubleshoot wait statistics in SQL Server 2017 and Azure SQL Database. Erin Stellato ◆ November 27, 2017 3
Azure Virtual Machine Developments for SQL Server Usage Glenn Berry explains the importance of hardware choices for SQL Server running on your own hardware vs. Azure Virtual Machines. Glenn Berry ◆ November 6, 2017 0
UPDATEs to Statistics Erin Stellato lists out all of the enhancements to statistics in SQL Server over the years, from SQL Server 7.0 all the way through to SQL Server 2017. Erin Stellato ◆ October 23, 2017 9
Because you need to know PowerShell Rob Farley (@rob_farley) gives a rather thorough crash course on PowerShell for this month's installment of T-SQL Tuesday. Rob Farley ◆ September 12, 2017 8
Trigram Wildcard String Search in SQL Server Paul White discusses the pros and cons of maintaining three-character substrings (trigrams) to speed up wildcard searches. Paul White ◆ September 8, 2017 18
New AMD Processor Families Compare Well to New Intel Processors Glenn Berry (@GlennAlanBerry) talks about some upcoming AMD processors, which he says may change the server processor landscape. Glenn Berry ◆ August 28, 2017 1
Multi-Statement TVFs in Dynamics CRM Andy Mallon (@AMtwo) walks through identifying and fixing a serious performance issue with a multi-statement table-valued function in Dynamics CRM. Guest Posts ◆ August 22, 2017 8
Cardinality Estimation: Combining Density Statistics Paul White (@SQL_Kiwi) whips out the debugger while showing how SQL Server derives estimates when combining multiple, single-column statistics. Paul White ◆ August 2, 2017 10
Intel Xeon Scalable Processors and SQL Server 2017 Glenn Berry of SQLskills walks through the next iteration of Intel Xeon processors, and how they suit SQL Server 2017. Glenn Berry ◆ July 17, 2017 2