no indexes on drsumtemp then ? - you said 600k rows.... i'm guessing the correct indexes will make a difference

sean's solution proboably performs better than mine

even better, i formatted it as you wanted

select l.name,test.testdate from tests

inner join

(

select locid,max(testdate) as md from tests

group by locid

) as lf

on lf.locid=tests.locid and lf.md=tests.testdate

inner join location l on l.locid=tests.locid

where...

select tests.* from tests

inner join

(

select locid,max(testdate) as md from tests

group by locid

) as lf

on lf.locid=tests.locid and lf.md=tests.testdate

where pfreal<0.7

somebody forgot to close and deallocate their cursor!! 😛

Single user on a particular module will have an estimation of 4-5 sec data retrieval (stored procedure was used to retrieve data). row count of the table is 600,000+ records...

this looks like an ideal candidate for redesigning the tables into a single and using range partitioning for each month

the output of your procedure is in a dataset. it is management studio that chooses how to display this.

the only way for management studio to display it how you want...

there there a trigger on the target table ?

in the original suggestion it was stated to use a raid 1 (mirror) for the C and D drives - but this would mean your d: drive that takes the...

are you replicating triggers as well?

the PK violations could be caused by a trigger at the subscriber.

if not then have a look at xp_replcmds and related extended stored procs (i...

are you trying to purge the data completely or is it a selective delete?

and a really stupid question, but no-one has asked the obvious.

are you deleteing the data in the...

there are many ways you can do this

i often opt to save the Excel file as CSV and then use BULK INSERT

you could use SSIS packages

but by far the...

If you have a copy of REDGATE SQLCOMPARE you can use the API for this to compare each database to a "template database" you can then have it put...

99.9% of the time, I prefer dealing with those databases that use surrogate keys, be they 'Identity', 'GUID' or other. I find it much easier to find the links I...