Blogs

Using YouTube Captions & Transcript to Find Content in a Long Video

on February 23, 2018 • 3 min read

This week, I was pretty pumped to see that PASS published Erin Stellato (twitter) and Dejan Krakovic’s (linked in) excellent session on Query Store to the public.

I attended this session live at the conference, and I remembered that there was one specific part on memory limits in Query Store that I wanted to watch again. I’d jotted down a note about it, but things were flying by and my note was gibberish.

When Should I Use Explicit Transactions for Single Statements?

on February 22, 2018 • 6 min read

Category: tsql , sql-server

I got a great question about transactions by email recently about transactions.

New SQLChallenge: Defuse the Deadlock

By Kendra Little on February 20, 2018 • 2 min read

Category: monitoring-troubleshooting , sql-server

When I first created SQLWorkbooks, I distilled what it was all about down into one sentence: “Learn SQL Server by Solving Problems.”

This month, I introduce my first SQLChallenge, which distills that down into practice. The SQLChallenge features 23 minutes of video with scripts that you can use to reproduce and solve the problem yourself.

When Were Statistics Last Updated for a Heap?

on February 16, 2018 • 4 min read

Category: statistics , sql-server

I got a question last week from a very smart fellow:

How can I tell when statistics were last updated for a heap?

Before I could email him back, I soon got another email in which he answered his own question.

How I Accidentally Found a Passion for Plants (#TSQL2sDay 99)

on February 13, 2018 • 5 min read

Category: tsql-programming

For TSQL Tuesday #99, @AaronBertrand gave us an invitation to write about something we’re passionate about outside of SQL Server.

Formatting a VTT Caption File into a Transcript with Sublime Text and Multiple Regular Expressions

By Kendra Little on February 8, 2018 • 4 min read

Category: career

Tags: sublime-text , regular-expressions

Do you ever need to use a text editor to apply regular expressions to files? If so, this post is for you! If not, you may wanna skip it and just return to it if you ever need it.

Does a Clustered Index Give a Default Ordering?

By Kendra Little on February 2, 2018 • 6 min read

Category: query-performance , sql-server

Tags: clustered-indexes , order-by

I recently got a great question: if I order by a column where all rows in that column have the same value, will SQL Server then order the results by the clustered index key?