I guess bcp and table export using DTS will give actually same result, i.e. time. Thanks

1) From business point of view splitting is OK. 2) I am afraid that restoring 4 TB database or export 2 TB tables over network will take longer. But I can...

1. Setup was completed without SSIS installed                                                              2. UI                                                                                                               Thanks

Couple days ago we 've done this trick with 4 Tb database- no problems

Thanks everybody for responses. Just to keep you informed- if DB comprises more than 16 files (mdf + ndf + ldf) attach doesn't work. In this case we should use "CREATE DATABASE...

Thanks a lot. Everything is as you pointed.

Thanks. I already tried also and it works fine. The only thing I slightly confuse about- what happened when I installed Sql Server 2005 Developer edition on my PC (and...

Check this article from Steve Jones: http://www.sqlservercentral.com/columnists/sjones/outerjointrouble.asp

Thanks, Jeff- we really have 4 CPUs.

Frankly, I try to understand what these CPU numbers means (I certainly know from BOL: “Cumulative CPU time for the process”), i.e. how to...

OK. Can I transfer these cycles into seconds? Or, probably, I don't need it as this CPU # is used only to compare with another process? I mean, using this...

Thanks, guys

I know this works but as my query a bit complex I don't want to use dynamic Sql. Thanks

Create derived table with count/group only and then add the rest of data you need

Sorry guys, didn't see new posts. Anyhow, the actual query is a join:

select t1.id

from table1 t1

inner join table2 t2 on t2.id = t1.contentid

where t1.custid = @custid and t1.deleted = 'N' and t1.statusid != @newstatus

         and...