Hi Grant,

I think I understand what your saying. This is the design I came up with before:

I have four tables:

First one is called items:

ItemId, ItemName, DateAdded, etc.

99, "Cup", "2007/01/01",...

Hi Grant,

Not exactly sure what you mean by the many to many prevent it from having to store a row, would you just not store a value in the metadata...

Hi Grant,

Thanks for reviewing that, glad to see I was on the same page, although I'm still not 100% about the purpose of the many to many join between the...

Hi Guys,

I really appreciate the feed back and ideas you have offered so far, obviously my SQL skill aren't as developed as yours are 🙂

I agree on the loose requirements,...

Hi Grant,

Thanks for the reply, I tend to agree with you, the full text solution works but its not perfect.

In regards to requirements, in simple terms they are:

1. Able to...

Thanks heaps for the suggestions!

Full Text Indexing - To be honest its not a technology I've used a lot before, It does seems to improve the query time significantly if...

1) To address your original issue of the sort taking so long to respond, indexing won't help unless it is clustered, and that would then only help when sorting...

Hi Guys,

Thanks heaps for the answers, yep its definalty a odd one, okay so after further testing I worked what was slowing the query down.

I have the table I mentioned above

StorageItem Joins...

Hi There,

Not sure if this helps. Im assumeing your using windows 2003? The page file is kept on the same drive as the OS by Default and its called Pagefile.sys. On...

Doh sorry Site Owner thought your name was newbie!

Still any ideas anyone?

Thanks Newbie!

Seems no one is interesting in throwing their two cents in for once

Thanks!

A