Also, make sure you update your statistics on the columns and indexes that participate in the relocation.

Some query plans look crazy after a relocation, until the stats are updated.

Jim

Nice compilation of scripts to use for debugging and working with dbmail. Thanks for posting it, although I think you are trying to rob us of 'fun'. That...

Favorite line: ""Oops." Amaroth muttered."

No sweat. Things change every year or two so it makes it hard to keep up with the latest limits....

Stefan Krzywicki (4/27/2011)

---

If the 30 tables they'd have would amount to less than 2 gig you should look into SQL Server Express and see if the licensing allows you to...

Ah, very nice then.

You're very welcome.

Jim

Yep. They're working just fine for me too. Thanks Steve!

Jim

GSquared (4/26/2011)

---

Edit: EVEN BETTER! Seusian verse!

"I would not index that on a train

I would not index that on a plain

I do not like cluster fragmentation

I do not like that...

We'd find great joy in that, even if you get...

Nah, you're not an idiot, just focused on the question at hand.

When the day comes when we meet in person, you'll know how stupid silly strange I really am....

Run perfmon (performance monitor/server monitor) and then feast your eyes on this: http://www.quest.com/backstage/promotion.aspx.

This poster/PDF by Kevin Kline @KEKline shows the relevant counters and what values they should be at.

Jim

I must admit that this poster is pure awesomeness. Thanks for heading it up!

I have one here at our office as well. I'm actually seriously looking for...

Where'd that Uncle Jesse thing come from? I'll have to read back and figure it out. I missed a bunch of posts because of the notification delay.

Ya, one thing...

I've got proof anyway that copper is way slower than what some are claiming here. How many times have you or a coworker clicked Send and then shouted: "I...

Ha! Tom, you take me way to seriously. I thought the hyperbole was humorous; I'm...