Thanks every one. All your inputs and advises are absolutely correct. You guys are really helpful

Thanks SScrazy for your input on this. But i am trying to avoid Is Null as there is a chance for null value on my tables.

As GilaMonster suggests, i think,...

Thanks GilaMonster, i didnt read the entire content in the link. When i see that part of the script that using is null i tried out myself on the script...

thanks for the links. As per link the is null clause on the where clause for the lookup columns worked fine. But this works only if is null clause returns...

it is my understanding that we could do the same with left/right join. if not please advice what other option we have, if any

Thanks for looking on this. Yes, not in clause works as expected; but i think join gives better execution plan than not in especially the table size is huge. Thanks...

Check dbcc traceon (3604) or (7300) is enabled.

If it is enabled it should be off.

Thansk

Thanks for the response.

My version is windows 2000 advanced.

awe/pae enabled.

I have 4 gb of RAM.

No other application on the server other than sql.

I have added service account of sql server...

Thank you so much.............

I will try second option.

Thanks for the reply...

I cannot give access to the objects in question for this proxy account.

Do you think any other possible way.........

Thanks

MOST OF THE CASE YOU WILL BE ABLE TO TRUNCATE THE LOG AFTER YOU STOP AND RESTART SQL SERVICES. BUT IF IT IS IN PRODCTION ENVIRONMENT YOU MAY NOT BE...

HI ALL,

THANKS A LOT FOR YOUR IMMEDIATE REPLY.

ICHAYAN

Hi,

I also have the same question.

The book you recomended on your post is really good for a DBA or Programmer?

I am a DBA.

Can you suggest which one is good for...