Browse by Tags

All Tags » Upgrading (RSS)

Fun with upgrading and BCP

I just had trouble with using BCP out via xp_cmdshell. Probably serves me right but that's a different issue. I got a strange error message 'Unable to resolve column level collations' which turned out to be a bit misleading. I wasted some...
Posted by DavidWimbush | with no comments

R2 Report Pagination

I thought it was all too good to be true. We upgraded our reporting server in place from 2005 Std to 2008 R2 and we've hit a major problem. We have a few reports that are about 60 pages. On 2005 the report would render page 1 of 60 pretty quickly...
Posted by DavidWimbush | with no comments

R2 Collation Gotcha

On my dev machine I installed R2 alongside my existing 2005 instance and it did a funny thing with the new instance's collation. Our servers are all on Latin1_General_CI_AS, including my 2005 dev instance. But my R2 instance defaulted to SQL_Latin1_General_CI_AS...
Posted by DavidWimbush | with no comments

Upgrade to 2008 R2

I don't like it, Carruthers. It's just too quiet. Well, I've done the pre-production server, the main live server and the Reporting/BI server with remarkably little trouble. Pre-production and live were rebuilds. I failed live over to our...

Upgrading from 2005 to R2

We're about to take the plunge and upgrade our servers from SQL 2005 to SQL 2008 R2. Real world accounts of people upgrading to R2 are a bit hard to find so I thought it might be useful to blog what happens. (I don't count marketing 'case...