Which SQL version?

Wondering if you replace the Where with an ON clause

AndreQ try

Select Top 10

Case When Convert(Varbinary,Short_Descr)=Convert(Varbinary,Upper(Short_Descr))

Then...

Try

Select Top 5

Run_Date,Run_Time,

Convert(Int,Convert(char(8),Getdate(),112)),Convert(Int,Replace(Convert(char(8),getdate(),114),':',''))

from msdb..sysjobhistory

BOL 2000: Start with a search on "broken ownerships"

Try the site http://www.topxml.com/. Your bound to get some idea!

How many records are affected by the update. There are some articles about breaking update in smaller rowcount updates.

Something to the effect:

set rowcount 1000,

While updated_recordcount>0...

KevinBrowne check the posts at http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11595&FORUM_ID=9&CAT_ID=1&Forum_Title=General&Topic_Title=Strange+Query+Error

Very interesting!

Suppose the obvious solution is to flatten the inner most two sub queries.

In EM when in design mode for the specific table, can you see the formula row, bottom left?

Agree, can schedule it to run at 1:00 am on a Sunday or daily.

At a previous employer the word DISTINCT in big queries was used as a flag to check the queries for lop sided joins during code reviews.

Declare @c Varchar(1000)

Select @c='exec master..xp_cmdshell ''scptxfr.exe /s TheServername /d '+db_name()+' /f \\servername\x$\'+@@Servername+'_'+db_name()+'_'+

Replace(convert(Varchar(8),getdate(),112)+'_'+convert(Varchar(8),getdate(),114),':','')+

...

If uploading into a tmp file and then strip with TSQL. See discussion:

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11457&FORUM_ID=19&CAT_ID=3&Forum_Title=Data+Transformation+Services+%28DTS%29&Topic_Title=Uploading+a+Binary+flat+file+into+a+SQL+server

Look at article at

http://www.sqldts.com/default.aspx?6,101,292,0,1

What is the size of these files?

How about filtering / dropping the funny characters before importing the data. Will result in reading the file twice but will make life much...