Did this problem clear up or did it get set to Suspect?

If sql server was ignoring the case, then you are doing nothing to the sort order by making everything uppercase.

Sql server viewed everything at the same level whether...

We have ran into web page limitations, but not SQL. We have ran statements that were over 7000 characters in length, with about 99% of that statment being one...

If you must do it in QA, then do a SELECT SUBSTRING(col1,1,1000), SUBSTRING(col1,1001,2000), . . . FROM table1 and you should be able to see all of the data in...

I also get a similar error with the line above that one:

Object doesn't suppport this property or method:'cdoLanguageCode'

Object doesn't suppport this property or method:'Flds.cdoTimeZoneIDURN'

I assume that this is because I'm not defining the ADODB.Fields. I tried to do that with a createobject, but it didn't work....

Updating COL5 to a text value. I have simplified the query for ease of posting.

That's actually very very similar to what I was trying to explain that I already...

I know how to check how much memory my sql server is using, I wanted to know how you were doing it.

I would definitely go to the latest version of...

You never said how much memory your server had in it. Gotta ask the dumb question, but what is telling you that sql server is using 1.2gb of memory?...

Not sure if I would feel comfortable to kill a process on a regular basis. I know it's not as dangerous as back in the 6.5 days. I...

That has got to be the longest single select statement that I have ever seen! I have nightly scripts that process millions of rows of data that aren't that...

I may be corrected on this, but the reason why you log shrank from 25gb to 2gb in 1 second was because there was less than 2gb of transactions in...

Colin - good point about the compression on tape, forgot about that. I still wouldn't backup directly to tape, way too slow. We don't backup to tape, we...

I use WinAce at home. I like the fact that it opens a wider variety of files. We got WinZip at work before I heard about WinAce. ...

The 2gb file size limit is a limit on the size of a zip file that can be created, not the size of the file to be compressed.