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...

delete from mytable where vendor_num in (select vendor_num from mytable group by vendor_num having count (*) >1 ) and o_objid is null

i'm pretty sure you can't use select into on linked servers.

same as create proc/table etc -

you have to create the table with a direct connection on the target...

I agree - all of the apps i downloaded seemed to be pretty shoddy. especially periscope which i still havent managed to get to work correctly.

RAAS seems to be fairly...

I've followed the instructions and replied to the trial liscence email with the correct phrase in the subject line, but so far have not received a full liscence key......

but if you're using linked servers how are you running commands like

dbcc sqlperf(logspace)

which would tell you if a log were large or not required intervention (i.e a developer...

This is something i've been looking at for a long time and it's intersting to see how other people approach the problem.

unfortunatly I came across a stumbling block in using...

Japie,

I'm jealous. my colleagues seem to think that a single man like myself would have it easy, no ties or binds. but by the time i finish my working...

redgate's "sql dependency"

http://www.red-gate.com/products/SQL_Dependency_Tracker/index.htm

It's great, but for large databases (i.e thousands of tables) it chews up graphics memory and slows your system. - best used with about 50 tables max

it will...

you have to drop any subscriptions to it firts - but enterprise manager won't let you do that through the gui -

here is the script

sp_dropsubscription @publication = 'publication'

...