SQL Performance Archives - Page 14 of 31

What the heck is a DTU?

Andy Mallon (@AMtwo) explains DTUs (Database Transaction Units) and the differences you might see between the documentation and practical usage.

Guest Posts ◆ March 30, 2017

16

Performance Myths : Clustered vs. Non-Clustered Indexes

Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.

Aaron Bertrand ◆ March 17, 2017

16

Harmful, Pervasive SQL Server Performance Myths

Aaron Bertrand (@AaronBertrand) begins a new series around disproving prevalent myths regarding SQL Server performance.

Aaron Bertrand ◆ March 9, 2017

42

Using DBCC CLONEDATABASE and Query Store for Testing

Erin Stellato demonstrates how to use the new DBCC CLONEDATABASE feature, in combination with Query Store, to test index and query changes.

Erin Stellato ◆ February 22, 2017

6

Follow-up #1 on leading wildcard seeks

Aaron Bertrand (@AaronBertrand) shows how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.

Aaron Bertrand ◆ February 8, 2017

12

Compression and its Effects on Performance

Erin Stellato (@erinstellato) takes a look at the new COMPRESS and DECOMPRESS functions, comparing their impact on space and performance to traditional data compression.

Erin Stellato ◆ January 20, 2017

15

Estimated Number of Rows to be Read

Rob Farley (@rob_farley) uses this month's T-SQL Tuesday to show off the results of one of his Connect items : Estimated Number of Rows to be Read.

Rob Farley ◆ January 10, 2017

2

SQL Server v.Next : STRING_AGG Performance, Part 2

Aaron Bertrand (@AaronBertrand) starts digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.

Aaron Bertrand ◆ January 6, 2017

1

SQL Server v.Next : STRING_AGG() performance

Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.

Aaron Bertrand ◆ December 28, 2016

14

SQL Server 2016 Enterprise Edition Performance Advantages

Glenn Berry uses a few specific examples to demonstrate the performance benefits you can get from SQL Server 2016 SP1 Enterprise Edition.

Glenn Berry ◆ December 22, 2016

18

Capacity Planning Using Performance Data

Erin Stellato (@erinstellato) discusses the types of performance data needed to help with capacity planning.

Erin Stellato ◆ November 30, 2016

4