You sir, are a legend! Sorry for bumping a 6 year old post, but I have started getting this issue after installing some .Net and Visual Studio libraries which seem...

Technically this isn't a bug per se. It primarily arises because of the various encodings of text files, this is not something that will ever go away and is well...

Are yes, I should have actually paid attention to what...

I'm assuming what you are saying is that you have been copying from SSMS "Grid Output" and pasting in Excel. I know that the "Grid Output" option strips out new...

Yes, the name that is in...

I would recommend against using row_number() when you are trying to use a SELECT DISTINCT query, as the row_number is evaluated before the DISTINCT meaning that whatever the DISTINCT is...

This is a really old post, but is still the highest hit when it comes to searching google for this issue so I'll try to explain.

A code page in SSIS...

The bazaar thing is that I've tried looking at the sub-queries, I've looked at every field referenced in every table, including looking at each and every implicit conversion. I would...

Thanks Sean,

I completely understand and if no-one can help I don't blame them, this question is more of a curiosity for me as I can work around the issue and...

I've had to deal with this issue a lot, due to incomplete relationships in databases due to poor rules governing primary/foreign key relationships not being enforced. Another alternative is to...

As I don't have any of my production systems on 2012 yet, I couldn't actually test out the functionality, but it useful to know about the additional features for when...

I initially thought that this was an issue of the approximate storage of the FLOAT data type such that the 3.65 was actually being stored as 3.649999999... for example but...

I'm supprised no-one has mentioned another implication of collation ordering and special characters that can be quite important; the impact on LIKE clauses that use set's of characters e.g.

DECLARE...