SQLPerformance.com

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

Find Database Connection Leaks in Your Application

Michael Swart (@MJSwart) shows how to investigate and fix database connection leaks, an application issue that can lead to connection timeouts.

Guest Posts ◆ July 7, 2017

5

Testing DML Statements for In-Memory OLTP

Erin Stellato (@erinstellato) takes a thorough look at the way DML statements might benefit from In-Memory OLTP, especially with natively compiled stored procedures.

Erin Stellato ◆ June 30, 2017

9

Performance Myths : Oversizing string columns

Aaron Bertrand (@AaronBertrand) shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns.

Aaron Bertrand ◆ June 14, 2017

21

Azure Automation Methods

Tim Radney of SQLskills walks through multiple automation methods you can use to manage and maintain your Azure SQL Databases.

Tim Radney ◆ June 2, 2017

3