Pavan, thanks for your help but i have clearly mentioned in my first post i can say it one more time. This is the actual query "SELECT * FROM myview...

pavan_srirangam (10/19/2010)

---

same results no improvement. It is retrieving from a view and it was working fine until yesterday..

Run both queries and include exec plans and see you will find the...

Leo.Miller (10/19/2010)

---

Nullable columns can cause problems for queries like this. NULL is an undefined value, think of it as "noise". This means SQL can't do an EQUALS test on it....

need to make lot of changes before i post here., i do not think it is possible

same results no improvement. It is retrieving from a view and it was working fine until yesterday..

Thanks Pavan. But part of my question was also i was refering to an article which was talking about identfying statistics..is that true?

Thanks.

thanks

george sibbald (3/24/2008)

---

Matt, thanks. I am sure the extra info on licensing will be useful to david though (don't know where I got paul from, sorry david). If he goes...

True Brandie, but after it reaches 8000 characters i need to do some conversion right? How do developers do this task in real world?I am sure there would be code...

Thanks Brandie, and i was refering to Wayne's statement. There is limit of 8000 characters on nvarchar and my sql dynamically generates more than 8000 characters of code and stores...

hmm.. i don't completely agree."Unless the text is over 8,000 bytes at which point it behaves like an NTEXT and stores the text value in the LOB".

Thanks Wayne, as i said in my first post the o/p is more than 8000 characters so i cant use nvarchar.Any idea?

Any idea on this one http://www.sqlservercentral.com/Forums/Topic1003225-146-1.aspx..?.thanks..

hmm...i would like to test once..thanks