How did I miss that....

Be careful, that's not necessarily going to work under concurrent calls if it's a manual 'identity' column (two queries could get the same max value)

+ CAST(CASE WHEN PER.[GENDER] = 'M' THEN '1'

WHEN PER.[GENDER] = 'F' THEN '2'

...

That's Express edition. Express doesn't come with SQL Agent. Only the paid versions of SQL come with agent.

I'm running 2014, 2012 and 2008 R2 on a Win 7 box. They all work fine.

Could be he specified system DB files in the same place as the earlier version...

Please note: 4 year old (solved) thread.

Then no idea. Would have to repo and diagnose live to be able to say anything useful.

http://www.microsoft.com/learning/en-gb/retired-certification-exams.aspx

Being withdrawn on 31 July 2014

70-433: TS: Microsoft SQL Server 2008, Database Development

70-450: PRO: Microsoft SQL Server 2008, Designing, Optimizing and Maintaining a Database Administrative Solution

70-451: PRO: Microsoft SQL Server...

Hard to say for sure without being able to investigate...

Online index rebuilds aren't online. They're mostly online. They need to take schema locks at two points, right at the beginning...

Tom and Jeff both answered that.

I need a new laptop myself, but not even considering a surface.

I have an iPad which serves the tablet role just fine. My requirements for a laptop include being able...

Why do you want to avoid the left joins?

Why are you using hints which allow incorrect results?

Please post unrelated questions in a new thread

And forgive me if this sounds insulting, but do you do any research at all before asking here? If the answer to that...

Yup, that sounds about right.

Not actually true.

A good rule of thumb is picking table variables for small sets, and...