I think it's important that languages are allowed to evolve safely, otherwise the mistakes of our ancestors will forever burden us.  Look no further than \r\n or should I say \n,...

Notepad++ and WinMerge.

And I see that Notepad++ was mentioned 8 years ago, so that's gotta give it good toaster creds.

Very clearly written.  Although I share some of the concerns of other commentators about the performance and design of your chosen solution, I thought that overall your description of pros...

L' Eomot Inversé (11/3/2013)

---

Pretending that these aggregates are order-independent ensures that SUM and AVG and STDEV are indeterminate for for all numerics except tinyint, both for exact numerics other than...

I do appreciate the potential performance benefits of filtering the target early. However if clarity is of a higher priority, another approach is to give up using just one...

I saw that article (you'll probably notice a rather...

hunchback (10/25/2013)

---

Your thinking is correct but it get complicated depending on which sub-branch was specified as part of the statement. There is a comprehensive list in this article / topic...

Yes, I agree that for most SELECT statements the ON clause is seen as a filtering condition, particularly for inner joins when the ON condition is equivalent to the WHERE...

Thanks for the script, but I don't think your description is quite right:

Notice that in the first script we still update the tuple (1, 'A') even though there is no...

Comment deleted, and reposted as a new topic: Merge documentation misleading?

Sometimes a rewrite...

Hi

A curiosity : In my case this strange behaviour helps to find a potential data issue but speaking in general term shouldn't it be considered an error of...

A possible reason for this error is that the division expressions are being evaluated for some rows before those rows are excluded by the WHERE clause. The same problem...

Excellent guide. Thank you.

Normally I find such detailed step-by-step instructions boring, but I think in this case it is ideal. Not knowing anything about Visual Studio (like many...

Glad it helped