Interesting article indeed.

As other commentators have noted, statistical results can be manipulated in many ways to fit the desired outcome.

I'd like to add that the 'input' side of the equation...

You need to maintain a list of what you know the value should be (i.e. ABC Movers) along with a table with all variations that are identified to be associated...

Short Answer: No.

Context; I have, in the past, moved several times. When I landed in Denver, I decided this was home.

Good easy way to end the week (wishing it was Friday), but the query would error in all cases:

the table is created as [RPSGame], but the FROM clause references ...

Yup. Got burned by that back in '02.

Could? yes, of course.

Should? dunno. depends on the goal.

As for using VCS to compare the databases, I'd say it depends... We cannot because our Production database is very separate...

Trick question indeed. Another reminder to not not answer a question while there are assumptions on the table: by stating that transaction log backups run from midnight on, there is...

I have to agree with @patricklambin: it's not really a 'nested schema', rather it's really an effed up name...

Personally, l would never add FQN delimiters to an object...

paul 25096 (11/4/2015)

---

I think the reason "Options 1, 2 and 3" has more votes than "Option 2" is because of course you should also avoid statements that cause a syntax...

I don't use bit very often, but when I do, it's NOT NULL and has a default.

Mostly, for other, general status columns, I'll use whatever's appropriate - int, tinyint, varchar(x)...

Wow. This discussion is almost as lively as the whole tabs versus spaces debate.

I've used 'Active bit not null default 1' for so many years I never thought to question...

Thanks for the example/exercise. That's really a great way to leverage existing tools (I hadn't seen Google Charts before and will keep that nugget in my toolbox too).

I've been using...

Thanks.

Nice exercise/example. I see one could easily work in an excel writer an/or an emauler.

For years I've been using Microsoft's uptime tool

(uptime.exe from https://www.microsoft.com/en-us/download/details.aspx?id=14732)

running from a batch file as...

Thanks Steve.

Now, on top of the impending zombie apocalypse, I have to worry about the friendly random guy at ISNULL(@wherever, 'Starbucks').

Well, you're right, as usual. Laptops are stolen every...

Kindle. All 5 in one collection: $11.99. Bam! Delivered.