ICYMI - Recommended Intel Processors For SQL '14, Should Indexes Be In The Key Or Included, Comparing Windows Azure VM Performance

Kevin Kline

Published On: July 28, 2015

Categories: Performance, SQL Server 0

A digest of great performance tuning 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: https://sentryone.com/community.


Connect with me online! Facebook | Twitter | LinkedIn | Blog | SlideShare | Google Author

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at SentryOne. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.