Well I can tell you I am very relieved it is now running at that speed, we now need to transfer all of the users onto that machine...

Shouldn't you use table variables rather than temp tables? Or are there disadvantages to using table variables?

From BOL it says the following:-

table variables used in stored procedures result in fewer...

Well we moved our ETL code onto a new machine.

This machine is the same processor/memory specification but has 6 15,000 RPM disks ( 300Gb each) setup as RAID-10.

The load on...

I don't have a URL, but to use SQL Profiler do the following:-

1) Start / Programs / Microsoft SQL Server>/Profiler

2) file / new trace

3) login to SQL server

4) Select...

SQL Profiler?

Hi,

Have you tried running SQL Profiler on the server when the process is running. To confirm the statements you are expecting to run are in fact running.

Have you also run...

I think they are the same

Pete

I agree, a reporting solution is not usually compatibile with transactional solution as the amount of data each are using is different. For example a large report may read 1...

Thanks for the link, I will have a good read of it when I am at home, as it is very detailed...

The objective of denomralising tables, is to reduce the number of joins to tables. Transactional tables are normalised and designed for speed of writing small amounts of data to the...

I think I have solved the issue with the index creation.... It seemed that the clustered index was becoming fragmented as each update was being run, this then caused new...

HI Bob,

The Physical Disk:Queue Length performance monitor shows between 10-167 when the process is running which indicates to me that the disk subsystem is being thrashed as I beleive the...

The insert was much slower. Although I didn't measure the updates after the insert.

Hi, Have you tried updating the statistics on the tables you are querying?

Pete

Dropping all the indexes prior to the insert and then running the insert and then creating the clustered index produces this output....

DBCC SHOWCONTIG scanning 'TRANSFORM_JOB_COST' table...

Table: 'TRANSFORM_JOB_COST' (754101727); index ID:...