Blogs

Where are key columns stored in a nonclustered index in SQL Server?

Where are key columns stored in a nonclustered index in SQL Server?

on November 29, 2017 • 6 min read

Category: index-tuning

Last week’s Quizletter featured a quiz on keys vs included columns in SQL Server. I got a great question from a reader:

What do you consider a good reference and/or description of indexes for SQL Server? For example where would you have documentation that explains how the answer to #1 is right?

Continue reading

Slowing Down Your Motor Mouth - Presentation Tips for Fast Talkers

Slowing Down Your Motor Mouth - Presentation Tips for Fast Talkers

on November 20, 2017 • 15 min read

Are you worried that you talk too fast when you give a speech, talk, or presentation?

In this episode, I give you simple, practical tips that I’ve used to successfully improve the way I give presentations. Four years ago, I got frustrated feedback from listeners who had a hard time keeping up with my mouth; now I get congratulations that the pace was great.

Continue reading

Attempting to Force a Narrow Plan on an Update with Query Store

Attempting to Force a Narrow Plan on an Update with Query Store

on November 15, 2017 • 5 min read

Category: query-store

When you force a plan with Query Store, you may not get what you expect. Here’s an example.

Continue reading

Kalen Delaney and Inspiration for Adventure

Kalen Delaney and Inspiration for Adventure

on November 14, 2017 • 3 min read

This post is part of TSQL Tuesday, a monthly blog party. You’re welcome to join in this party: if you’d like email notifications of future topics, here’s how to set them up.

This month’s topic is “Folks Who Have Made a Difference”, by Ewald Cress.

Continue reading

The Case of the Weirdly Long COLUMNSTORE_BUILD_THROTTLE Wait

The Case of the Weirdly Long COLUMNSTORE_BUILD_THROTTLE Wait

on November 9, 2017 • 5 min read

A funny thing happened on the way to my filtered nonclustered columnstore demo recently…

It was taking forever to create my demo index.

Continue reading

Things I Learned from Speaker Idol 2017 at the SQL PASS Summit

Things I Learned from Speaker Idol 2017 at the SQL PASS Summit

on November 9, 2017 • 5 min read

I was lucky enough to serve as a judge for the Speaker Idol competition at the SQL PASS Summit conference this year. One of the great thing about watching presentations and giving feedback on them is that you learn a lot about speaking by watching sessions and crafting your feedback.

Continue reading

I Thought I Was An Introvert. Turns Out I Was Anxious as #@*]  (Dear SQL DBA Episode 53)

I Thought I Was An Introvert. Turns Out I Was Anxious as #@*] (Dear SQL DBA Episode 53)

By Kendra Little on November 8, 2017 • 1 min read

Category: career

In this week’s episode, I’m not answering a reader’s question. Instead, I’m talking about my personal experience with anxiety.

This episode touches on on healthcare, religion, and squishy emotions – and there’s at least one curse word. I don’t talk tech in this episode. (Don’t worry, there’s more of that coming in future weeks.)

Continue reading