Tnx for the response, Goce. I had found it already. Now let's hope someone can answer my other question...

Tnx for responding, Kenneth. I did check the query with Showplan, hence my adding indices and trying to add columns to denormalize the table to make it unneceserry to have...

Tnx for responding, Steve.

What happens is basically a monthly process on 7.000.000 records, which are updated on 60 busynessrules. I've used Perfmon and Profiler to check all the possible...

Tnx for responding, STeve.

Since the database is a COPY of a subscriber and not part of a replicationproces it is not possible to disable the subscription.

I do not know the...

Tnx Dave, this'll work.

Tnx for the info, Vladan. Your first explanation is correct, it is part of a dynamically build statement with optional qualifications.

Tnx again.

Tnx for the info, Steve. I'm trying to think why you would want to add a qualification, where you will always get something returned.

Another question that has been posted incorrectly. Isn't anyone validating these questions before they are being posted?

Come on. So they slip 1 every now...

But if it doesn't, then why? The world as is should be, and the real world often are 2 different entities

I failed to see a difference between the 2 selects. Can somebody point it out to me? As like I'm a 6-year old?

I just guessed the official right answer. I don't mind the occasional error in questions, ont the whole their good and one learns from them. However, Robbacs question is not...

Check your recoverymodel. I think it will be a Full recoverymodel. If you change it to simple the t-log will not fill up much, cause it will be regularly truncated. Be...

With large I take it you mean a log full of transaction, and not a log mainly consisting of empty or unused space.

A large t-log in itself does not...

Shoe! You beat me to it, I was going to ask that question. It's a easier statement to use.

Tnx Steven, I followed your sugestion, but could not find anything with 'trace' in the output. Found out tho what caused it. I have a trialversion of Quest Spotlight running,...