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: Sequences, CPUs, and Trimming T-Logs

Have you read any of the great articles on SQLPerformance.com? The deep-dive technical info comes from the SQL Server industry’s top experts. Here are a few great articles from the early days of the website, January 2013:

 

Generate a set or sequence without loops

Aaron Bertrand (b|t) provides detailed performance information about a variety of methods used to generate sets and sequences in this first in a three part series.

Selecting a Processor for SQL Server 2012

Glenn Berry (b|t) of SQLskills.com sheds light on the best CPU to select for your new SQL Server 2012 installation, an especially important insight considering Microsoft’s move to core-based licensing.  The wrong choice could cost you a fortune. A lively discussion also made this article even more enjoyable.

Trimming More Transaction Log Fat

In a follow-up to his December 2012 article, Paul Randal (b|t) of SQLskills.com dives into subtle performance problems that can cause bloat in the transaction log and slow its performance.


Let me know what you think!

-Kev

-Follow me on Twitter!
-Google Author

Published Monday, February 23, 2015 10:38 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