So where do these linked integers come from? Why, for example, is 1 linked to 1, 2, and 3, but the numbers 8 to 14 only linked to 8?

SQLBits, but call for speakers closed months ago. That's the big one in the UK. Next is Relay. The call for speakers probably opens late spring. After that, Data...

Shifting gears a bit, I'm hoping this year that work will be happy to pay (or at least contribute) to me getting out and going to some SQL based events...

I can barely read those images, so I'm not sure what it's trying to show anyone. Can you elaborate?

What I find extremely frustrating is when someone writes SQL code that joins multiple tables without prefixing the column names with their originating table or alias using dot notation....

What I find extremely frustrating is when someone writes SQL code that joins multiple tables without prefixing the column names with their originating table or alias using dot notation....

I will admit, and though I know it shouldn't, it does amuse me when I see code that has something like this:

SELECT *
FROM dbo.MyTable MT ;WITH (NOLOCK)
...

A good friend, Aaron Bertrand, does it for all his demo scripts. However, he has a good reason (even if I don't agree). Because people are more than a...

.Please no >_< .Leading commas I accept as a preference, but leading semicolons are another matter entirely, lol .Those are like starting...

No, there is no syntax to ALTER a table and ADD column only if it doesn't exist, and (presumably) ALTER the column if it does like, for example, CREATE OR...

Wouldn't someone who "outranks" you want to teach you the why along with the...

On Windows, ShareX. I...

Just to prove Grant's statement a little more, here's a quick demo.

So you can see that the first SELECT, which wants rows on or after the current...

Just to prove Grant's statement a little more, here's a quick demo.

So you can see that the first SELECT, which wants rows on or after the current...

This implies that the ownership chain is being broken somewhere; the point of ownership chaining is that you don't need to give explicit access to the objects. Who are the...