You should test TDE before completely ruling it out, it might be within acceptable performance metrics AND its free (assuming you have the right version of sql of course :)...

indeed! google...

oops - i downloaded the wrong CU3 update 🙂

Cheers - i've got it working now with the correct update

If you provide some CREATE Table Scripts and populate it with some sample data we might be able to help you a little further - might even be able to...

I've literally just done an upgrade from R2 standard to R2 Enterprise - took approximately 2 minutes 🙂

You are using the Enterprise ISO/CD right?

Also, i believe you should be using the Edition Upgrade option not Upgrade from sql xxxx option.

Google Search clicky

hmm clicky not being very 'clicky-like'!

http://www.google.co.uk/webhp?sourceid=chrome-instant&ix=sea&ie=UTF-8&ion=1#sclient=psy-ab&hl=en&site=webhp&source=hp&q=troubleshooting%20sql%20cluster&pbx=1&oq=&aq=&aqi=&aql=&gs_sm=&gs_upl=&fp=d072a3898a492a96&ix=sea&ion=1&ix=sea&ion=1&bav=on.2,or.r_gc.r_pw.r_cp.,cf.osb&fp=d072a3898a492a96&biw=1280&bih=923&ix=sea&ion=1

I believe you also need to enable mail session in sql agent

Don't think this will be causing your error though - just thought i'd point it out 🙂

Thanks for the replies, I've been thinking along the lines of exporting. Maybe creating a backup folder in msdb to store the old packages then if we need to restore...

Loundy (2/17/2012)

---

Hi All,

Interesting question. I think i must be doing something wrong when testing this myself though.

I've created the table and index like so:

CREATE TABLE TestTable (ID INT,...

Hi All,

Interesting question. I think i must be doing something wrong when testing this myself though.

I've created the table and index like so:

CREATE TABLE TestTable (ID INT, Col...

Hi Jason ,

Would you be able to post some sample data (with DDL scripts) - might be able to help a little easier if we could see the tables your...

patrickmcginnis59 (2/13/2012)

---

murthysundara (2/13/2012)

---

IF OBJECT_ID('Consultants') IS NOT NULL DROP TABLE Consultants

GO

CREATE TABLE Consultants (

ConsultantID INT IDENTITY,

ConsultantName VARCHAR(20),

Technology VARCHAR(15),

...

John Mitchell-245523 (2/8/2012)

---

Precisely. Would you use that...

Very interesting post...

I must be missing something fundamental here as I can't see what the problem is with using UPDATE... FROM. In CELKO's example there is nothing to specify...