A digest of great articles originally appearing at SQLPerformance.com.
|Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates
In these two related blog posts, Aaron Bertrand ( b | t ) of SQL Sentry takes on the safest and most efficient ways to perform grouped concatenation in SQL Server. Then he follows up with a closer look at some additional requirements for typical grouped concatenation queries in SQL Server.Recommended Intel Processors for SQL Server 2014 Workloads
Glenn Berry ( b | t ) of SQLskills continues his series on hardware selection, outlining his recommended processors from Intel for your SQL Server 2014 workloads. Especially interesting to me were the details showing which processors excelled at serial performance while showing other processors that excelled at parallel performance.Should new index columns be in the key, or included?
Erin Stellato ( b | t ) of SQLskills compares the performance impact of adding additional columns to an index, either as an added column in a composite key or as an added column without statistics in an INCLUDE list – with interesting results.
|Comparing Windows Azure VM Performance, Part 1 and Part 2
Thinking about the cloud? Glenn Berry comes back for more, this time getting into the nitty-gritty details of cost and performance on the various options in Microsoft Azure virtual machines. In part 2, Glenn shows how Azure VMs are now starting to dramatically ramp up raw performance.
Read more SQL Sentry happenings in our monthly eNews at: http://www.sqlsentry.com/company/more-news