Sorry, didn't read all the posts, but did you update indexes and statistics after the update?

Use a SELECT to debug this

SELECT bodytext

, replace (bodyText, '%/themes/old/%', '%/themes/new%')

from bodyTextTable

And on an unrelated note. Who wants this job?

http://www.youtube.com/watch?v=txdv_oNq81I&feature=youtu.be

Brandie Tarvin (9/15/2010)

---

[font="Verdana"]We're sorry. The user you are attempting to contact has been smited for biltong blasphemy. Please try your post again later.[/font]

[font="Verdana"]We're sorry. The user you are attempting to...

DELL is responsible to some extent. However then we just get more into a lawyer culture of suing everyone. Is it worth it for you to sue DELL for $10k...

It is doing maintenance. Look at these lines:

EXEC ('DBCC CHECKDB (N''' + @CVVCDatabaseMaintenance_DBName + ''') WITH NO_INFOMSGS')

EXEC ('DBCC SHRINKDATABASE(N''' + @CVVCDatabaseMaintenance_DBName + ''', ' + @FreeSpace +...

Are these dates stored as strings? Can you show some data or results?

ORDER BY doesn't do a random order. There must be a pattern if you have used it.

I would also suggest you engage someone that has done this. If you are going for a really large scale installation, Microsoft Consulting Services, or the SQL CAT team could...

BOL Reference: http://msdn.microsoft.com/en-us/library/ms187928%28v=SQL.100%29.aspx

LOL, I had to give myself something to aim for.

I'm hoping I get to 50k. That would be another few years.

There were lots of fixed in SP2, and there is a hot fix that you need post SP2 for 2005 servers. I would actually recommend SP3 for the server AND...

This is why we would need regulation. Companies left...

Allergies

you'd think with no rain for a month and none in sight that I wouldn't be searching out Benedryl this morning.

What do you mean handle? I'm not quite sure what you're looking for. Ideally the manager should be handling you.

Moving to Employees forum

DEADBEEF, that was funny :hehe::hehe: