Sure thing!

I can see that the execution plan is no longer retrieving the image column. I know the avg. reads will go down significantly considering only the non-clustered indexes are being...

Thanks a lot! That works perfectly. You are the man. :hehe:

Persisted computed columns are different from what you are talking about.

You are talking about Non-Clustered indexes (correct me if I am wrong.) They are only pointers to clustered index. If...

I know but I am having to work with what is there. When SQL Server parses the query, it is retrieving all the images that satisfy the first condition i.e....

sounds very interesting!!! let me login to my business machine and see if that reduces the execution plan.

🙁

Aww man.. it says "the text, ntext, and image data types cannot be...

SQL Server is designed to handle data in set format. Handling data on a row by row basis requires a lot of times the use of cursors and cursors have...

That was the first thought that came to my mind. I could add a persisted computed column that does a textvalid(imagecolumn) and stores it in a separate column of data...

Did you try rebooting server?

Sometimes starting and stopping sql server services wont help.

Did you try using a command line tool instead to connect, like: osql -E -S tcp:servername\instancename?

Also, under network configuration-->TCP/ip, did you check and see if it is holding the latest...

Just thought no one was interested. :ermm:

Put them back on. 🙂

And ofcourse, I would definitely like an opinion from the Gilamonster

Just wanted to ask; These are the list of SQL Server editions that the original KB article applied to:

Microsoft SQL Server 7.0 Standard Edition

Microsoft SQL Server 2000 Standard Edition

Microsoft SQL...

I think I found the solution. Its because of an Update lock that allowed a shared lock to lock a resource that it needed to upgrade to an Exclusive.

I...

Where are you trying to connect from?

In SQL Server 2005, you have a tool called Surface Area Configuration through which you have to enable TCP/IP by clicking on remote connections...

I know this might not be the answer you are looking for but if you are using SQL Server 2005, you should try fuzzy lookup transformation in SSIS. The fuzzy...