Ed,

Thanks for your reply, I think you're correct on all points.

From everyone's feedback so far it looks like what we have at the moment could well be the best...

Sorry, no...I did mean to remove that.

Darren

Hi Jeff,

I've fixed the problem with the CROSS JOIN, it looks like we've had that code in there for a good few years:rolleyes:.

Here's the revised code: -

SELECT

...

Hi Grant,

I've done some further testing on the inserts and it only takes about 15% longer, so not too bad. I'm bulk loading the data via a C# application, using...

I've tried changing our process so that all simulations are written to the same table with a unique ID for each simulation.

[SimId] [smallint] NOT NULL,

[ValueIndex] [smallint] NOT NULL,

[TimeIndex] [smallint]...

Thanks for the replies guys.

Kevin, you're right, customers do tend to spawn up new databases once they reach the size limit in SQL Express. I'll try the clustered index approach,...

Thanks for your reply Grant.

Once a simulation has completed the user would then typically view the results (or a subset of the results) via our application. They might also want...