Thanks people I'll leave it at that.

The nice thing about this forum is that you know the answer to your question is out there somewhere in the brain pool, and...

Hi Ryan, thanks for responding.

I downloaded the 64-bit version of the package you mentioned. Before installing it, however, I decided to retry the import - which worked!! Very good, but...

I have now killed the SELECT query, which was still churning away after more than an hour.

Many thanks everyone for helping to nail this one. I can now make my...

No, it wasn't, but it is now (10 GB).

@ChrisM@Work

Number of recs returned by your SELECT version of the query is unknown but large...it...

I can't get hold of our IT people at the minute so will cap the size of the tempdb log at 10 GB and re-run. Don't expect it to work,...

Hi Jason

The master/model/MSDB/tempdb data and logs are all on C:. Total size of everything except tempdb is 41 MB, which is trivial.

The tempdb.ldf file is about 965 MB and the...

LoadConsultationsOP is 79037 rows, data space is 36.055 MB, plus 0.141 MB index space.

Sorry, don't understand your suggestion re batched process, but that's no doubt just me - please explain.

Thanks

Mark...

"There are three kinds of lies: Lies, damned lies and statistics." If we replace the word "statistics" by "the abuse of statistics" then this use of the stacking system is...

Rather than attempt to "manage" the size of the file, look to the transactions that are being done and see if they can be done in a more efficient manner....

The appalling proponents of linearity in the technology business could do with mandatory isolation from from all forms of communication for a week with only a copy of Tractatus Logico-Philosophicus...

It...

So often, when I have written code with a view to being able to handle possible future expansions or changes in requirements, the life I have saved has been my...

I like summer time. It caught on because it was a good idea (though not for calculating durations!)

The worst thing is not knowing the calculation rules for a particular time...

Good for you GSquared. What does it profit a man to gain the whole world, if he loses his soul, or injures it?

Or, if you want to be mercenary...

Of course, separating duties can help a lot by decreasing the opportunity for, and temptation to, wrongdoing. But regulations don't, and can't, solve the basic problem.

If one defines "human nature"...