I've seen this with linked server connections before. in general linked servers are "bad" (they have a time and place sure)

you avoid using linked servers?

relicate the data or some...

a simple alternative might be

exec sp_monitor (from master database)

this will (without too much accuracy) give you % cpu utilisation between executes of the proc (amongst other things)

the...

hi guys

will be performing the red gate backup and test restore today, but in the mean time

file copy to another disk fails (as per original post) - which is...

already ahead of you - attempting to use redgate sqlbackup.

we suspect this may be a an o/s specific issue in files larger than 50GB.

Cheers

MV

select * from table_name where created_date>=convert(varchar(11), Created_Date, 106) and

created_date<convert(varchar(11), dateadd(d,-1,Created_Date), 106)

completly sargeable

if you look up sargeable criteria you will find that

column name on left hand side

any function(where humanly avoidable) on the right hand side

basic rules of query writing , and...

guys,

apologies for placing this in the sql 2005 section was meant for sql 2000

but have tio flame most of you here....(regret).....

if you read the original post

this is sql 2k...

in that case your largest transaction will when you reindex a table (most likely)

ALTER DATABASE MYDB SET RECOVERY SIMPLE

go

use mydb

go

checkpoint

go

dbcc shrinkfile (logfilename,1)

go

then your log file should never grow beyond a reasonable value (proboably the same size as your largest clustered index) again

problem pretty...

there are several things you can do scripting wise

select object_name(id),rowcnt from sysindexes where indid<2

is a quick way to geta row count for all tables

you can also "select object_name(id),text...

download yourself a copy of sql diagnostic manager from idera (idera.com at a guess)

you get a 15 server 30 day evaluation - should be able to identify what your bottlnecks...

have you considered it may not be a RAM issue. how are your disks configured ?

hmm - 512 to 2Gb in 2 days.

is your autogrow setting 100% instead of 10% ? 512-1024-2048 ? seems like a coincidence.

regardless of whether you use CTE or not, it's the INTO clause that is the problem.

i'm 99% positive that SELECT INTO does not allow 4 part naming

you have to Use...

this is what varchar(max) was designed for.

varchar(max) will be stored out of row (if i'm correct on that) therefore not counted towards your 8060 bytes and operates effectively...