besides Remi's suggestions wich you must implement I would advice you not to write select * from vwBig... just request the fields that are going to be used and not...

HTH

if this is only happening when reading then you should look at the App code. if it happens after an insert on the DB you may try to  look at...

well you may get some recompilations of the sp until the cache "warms-up" but that should be all you should look for long running queries I suspect Index maintenance problems...

Not really I have seen the hot spare not to kick in and lost of two other drives so I've been there maybe I am also in that lucky group....

I hope this is a backfill of some column, because the right thing will be to populate the type at insert time and not to query the image column

And even with all the "if" statements if one of the linked servers to which the queries are referencing does not exists you won't be able to compile the above code!...

I have used it only on very limited occations that I have come across a design which is ussually not mine

Yes, it can be adjusted for Jet, which is really uglier (is there such a word )

UPDATE Contacts  inner join Project on Project.fkContactID = Contacts.pkContactID...

usually Substring is the recommended function for this

select Substring(MetaInfo, 1, 8) as FileType from dbo.Test

hth

master sysobjects contains the objects of ... well master

local db sysobjects contains the objects of ... well local db sysobjects

One sysobject per database

Do you at least have access to bcp or DTS ?

John,

 Just ignore the previous post because it is only criticizing and not helping you ( as usual  )

Can you post what are the definitions...

How about Printing that to a PDF Writer (printer) ?

 Just my $0.02

Count me in! I don't approve those manners and I couldn't care less who you are we are all learning every day (even him!, well, that,I hope