Yes it's a couple of pages long so I've got around it by keeping it simple and only getting the fields you suggested.

Thanks,

Bruce

Hi Jeff

I'm trying to add a bit more info into the audit table by adding this:

SELECT client_net_address,local_net_address,host_name,original_login_name,login_name,program_name

FROM sys.dm_exec_connections SCON

OUTER APPLY sys.dm_exec_sessions SES

WHERE SCON.session_id = @@SPID

AND SES.session_id...

Great thanks for that. the other post is a bit complicated, I have a very simple model working and I can only improve on it if necessary. I much appreciate...

I have written triggers a long time ago so I'll give it a go and it all should come rushing back in.

Correct me if I'm wrong: I'll create the...

thanks, that looks good. is the delete table specific to each table. I'm thinking I might get away with putting the trigger directly on the apps table which shouldn't get...

my thoughts exactly although both ArcGIS and SQL manage memory really well. When I look at the performance the cpu's max out.

Thanks.

my thoughts exactly although both ArcGIS and SQL manage memory really well. When I look at the performance the cpu's max out.

Thanks.

Thanks

The temp table is fast enough but I can't see a way to implement it at user level at this stage, the vendors are looking at it. The indexed view...

Same result 7:26 for 32640 records. I have tried most of those (same thought) but not that one, thought you were onto something. Nice try.

Thanks,

Bruce

I'll skip that, it will be the vendors problem. If it's only to be used in reports I can possibly create the view without the order by and sort it...

Yes, thanks for that.

Would these record counts make any difference to your indexing changes:

select * from dbo.AMS_ASSETREGISTER --66451

select * from dbo.AMS_CATEGORY--115

select * from dbo.AMS_FIN_LINK -- 36240

Bruce

I didn't try the temp table but that works, thanks for that.

I'll also see if the vendor will allow adding indexes.

If I use a view I obviously can't use...

oh yeah, the tables belong to an application so I can't change any indexes.

when I check the execution plan it has the sort as 2% and the clustered index scan on the ams_fin_link table as the killer on 68% no matter how I...