Schedules aren't executed, it's the jobs that are, the schedule just denotes the time(s) that job runs. If you can't see that the job was executed at that time then,...

One method would be to check if the current row isn't NULL and use LAG to check the prior row was NULL and if this is true then denote it...

Misunderstood. Apologies....

No, it's certainly...

In truth, I need to do my own testing on it as well. I...

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...

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...