table caching is a dangerous thing to do ! because when you pinn a table, it will not be cached out ! Maybe your table grows beyond your expectations consuming...

Maybe DTS can do a better job for you.

In addition to Pam Abdulla's reply :

If you're updating a varchar-type column, it may be possible sql has to relocate your row to another page, maybe even perform some pagesplits...

just try to do an easy client install using a script when you have vs2005 installed with sqlexpress or when sqlexpress with its...

If this is a full load/refresh or your applications are offline during this load, you might want to disable your Non clustering indexes ( if your data is thrustworthy

If you have a clustering index defined for your table, when you prepare your data for load, sort it according to your defined clustering index !

This way you avoid page-splits...

If you change to simple, it will only keep info for the open transactions.

So if your load is in a single transaction, it will still grow to 95 Gb.

Can you...

I hope this is a singleshot or investigative query you want to run, because the querytype proposed later on is certainly _not_ a general practise advise !!

connect to your server...

Well ... handling these kind of problems is not easy .... that's one downside of working with linked servers.

Start sqlserver perfmon to captuer the...

regarding the sqlteam article (good).

there is a downside with using ##pivot.. ##meaning global temp tb.... global = everyone... so only one can use it at a certain time.

Maybe this can help out generating your script :

-- I did change to not include Primary Keys !!

-- You'll have to drop/create the PK-constraints if you want to...

How about statistics ? Do your have autostats enabled for your crm db ?

Every once in a while (3 or 4 /year) manualy perform dbcc updateusage and sp_updatestats. Depending on...

Those traceflags will have SQLserver log deadlockinfo to the SQLServer ErrrorLog-files.

look at yourdrive:\MSSQL\LOG\ERRORLOG

or use EM / Management / Sql server logs

search for Deadlock

no.

btw 1) select top 1 * into yournewtable from yourquery

should be

1) select top 1 * into yournewtable from yourquery where 0=1

 because you jus want to create the table without any...

- you could set your new filegroup to be the default filegroup. Remark : all new objects will then reside in that default filegroup, unless you reset it afterward.

- you...