Yes, If I add clustered index - performance degradation disappears.

thanks.

Thanks for your replies.

But update statistics did not help

Table has no indices, I'll try clustered index and report results here.

I use the following scripts to model the issue:

1. Create table

create...

I've tested that approach. Downtime is...

Eugene,

This helps in search scenario, not grouping.

Do you know any other fulltext solution that allow fast grouping?

Thank you very much guys, all your advices are very informative, thanks again.

Both table variables and temp tables are created in tempdb and are kept in memory if it is possible. But:

Temp table has statistics and query plans are better (sometimes much...

Peter,

I'm not sure about elegancy but building XML by concatenating strings and tags requires encoding of string values. I'd recommend using XQuery here:

Select

No as 'Invoice/InvoiceNumber',

CustomerNo as 'Invoice/CustomerNumber',

...

Hi,

1. Both methods are not what you really need. You need to review OUTPUT clause of DELETE statement. It allows you to backup and delete rows with single statement

DELETE MainTable

OUTPUT...

Hi,

Your explanations are not very easy to understand... But you can try cast(Text as XML) as "*"

Simple working example:...

bnordberg (10/14/2009)

---

I recently had to concatenate ~1.5 billion rows of text (average length of 110 characters). These were medical notes where each line was a sepearte row. I tested CLR,...