Wayne Sheffield

My blog about SQL Server

In my previous post, I introduced you to the Advent of Code programming challenge, and explained how I’m going through the days, solving both parts of each puzzle. Continuing on, today we have day 4. Since you can only see this if you are up to this level in the challenge, let me explain it to […]

In my previous post, I introduced you to the Advent of Code programming challenge, and explained how I’m going through the days, solving both parts of each puzzle. Continuing on, today we have day 3. Since you can only see this if you are up to this level in the challenge, let me explain it to […]

In my previous post, I introduced you to the Advent of Code programming challenge, and explained how I’m going through the days, solving both parts of each puzzle. Continuing on, today we have day 2. Since you can only see this if you are up to this level in the challenge, let me explain it to […]

This guy by the name of Eric Wastl (t) created this neat neat web site called “Advent of Code“. It’s a… well, let’s let Eric describe it: Advent of Code is a series of small programming puzzles for a variety of skill levels. They are self-contained and are just as appropriate for an expert who […]

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. And if there are a lot of questions, you may not have enough time to […]

The company that I work with, SQL Solutions Group, is conducting a free community event. The week of the PASS Summit, on Tuesday, we will be hosting a day of free training. This is an event for all data professionals who happen to be in the Seattle area the days leading up to Summit but […]

A common question asked during an interview is “What is the difference between a heap and a table with a clustered index?”. The most commonly given answer is that the data is sorted in the key order of the index. Sometimes this will be elaborated upon, and other things will be mentioned, such as: All […]

This is short and sweet… Are you going to the PASS Summit this year (and if not… why not???) Are you looking to start your #SQLLearning as soon as possible? Are you not going to a PASS Summit Precon on Tuesday? Then come join SQL Solutions Group (SSG) on Tuesday at the Hyatt (located at […]

Well, here it is the second Tuesday of the month – which means that it’s time for yet another T-SQL Tuesday… The time when the T-SQL blogosphere goes wild and all of the bloggers write a blog post about a topic near and dear to the heart of the host for the month. This monthly […]

Maybe you’re the type of SQL person that digs into execution plans. If so, you might have noticed that when you hover over an operator, that in the popup is an entry for “Actual Rebinds” and “Actual Rewinds” – and that they are usually 0. In this post, we will explore what a rebind / […]