Improve SQL Server – vote to support the double pipe (“||”) for string concatenation.

ISO 9075 is the official SQL language standard (synonymous with ANSI SQL). It has supported the double pipe for string concatenation since 1999. Almost every other database supports this operator (the tragically broken MySql reinterpretation being the prominent exception – but who cares?), and thus makes generating more universal SQL cleaner and easier… except that SQL Server doesn’t support it.

You can change that. Vote on Connect: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=259291

Filed under: Getting Data

Anisotropic filtering != anisotrophic filtering

It’s "anisotropic filtering", not "anisotrophic filtering".

Anisotropic = not isotropic = not (an) the same (iso) direction or alignment (tropic).

Anisotrophic = not isotrophic = not (an) having the same (iso) nutritional requirements or processes (trophic).

When we’re talking about filtering a texture image so that it has less pixels on one side vs. another, that is non-isotropic, meaning that the filtering isn’t the same throughout the image. This is useful when the square texture is projected and has more of a trapezoidal shape due to perspective.

Although care and feeding of your textures could be shown to improve quality, as well…

Filed under: .Net Graphics