It's not completly impossible. Do you have a table that's bigger than all the ram of the server??? or at least pretty darn close?

Yes, but we need a more specific question...

What do you need to do?

What have you tried?

What's not working with what you need to do?

I never had your particular problem with FTS so I can't help you much further than Google at the moment.

Good luck with this and let us know the solution when...

Does this help?

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=334759

I'm curious about this one too. I have been working on a package of reports but the only way I have so far to protect them is to host...

The only way you're going to fill up that much space in temp DB is to have a big reindexing job or huge reports.

If this comes from indexing, make sure...

You don't need to in this case and that's what you must understand.

Once you get that go in the books online and type computed columns and you'll get all the...

Yes that would work, but since the substring starts at character 1, it would make no difference other than adding page writes, reads and CPU.

Excluding the start character and assuming...

Live in Sherbrooke, Work in Pneus Supérieurs at the moment. Also work with Sico, Fordia and a few others.

Here's a second vote for Montreal, Quebec, Canada (well a bit outside, but that's where I work).

Ya, just make sure you keep backing up the log so you don't run out of space.

You may also test with smaller batches to see which is faster..

Also another way...

Please post those stats here, that way we all benefit from your experience.

With that many rows you may also consider 2 more things :

How many rows will be left after the delete? Sometimes it's just faster to figure out the...

You're welcome. So what's the difference in page reads?

GilaMonster (1/18/2010)

---

I have the feeling this is less of a case of it not working on SQL 2008 than it simply isn't supported on SQL 2008. So it might run...