THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

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

 Some of my favorite 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.

-Kevin

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

Published Tuesday, July 28, 2015 8:05 AM by KKline

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS, www.sqlpass.org.

This Blog

Syndication

Archives

Privacy Statement