If anyone is interested... here is what we came up with...

drop table #InvoicesWithBalances

drop table #AvailableCredits

drop table #invoice

drop table #credits

create table #InvoicesWithBalances

(

InvoiceKey decimal(18,0) not null,

Balance decimal(18,6) null,

ShipToNumber nvarchar(10),

SupplierNumber nvarchar(10)

)

create table #AvailableCredits

(

InvoiceKey...

Thanks Jonathan

Your points about the additional data in the tables are well taken - this is just a simplified example for the purpose of this post.

I was convinced going into...

Segiy,

That is not quite what I am saying...

In the initial application I had a query that did the following:

select * from MainProduct Table where...

Sergiy

We move all of the products out of...

Gail,

Most of queries we are seeing are:
      select * from #ChangeProducts where vendorpartnumber like 'bob%'

As noted above, the user has 5 fields to...

Here is the problem with the include --- 
the gird that returns the results is configurable by user, they can choose to have as little as one of the columns...

That is actually the only way it is used... the user is just doing a search on the table and they have an option of searching by any of the...

Good point Steve...

We do limit the searching to only strings that start with what the user inputted.
So if the user entered "bob" we turn it into like...

Adding myself to thread so I can see replies

I will Check that index!

when I refer to the server being slow here are some examples

- sms takes a good 3-5 minutes to open before it even let's...