Sorry, no plan.

Do you have good guesses why a query can fail all of a sudden even though no changes have happened in the table contents?

Kind Regards

Arthur

Thanks a lot for your quick reply!

I will copy the copied Microsoft statement about this small indexes from that link:

"In general, fragmentation on small indexes is often not controllable. The...

Are the Build List also valid for the corresponding Express Editions?

Sorry, if the answer is obvious, but I googled hard and dind't find an answer...

Thank You

A.

Is it Built Lists or Build Lists?;)

Nonetheless: Thank You for the effort!

Are the hotfixes also valid for the corresponding Express Editions?

Seems ridiculos, but I didn't find an answer to...

Just a little real world confirmation: our customer's DB ist hosted by a BIG provider and we have remote access

for...

Nobody?

Thank you for your fast reply!

So you don't have to have it return a bunch of stuff. a canned 1 will work just fine, because it will only show up...

Hi Lynn,

not exists(select 1 from dbo.CustomerProduct cp where cp.CustomerID = c.CustomerID and cp.ProductID = p.ProductID);

can you explain, why you use "1" in the exists-statement instead of "*"?

I also know some...