Why would anyone believe log-file data from the industry that routinely faked emissions tests to get round anti-pollution laws ?

Lots of interesting points in the article. Case sensitive variable names are one of my pet hates.  I've never seen a persuasive case that there is any advantage to being...

Interesting analysis, but with the data all being self-reported, I'm not sure how much I'd rely on it.  I always liked this quotation when looking at stats based on questionnaires:

• The...

sql-troubles (7/29/2016)

---

I think the postcodes aren’t the best example in what concern the data quality assessment rules. Even if one succeeds in his attempts of reengineering the postcodes rules, by...

Didn't notice the author's name till afterwards - looks like the article might be motivated by personal experience on sites that don't cater for people with only one name !

Yes you're right - which makes it a better and subtler question than I had thought.

Without necessarily knowing anything about the conversions involved, you can see that the data being added comes from a single INSERT statement, where the input data is the union of...

Curious as to why the Break doesn't exit from the IF , as the referenced BOL page suggests that it should ? ( It clearly does work as stated, just...

I'd include the ability to handle the possible effects of NULL values, and knowledge of how and why to use Stored Procedures.

I'm another person who hasn't ever needed to use...

Neither answer is really correct. "Will it run succesfully" ? Doesn't this depend on what you are trying to do ? What could you possibly be trying to...

What we call "data" is different nowadays. I never used to consider my large collection of vinyl LPs and cassettes, or my printed photographs, as somehow containing multiple GB...

I also wonder whether the precision being returned by the SYSDATETIME function might explain the behaviour that Tom highlighted, where the test script runs much faster on his old computer...

I was confused by people saying how rare it was to find matching values. When I tested the original code, I found that it was not infrequent at all to...