Post the DDL for the table, so we can look and not guess.

Yes, the databatypes can definitely be a factor. If the column is using the UNICODE datatypes then...

It looks like you have 2 options.

1. get more space

2. Have the prod dba import the data for you (as mentioned above)

I doubt they would shrink a production...

Can you install another Dev Edition instance in DEV then restore the PROD db, or if you can't then how about restoring the database in dev as a different name?

Also...

MSDN NUMA Blog. There's some nice information here:

http://blogs.msdn.com/psssql/archive/2008/01/24/how-it-works-sql-server-2005-numa-basics.aspx

Are you implying that you must have the ID's in order without skipping a sequence?

2,4,6,;;;

or can you use

2,6,8,...

I...

...well I guess it depends as to whether a server restart is required. If SQL already grabbed the "max" memory it's not going to release it. I don't...

Thanks for posting.

I didn't see where there was a server "restart" for the new memory to take affect. It only seems as though the "configured" value is changing and...

I'm curious. Please post.

Can you post the table definition of the temp table?

ManageStudent.StudentTemp

Additionally what does this SELECT statement return when run before the INSERT?

'Select * from ManageStudent.StudentTemp' before the insert.

I know you...

Option 2 (Filegroups and RAID1+0)

You also will be clustering this instance?

How large is this database? Terabytes?

What are the servers that you're moving to?

1. You're trying to achieve maximum...

You could also get the plan using a Profile trace. "Showplan" events.

A table scan and Index scan are pretty much the same thing in that they retrieve all rows...

Is this a two node cluster? Just to understand, you're running 4 instances, two per node. If that's the case then you probably would have each server instance...

The Books Online have a lot of information on this topic.

We've been running ACTIVE/ACTIVE clustering for years and even have a cluster with SQL2005 and SQL2000. It's totally supported...

Do you have the Performance Dashboard reports installed? There's a missing index portion of the reports that can be useful.

http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

I would also run a trace and trap...

You can get a trigger to fire for each row by adding a cursor in the trigger. Doing this during a bulk load will really be sloooooooow.