OK, great, that's one start. Now can you follow up with the rest?

No, you can't ignore the error. 😀 Check all of the event logs described in our troubleshooting checklist:

http://www.brentozar.com/archive/2011/12/sql-server-troubleshooting-checklist/

Go through all of those, and the error's going to show up in...

inteledyne (6/7/2012)

---

Switching the last partition in the 6 month filegroup to the archive filegroup will cause a complete index rebuild on the whole archive table? can i prevent that from...

There's a fundamental problem with your diagram: you've got tables tied directly to files. Tables are never assigned to files - nothing is ever assigned to files. Objects...

rmechaber (5/1/2012)

---

So, while I've got your attention: is there any? miniscule? significant? write-performance hit in writing to a 2-drive mirror compared to writing the same data to a single disk...

rmechaber (5/1/2012)

---

But I don't understand why a hardware-based RAID controller doesn't simply pipe the same data off to 2 disks simultaneously, reducing the write-time penalty to something much less than...

Greg - good post, but the explanation of IOPs is not correct. You write:

In basic terms IOPS is a measurement for the amount of time, on average, required to...

Gsquared - no worries, no apology necessary. Guys like that break communities apart by getting people all riled up on both sides. (sigh)

Of course you don't. You just want to...

Did you pay a lot for those?

TravisDBA (2/17/2012)

---

Ok, Brent you win. But I will close by saying that both you and Robert, with the upmost due respect to both of you, have a vested interest in...

Travis, if you walk into a meeting of scientists and say, "I believe there's rainbow-pooping unicorns until anyone...

Based on the utter lack of evidence from you and...

TravisDBA (2/17/2012)

---

Not my words. There, don't blame me for what other people are claiming. They are the ones saying it, and not only that, if you look close enough some...

TravisDBA (2/16/2012)

---

That would take more than 7 days to do, so I decided not to take him up on that after he gave me only 7 days for one dump....