Aaron Bertrand, Author at SQLPerformance.com

Bad cardinality estimates from SSMS plans – redux

Aaron Bertrand (@AaronBertrand) shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can.

Aaron Bertrand ◆ March 4, 2016

4

Performance Surprises and Assumptions : SET NOCOUNT ON

Aaron Bertrand (@AaronBertrand) revisits the impact that eliminating DONE_IN_PROC messages using SET NOCOUNT ON may or may not have on query performance.

Aaron Bertrand ◆ February 26, 2016

35

Minimizing impact of widening an IDENTITY column – part 3

Aaron Bertrand (@AaronBertrand) continues his series on upsizing an IDENTITY column from INT to BIGINT – this time focusing on workarounds.

Aaron Bertrand ◆ February 17, 2016

6

Minimizing impact of widening an IDENTITY column – part 2

Aaron Bertrand (@AaronBertrand) continues his series on upsizing an IDENTITY column from int to bigint, detailing several challenging obstacles.

Aaron Bertrand ◆ February 11, 2016

2

Minimizing impact of widening an IDENTITY column – part 1

As part of a new series, Aaron Bertrand takes a look at what happens to the structure of a page when an INT column needs to be upsized to a BIGINT.

Aaron Bertrand ◆ January 29, 2016

3

Comparing string splitting / concatenation methods

Aaron Bertrand (@AaronBertrand) compares the performance of different UDFs and raw queries used for splitting and reassembling a delimited string.

Aaron Bertrand ◆ January 22, 2016

14

Can ColumnStore Help Pagination Workloads?

Aaron Bertrand (@AaronBertrand) revisits an older post about SQL Server pagination to see if any implementation of ColumnStore indexes can improve performance.

Aaron Bertrand ◆ January 15, 2016

1

SQL Server 2016 : Availability Group Enhancements

Aaron Bertrand (@AaronBertrand) reveals details about the changes to Availability Groups that will ship in the next major version: SQL Server 2016.

Aaron Bertrand ◆ December 17, 2015

45

More showplan improvements? Yes, please!

Aaron Bertrand (@AaronBertrand) highlights a handful of Connect items aimed at improving SQL Server showplan diagnostics and query tuning in general.

Aaron Bertrand ◆ December 8, 2015

0

Partitioning on a Budget

Aaron Bertrand walks through a solution that allows you to achieve some of the benefits of partitioning without the Enterprise Edition price tag.

Aaron Bertrand ◆ December 4, 2015

6

SQL Server 2016 : In-Memory OLTP Enhancements

Aaron Bertrand (@AaronBertrand) lists out the changes to In-Memory OLTP ("Hekaton") that will make the feature even more appealing in SQL Server 2016.

Aaron Bertrand ◆ November 30, 2015

32