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...

Shouldn't be. Might be only PASS members though.

Here's what I'd say.

For OS/binaries, I'd probably put 100GB there, maybe more for pagefile depending on RAM. Guess high, since the system drive is a pain to alter later.
For SQL...

The resources you need for cubes depend on workload variables. Size of data, number of users, response time needed, etc. Without more details on what load you expect, I'm not...

Are there multiple files in the source? I'm not much of an SSIS guy, but the pattern I've seen is use a loop to process all files in a folder,...

Thanks for the suggestion, though I'm not sure this is a change we'd make anytime soon.

Thanks. I've seen companies do this manually in the past, randomly sampling call content (or using to check when there are issues), but rarely have they been mined for understanding...