Here things are still getting worse (mining problems and government blunderings not helping), so I'm seeing less demand for competant (expensive) people and more 'oh, you've done a university course...

I don't have links to any offhand. I use google for that.

Thursday at Summit is going to be sooo funny. Just saying...

Ok, so you can nest roles. So you'd add db_datareader and db_datawriter to your custom role.

Fall upon your sword? Fiddle while Rome burns?

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

You can't just run checktable on all tables, you need check alloc and check catalog too. Could be that it's one of those phases that's failing checkDB. Can't tell without...

Please read what I wrote

CheckDB and CheckCatalog BEFORE the upgrade and if there are any errors do not proceed!!!

Then, after the upgrade CheckDB with data purity, update usage, update...

Grant those roles to the user, you can't afaik nest roles.

If there is corruption, CheckDB will always find it. If you've manually edited an unallocated page, or the middle of a page when you don't have page checksums enabled, then...

BEFORE you update, run DBCC CheckDB and DBCC CheckCatalog. If there are any errors, do not go further.

After, checkDB with data purity, update all statistics, update usage. Order doesn't really...

More insecure dynamic SQL....

Please, do you company a favour and stop writing dynamic SQL until you've read up and understand SQL injection.

You'll need to download a SQL 2008 or earlier adventureworks. The 2012 one is a 2012 database and hence can only be restored to SQL 2012 or newer.

Depends on the workload. There is absolutely no way to answer that question in a useful way.

That's what I suspected. The plans showed different estimated row counts, so that was a second indication...