If you have to ask, we can't tell you.

Actually, you shouldn't be able to see fnord:anything between the:fnord fnords....

Sorry, you ought to be able do something like the following. There are probably better ways, but this...

Luke L (3/26/2009)

---

Chris Morris (3/26/2009)

---

If anybody wants to know...

Quotes are acting all wonky...

Anyway, I sure can have scotch & fly a Star Fury. It's space... what am I going to hit?

Besides, I've operated nuclear power plants while inebriated...

Bob Hovious (3/26/2009)

---

CONGRATULATIONS, ROY !!!!!

YOU are Mr. 3000.

In honor of this momentous occasion, you get to buy beers for the whole gang, and...

Chris has it. You should be able to use the PK value as an ordering clause. Delete the rows where the ID is not equal to the top ID ordered...

How about using the last update date column as a differentiator. Then you can order by that column and join on the text column. I would think that should get...

Not without some structures and execution plans. It's just too hard to guess at what might work in your circumstances.

Actually, it works fine. I just did it. You get the query results and the messages in a single window when you change the output from the default grid to...

I'd suggest picking up a copy of Craig Mullins book "Database Administration." It's technology agnostic and just talks about the job of being a DBA. It's a great read.

One option is to change the output of the results from a grid to text. Then the columns and the I/O all come out in a single window.

You should look up full text indexing for the varchar(max) column. That's the best mechanism for use with this sort of thing.

Are there other indexes on the table? A PK?

As Flo says, you shouldn't have to rebuild the index right after creating it.

Are you sure the index is working well with the query? Did the execution plan change before...

The truncate_only operation has been deprecated in SQL Server 2008. There is no replacement. The log is automatically truncated when the db is in simple recovery. There are more details...

This may not give you the answer, but it could help. Get the estimated execution plan instead of the actual one. I usually prefer to work only with the actual...