Well, errmm... You need bigger hardware! 😀

Seems to depend on...

Hi UMG

Here is the cursor I...

Hi Richard

Go to "SQL Server Configuration Manager".

* Select "SQL Server Network Configuration" -> "Protocols for MSSQLSERVER" and enable "Named Pipes" and "TCP/IP" (to be able to connect from another...

Snitch!

😀

I have to say the cursors not only win the MAX data-type contest. The set-based solutions have a generally problem with large items within the source text. Have a look...

Just two simple thing:

Change the initial database/logfile sizes and change the stupid default database configuration to grow files by 1 MB!!

I will never get tired of tellin this...

Greets

Flo

Don't forget, no indentation saves the environment. More spaces need more disk space and more...

Hi Paul

I know this sound's strange but all my tests showed, that the set-based solutions using a Tally table run into problems with huge text and large result items.

Remember Phil's...

Hi

I prefer WinMerge[/url]

Greets

Flo

Hi Ray

I'm not sure if I understood you. But if you want to update the fields of your @Primary only if they are currently NULL try this:

[font="Courier New"]DECLARE @t TABLE...

UMG Developer (5/10/2009)

Yes the data is all text. I'll have to take a look at your proposed solution, but it would need some work to handle all the possible crap...

Hi Karl

Thanks for your feedback. No his name is not Nigel 😉

I will inform him that there shouldn't be any problems with online index rebuilds.

Greets

Flo

Hi Jeff

I saw your question and you are correct. If the data are imported by a file this would be the best approach.

But I already started with my solution and...

Hi UMG

For now just a simple approach.

Since your source data are not enclosed with a leading/trailing delimiter I took my UNION ALL Tally version to do the initial split. This...

Hi UMG

Maybe I have an idea. Just for ensure. Your data are text data? No binary.

Greets

Flo