Query on image column broken | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Query on image column broken

I have a table similar to this:
Id int identity primary key
ImageData image
OtherField varchar(20) etc If I execute this against a record with a null imagedata:
SELECT Id FROM MyTable WHERE Id=12345 AND ImageData IS NULL then the query more or less times out however
SELECT * FROM MyTable WHERE Id=12345
returns a result immediately. This query has been in place for a long time prior to moving to 2005. Can anyone suggest a reason why including an image or text column in the query criteria does not work in 2005 (it is happening in other tables also). DBCC CheckTable returns no errors. Regards, Martin.
Any error or warning information during this process execution? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
No, nothing, it just takes a very long time to execute.
It is on a production system so I generally kill it before it starts table locks.