Definitely deprecated, but I know there are systems using these and you might run into an older, or upgraded, system. Hence my decision to build a few questions.

The formatting from SSMS is problematic. It has various forms, and this editor doesn't handle it great. The best thing I've found is to paste, then highlight the code here...

You have to be consistent. You can't mix nvarchar and varchar values in the column and have them work. I'm going to have to convert all data to nvarchar or...

Is it the same if you use an item in a table? I'm wondering if there are issues calling out to AD here with performance. I'd like to think this...

Can I ask how you're coding the function? Are you hard coding the AD names in there? I'd think you'd want these as data somehow linked to the user and...

This seems to work:
UPDATE Posts
SET content = 0xFFFE + content

Then:
SELECT
Id,
CONVERT(nVARCHAR(MAX), [Title]) AS [Title],
...

This might help as well: http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/99287/

Sounds like someone should write me an article on this.

More data means more irrelevant data, but it also means we need more complex analysis and not the simple one error is an issue.

A guy from CERN talked...