Probably the main reason it's running so slowly is this:

DATEDIFF(d,CONVERT (VARCHAR(10) ,RL.TS_ID,101),

(SELECT CONVERT(VARCHAR(10),Last_Successful_Run_Date,101)

FROM dbo.tbl_Load_Audit_History WHERE [Object_Name]='PLUS_IDO_SALES_DETAILS' AND System_Name='PivotLink' AND IsActive=1)) <0

(From the Where clause.)

First, it's a correlated...

I'd say that it had realized after the first run that the only column you're actually using from each of the first CTEs is the SSN column, and that the...

Is the database running at acceptable speed? Users get their data in a timely way? If so, I wouldn't mess with the indexes. Not with what you're...

RAID-0 should do well on write performance, in theory. I haven't used that on a database, for data-safety reasons, but it should be okay. RAID-1 won't write as...

My usual solution would be to either set up an SSIS package and have it clean up the data in there before it goes into the final table, or to...

I'm not clear on exactly what you're trying to do here, but this part definitely won't work:

sum(select t.tax1_amt as 'IVA' where tran_code='7000'

Nor the other parts like it. Not sure...

I wrote a couple of articles on logging and auditing a little while back. They might help. They're at:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

The discussions have a lot of good data in them...

I've used that kind of arrangement before. Lots of companies do that. Can get a little slow if you're transmitting large or frequent data sets/updates across the Net,...

If it's an OLAP database (which is what it sounds like, with infrequent writes and lots of reads), RAID-5 should work well for the data files, but you probably won't...

Have you taken the samples you provided, and run them in your database on your dev server?

Can you fit the whole thing on a RAID-1 of the two drives? That's the safest. If you really don't care about that, then RAID-0 with multiple partitions...

I'm assuming your table has a PK, probably an ID. Here's something that will work:

;with

Numbers (Number) as

(select row_number() over (order by object_id)

from sys.all_objects),

SplitString (ID,...

Before anyone can help you, you need to at least post the code in the proc. Most likely, you'll also need to post the table structure and insert statements...

Since triggers have to be created on each table that you're going to log, why not just put the primary key in the trigger directly? This seems a little...

LOL

What makes you think I don't go over and talk to them? 😉

(They're both...