Check article

http://msdn2.microsoft.com/en-us/library/ms190737.aspx

For -h it says:

Reserves virtual address space for Hot Add memory metadata when AWE is enabled with 32-bit SQL Server 2005. Required for Hot-Add memory with 32-bit...

Chris, one way to do this would be to have another fact table - headcount target and join it with date and division dimensions which you already have.

If I...

I also choose FOR ATTACH because hard drive crash will not result in "clean shutdown" of the database.

Bitbucket, the excel file needs to be on the same computer as the sql server. Check if thats the problem.

Also the CTE are new to Sql Server 2005, the...

Hi Solomon,

I had already changed the EventInfo field to 4000, sorry I didn't mention that in my reply.

The workaround you gave is working great, thanks a lot!!

I have implemented Michael's article successfully. I have a sql trace running and capturing data into table IndexCapture.

But when I try to implement the trigger provided by Solomon on table...

Majbou, we did not make any changes to affinity mask. But thanks for the article link, it helped clear a lot of things.

Tommy, we do not have the latest build...

It has happened on a SP2 box. I have raised another bug with MS mentioning that it is also happening on SP2.

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=308327

Meanwhile, if somebody could provide a workaround,...