Your suggestion about loading into a clustered index being faster than a heap and then re-indexing requires the data to be pre-sorted. So somewhere you have to sort the data....

In that project, I had the luxury of liaising with the person creating the files to define a file format. It was a TSV format and the same format for...

In answer to your question, it is about 10 years since I did this load, but from memory the load was into a heap table that subsequently had indexes built...

Rather than having a master package distribute the list of files to process, another approach is to give each package the rules it needs to process the subset of files...

I very often deal with high-end SQL Server systems: These are almost never virtualized, because there are only drawbacks, not gains that can be made from virtualizing machines that utilise...

I very often deal with high-end SQL Server systems: These are almost never virtualized, because there are only drawbacks, not gains that can be made from virtualizing machines that utilise...

I think that while this process shows what can be done with SQL, I would question whether this should be done in SQL: String manipulation is not SQL's forte (neither...

You don't need a lawyer to negotiate terms. Just try it yourself.

English law precedent is that non-competitive clauses over 6 months are unenforceable. Furthermore, any clause that effectively prevents a person from practising his profession is also unenforceable.

thisisfutile (3/14/2016)

---

So if it's so good to be given a number and told to stand in line, why...

thisisfutile (3/14/2016)

---

Can't back it up but I too didn't believe "2 years" was realistic until I rode a 40 minute shuttle bus from Clearwater to Tampa airport and during that...

I wouldn't do it this way at all - I'd bcp out all the tables to be changed with -c -C<old code page> then bcp in with -c -C<new code...

This is meant to be about SQL Server, but djackson 22568 seems to prefer writing...

What has this got to do with SQL Server? Of what interest is this to anyone outside the United States in any case?

What next? How about writing about kindergarten choices...

This example is nice, but it still has one performance bottleneck - the sourcefile is still running on a single thread, so the dataflow can only run at the speed...