Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

#SQLVacation Postcard from Indianapolis, IN

For some people, Indianapolis means one thing, and one thing only – the Indianapolis Motor Speedway (a.k.a “The Brickyard”)  and the Indianapolis 500. In my case, it means several times speaking at IndyPASS, the local SQL Server User Group, over the last 10 years. I first spoke at… Read more

0 comments, 206 reads

Posted in Kevin E. Kline on 16 June 2015

#SQLVacation Postcard from Louisville, KY


Along the banks of the mighty Ohio River, in sight of the shores of Indiana, lies beautiful Louisville, KY. Louisville is a place with a strong connection for me. (No, not because I drink bourbon, although that’s a pretty good reason to like the place, come to… Read more

0 comments, 185 reads

Posted in Kevin E. Kline on 15 June 2015

ICYMI: Parameter Sniffing, Friends with Partition Benefits, and SELECT INTO Parallelism – SQL Server Performance

Great topics for further reading about tuning SQL Server performance:

Exploring SQL Server 2014 SELECT INTO Parallelism

Joe Sack (b | t) provides us with a peak into the performance improvements and new behaviors of SQL Server 2014 in the way it can now parallelize large SELECT INTO… Read more

2 comments, 194 reads

Posted in Kevin E. Kline on 6 April 2015

Advice to New Bloggers


If you’ve been reading my blog for a while, you know that I travel and speak quite a lot. A frequent question I’m asked at these events is “I want to start blogging, but don’t know where to start. What do you recommend?” This is a such a common… Read more

5 comments, 322 reads

Posted in Kevin E. Kline on 31 March 2015

ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior – SQL Server Performance

Here are some oldies, but goodies that I recommend you read:

Two Partitioning Peculiarities and Aggregates and Partitioning

Most of us know that partitions are one of the best ways to scale very large databases or very large IO workloads.  However, there are risks, two of which are explored in… Read more

0 comments, 269 reads

Posted in Kevin E. Kline on 30 March 2015

ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats – SQL Server Performance

Do you do a bit of query tuning? Then check out this treasure trove of performance tuning advice!

Optimization Phases and Missed Opportunities and

Working Around Missed Optimizations

Paul White (b | t) writes two fascinating blog posts that go hand-in-hand concerning query optimization.  He goes into some… Read more

0 comments, 231 reads

Posted in Kevin E. Kline on 23 March 2015

ICYMI: Troubleshooting CPU, Logging Myths, Missing Indexes, and Query Tuning Examples

Great Articles at

There are so many good articles from this ICYMI article that it’s hard to know which are best to highlight in the limited space.

So, I’ll be arbitrary and simply choose a few of my favorite entries as well look back:

Troubleshooting SQL Server CPU… Read more

2 comments, 268 reads

Posted in Kevin E. Kline on 16 March 2015

ICYMI: Troubleshooting Availability Groups and the Schema Switcharoo – SQL Server Performance

Aaron Bertrand (b | t) is on a roll this month’s SQL Server performance highlights with more great articles from


Troubleshooting AlwaysOn – Sometimes it takes many sets of eyes

Aaron Bertrand (b | t) hit some obstacles recently when configuring an Availability… Read more

2 comments, 174 reads

Posted in Kevin E. Kline on 9 March 2015

ICYMI: the Halloween Problem and DBCC CheckConstraints – SQL Server Performance

Don’t miss these great articles on from the industry’s top experts:


Erin Stellato (b | t) of SQLskills takes a deep look into the SQL Server performance impact, especially I/O, of running DBCC CHECKCONSTRAINTS, including explaining why some check methods… Read more

2 comments, 202 reads

Posted in Kevin E. Kline on 2 March 2015

ICYMI: Ten Query Techniques Every SQL Programmer Should Know (Video)

Update 09-Mar-2015: The original PASS links I provided were behind a firewall. Thanks reader MMcDonald, we have a working link on YouTube.

One of the benefits of joining PASS is that you get access to their expansive library of conference videos. (Membership is free. So join now. What’dya want, a… Read more

6 comments, 7,556 reads

Posted in Kevin E. Kline on 26 February 2015

The SQL Sentry forum for SQL Statement Tuning

The SQL Sentry forum for SQL Statement Tuning

Have you ever looked at our community site specifically dedicated to helping users tune their SQL queries,

You can easily upload an execution plan directly from our free Plan Explorer tool or from good ol’ SQL Server Management Studio to… Read more

1 comments, 359 reads

Posted in Kevin E. Kline on 25 February 2015

Troubleshooting full-day workshop in Richmond (March) and Configuration full-day workshop in Huntington Beach (April)

Want to learn more about SQL Server? Now’s a good time to get a full day of inexpensive high-quality training on both the east and west coast, in March and April, respectively.

I hope you’ll join me for a full-day troubleshooting and performance tuning workshop on the Friday preceding the… Read more

2 comments, 206 reads

Posted in Kevin E. Kline on 24 February 2015

ICYMI: Sequences, CPUs, and Trimming T-Logs – SQL Server Performance Topics

Have you read any of the great articles on The deep-dive technical info about SQL Server performance issues authored by 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… Read more

2 comments, 240 reads

Posted in Kevin E. Kline on 23 February 2015

DBTA – 6 Reasons to Think About Upgrading to SQL Server 2014


If you’re an IT manager, the first thing I’d like to tell you is how invested Microsoft is in SQL Server. While earlier incarnations of executive leadership focused in other areas (anyone remember “Developers! Developers! Developers!”?), Microsoft’s new leadership is very bullish on SQL Server. And, why not? After… Read more

1 comments, 276 reads

Posted in Kevin E. Kline on 26 January 2015

SQL Injection – Why the Heck Does this Keep Happening?!


I’m decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I’ll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing… Read more

2 comments, 207 reads

Posted in Kevin E. Kline on 19 January 2015

Listen to Lead

I’ve got a question for you. Where did you learn how to listen?

Of all the coaching and consulting clients I have asked that question to, not one has had formal training to become a better listener.

Some have pointed to the works of Stephen Covey and others like him… Read more

2 comments, 186 reads

Posted in Kevin E. Kline on 16 January 2015

DBTA – PowerBI: The Self-Service BI App That Can Change Your Life

Here’s a real-world story: Data collection and analysis is, ironically, for a data management profession, one of the toughest parts of my job. I regularly pull data from our various databases and packaged application reporting systems for CRM, licensing, and user information.

If you’ve ever worked with a packaged product,… Read more

1 comments, 325 reads

Posted in Kevin E. Kline on 12 January 2015

Preventing tl;dr Emails


A new abbreviation is beginning to take hold. I first heard of it on Seth Godin’s blog. The abbreviation? tl; dr.

Too long; didn’t read.

I like the new abbreviation. It gives voice to something that has been going on for many years. The elephant in the room now… Read more

3 comments, 185 reads

Posted in Kevin E. Kline on 9 January 2015

IT Pro Events & Free Stuff for the Central USA – Jan 2015

Central USA IT Pro Community News – Jan 2015

There are lots of free, in-person and virtual events happening in the central USA over the next few weeks. Don’t miss out on training, ebooks, and other goodies!

Come to the Nashville SQL Saturday on Jan 17!

Upcoming Events

  • Jan 10

Read more

2 comments, 242 reads

Posted in Kevin E. Kline on 8 January 2015

DBTA – Tools to Evaluate Viability of Database Platforms

As the manager for enterprise architecture in a very large IT organization, the C-suite executives frequently posed the question, “What database platform is best for this application today and for the future?” Implicit in that question was the idea that some platforms, for the application and for the database, might… Read more

2 comments, 185 reads

Posted in Kevin E. Kline on 5 January 2015

Newer posts

Older posts