And you need to be sure you have the same space available. Regardless of if you have 1MB of data in there, you'd still need to the 650GB of data...

What do you mean server account? A login?

You could do this, but the XP would need to connect with appropriate rights.

I'd go prod->staging (Serverb) -> archive.

I do this so that if there are issues in data quality or a need to cleanse, you can handle things in there. SSIS can...

This isn't an exact science and your data sizes will change constantly. You don't want to be updating space every day or every week.

Set enough space in the data...

You can select a table and script out everything for that table. Right click the table and select Generate Script.

There isn't a lot of difference between temp tables and table variables. They'll both spill over into tempdb if the data sizes are large.

If you have a lot of inserts/updates,...

http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

select count (x), count(y), count(x) + count(y) 'sum'

from mytable

A query can cause CPU to run to 100% easily. It's not abnormal to have CPU jump to 100% for short periods of time.

If it lasts longer than 5 minutes,...

Please don't cross post.

Answered here: http://www.sqlservercentral.com/Forums/Topic616635-360-1.aspx

Hey, this counts as work! It's always informational.

We've had issues here with people using rules and missing newsletters, or duping them. I only use rules for moving things that I know I get to later, like newsletters.

I...

update a

set leasenumber = c.

from machineaudit a

inner join machinename b

on a.computername = b.machinename

inner join leaseinfoimport c

...

We'd like to see you do some of the work here. Why do you need to drop things in a temp table? If there are no records, then you can...

You want the 5 rows prior to this line?

SELECT top 5 [pkid]

,[log_content]

FROM [Handheld_Logs].[dbo].[sample_log]

where [pkid] + 5 > ( SELECT [pkid]

...