Very nice article.

Some month ago, I tried to do something like that, and I tried to improve the query doing my best but…I found that when you have dynamic queries,...

Hi Guys

a little late but here is what I did.

Finally I've resolved my problem and the response is in this post, so thank you very much for all your help.

So,...

Thanks again.

It is a database for telecom optimization, so lot of rows are inserted.

What happens it tha with primary index plus unique keys the program that insert a tranche...

Hi dajonx thanks

so accordint to yu suggestion, I am thinking in:

- Partition the table (I have to investigate a bit that)

- Add non clustered inxes (I think clusterd index...

Hi John

thanks a lot for the quickly response.

Here are some considerations responding your questions:

I deleted the primary key and I dont have a unique key. I do a control before...

Hi guys thanks a lot for both explanations !

My calculation was just to take the number of logical read * 8 gives the number of kb, and /1024 the number...