Hello Gail

Hmm, fair enough. I forgot to mention that the database in question only has simple logging enabled, so elapsed time since previous log backup shouldn't be an issue.

I have...

Hi Andrew

Thanks for the quick response, and sorry about being a bit sketchy on the details. You guessed absolutely right, though. I had a feeling CTEs would come into the...

Bill Talada (8/29/2014)

---

The parser is very forgiving of formatting. If you think of 4-part names as each part being independent and as overriding a default scope, it will make...

Hello John

You're right, it does work. To my mind, it oughtn't to, though. The parser should throw out the "dbo. " as an incomplete name.

Makes me nervous when stuff like...

IMHO The immediate visual effect is clean and fresh. Putting the above mentioned improvements in would make a good thing better though.

The exercise, I suppose, is to maximize the total...

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-2@Work

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

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...