I would think that you aren't under memory pressure, but you'd have to look at more than this. Check target server memory, check the disk activity for how pressured it...

zintp (5/2/2012)

---

I agree with your post, but have trouble reconciling it with the Modern Resume, which suggests blogging, tweeting, and speaking about your professional life, in addition to the work...

gert.j.kruger (5/2/2012)

---

For SSD Raid 1+0 configuration I have been advised by our hosting company that the total storage space is different than for traditional drives. My understanding is that...

If you converted it over to a varbinary, you need to convert it back.

DECLARE @c VARCHAR(20), @b-2 VARBINARY(max), @d VARCHAR(20)

SET @c = 'Test'

SELECT @b-2 = CONVERT(VARBINARY(MAX), @c)

SELECT @d = CONVERT(VARCHAR(20),...

Is the old server still running?

Is this x86 (32bit) or x64?

If you have specific questions, we can help, but spend a little time on those articles and you should be able to put something together.

How did you convert it over? just an insert?

This looks like binary data. Maybe a cast( as nvarchar)?

Woot!! :w00t::w00t:

The way you usually do this to minimize outage is that you do a backup and restore. However not just 1. Typically you make a full backup and then start...

LOL, excellent. Not sure it's the best, but it's pretty funny.

You're missing...

yazalpizar_ (5/1/2012)

---

With the proliferation of SSD disk and its costs going down, some RAID levels with low write performances are no longer so low. Put an SSD in your life....

No worries, and thanks for the update.

I do know there is some length limit which causes issues, and is silly, IMHO. That should be allowed.

Peter Maloof (4/30/2012)

---

If 'tracked and factored into the assessment' means, "the coder knows what they did wrong, and got training so it won't happen again", then that could be a...