select @@VERSION

status update: worked through ms support, verified that win wouldn't have caused this corruption as the detach/attach of the lun wouldn't have caused the partition data to be touched...

I would guess that being a heap is making the difference. I haven't fired up my work laptop yet this weekend, but some agent alerts hitting my phone say...

can you post what you have tried so far?

These are logical reads, not physical reads.

Every seek into a table gets counted as a logical read.

No.

Partitioning is not done for performance.

It is done for manageability.

if drive1 dies in your first example, you could still access m2, m3 and m4 while restoring m1...

check c:\windows\system32\cluster\cluster.log

DiverKas (11/20/2012)

---

Actually, the way around...

My apologies, You're correct that this won't work for your scenario.

You can't combine sp+cu into a patch for sql 2008 (just verified with sp3 + cu6).

It may be...

Full text querying only does prefix matching, not postfix

'erin*' matches 'erinblah'

'*erin' doesn't match 'blaherin'

There is no way to match the last half of a word.

DataHammer (11/15/2012)

---

We need to install SQL SP2 and CU1 at multiple sites on SQL/WIN 2008r2 EE clusters with 5 nodes, 22 sql instances, and thousands of databases. The problem is...

If you are seeing different plans, then I'd concentrate on that.

Any chance you can post both the good and bad versions of the plans?

Yeah, dpm doesn't play nice with log backups. I ended up doing the same thing you did. Tsql backups to disk with dpm protecting the backups.

kd11 (11/14/2012)

---

I have a new box, 2 processors 64-bit running Windows 2008 R2 Enterprise with three disk:

Disk0 C: (Boot, system files) 39.6GB Free ...

What does the sql errorlog show?