Hi!

This looks really interesting!

Nevertheless, you cannot insert any data that is using these references until you have completed your above algorithm.  Indeed, your data tables must contain the indices, so...

Hi!

Thanks a lot for your input.

I agree with you on the char vs. varchar point, but I am ready to trade size for speed if needed, and I wonder whether...

Hi!

Sorry for my lag, it's been a hard week! 😉

Thanks for the info Jonathan.

I finally found where all my memory goes:

select count(*) from syscacheobjects

returns about 60000 thousands objects, accounting for...

Hi!

Forget about the #tables, I already got the answer!

I re-read thoroughly the memory management sections of Inside SQL Server this week-end (as if I had nothing else to do! 😉

It...

Hi!

Thanks for the info.

But my problem is not to limit SQL Server memory usage; it's alone on its box and can take whatever suits it fine.

No, what I want to...

Hi!

Jonathan: Thanks!

Thanks also for the link - but my problem is not to have the memory decrease: it's to make it stop increase!

That is: SQL Server memory increases relative to...

Hi!

Thanks a lot for your replies!

See you,

Xavier