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
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
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. Aaron Bertrand ◆ September 15, 2016 0
