SQLPerformance.com

Memory Limits in SQL Server 2016 SP1

Aaron Bertrand (@AaronBertrand) explains a few details about the memory limits in SQL Server 2016 Service Pack 1 that make this upgrade even more compelling.

Aaron Bertrand ◆ December 12, 2016

12

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

A Big Deal : SQL Server 2016 Service Pack 1

Microsoft has made a bold change with SQL Server 2016 Service Pack 1 : Many Enterprise features are now available in lower editions. Read on for details.

Aaron Bertrand ◆ November 16, 2016

9

Can comments hamper stored procedure performance?

After a recent conversation on Twitter, Aaron Bertrand (@AaronBertrand) shows where excessive comments in your stored procedures might have an impact on performance.

Aaron Bertrand ◆ November 9, 2016

15

Migrating Databases to Azure SQL Database

Tim Radney of SQLskills discusses strategy and some available tools for helping migrate your databases to Azure SQL Database.

Tim Radney ◆ October 25, 2016

0

Implementing a custom sort

Rob Farley (@rob_farley) discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries.

Rob Farley ◆ October 17, 2016

9

SQL Sentry is now SentryOne

As part of our effort to consolidate our offering, and to reflect that we aren't just about SQL Server, we have changed our company name to SentryOne.

Aaron Bertrand ◆ October 5, 2016

0

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.