Change to ALTER INDEX as suggested by Michael. DBCC INDEXDEFRAG is deprecated and will be removed in SQL v12 or v13.

http://msdn.microsoft.com/en-us/library/ms177571%28v=SQL.100%29.aspx

Jeff Moden (11/26/2012)

---

Michael Valentine Jones (11/25/2012)

---

I think they quote most mechanical disks with a MTBF of 1 million+ hours. I have to assume that they get these numbers from...

The DTA recommendations shouldn't be taken blindly. I think rookies can use it, but take one change at a time, test it, and see if it helps. Don't create lots...

Thanks, updated.

I'm back, and it looks like things were quiet. Other than Jason's humorous pictures and Jeff's attempt to get the thread into a serious discussion :w00t:

Not enough snow, but a...

Landy_Ed (11/19/2012)

---

Surely the very fact that you get a clearer picture of the impending expiry of the drives makes it less necessary to stage out the drive ageing? I'd be...

Perry Whittle (11/24/2012)

---

The differences between RAID 1+0 and 0+1 are not academic. Let's just review that again, not academic!!!

If you do decide to deploy a 0+1 array for your mission...

Leaving for a week in the mountains. Y'all behave.

That's what I get for replying in a hurry. I grabbed the first script off the site without testing.

My apologies.

That's not a bad idea. Not sure how much coding is required to do an "or" for the answers here. Might be substantial.

Agree with Gail. If you use scripts, there's no issue with x86 v x64

I'm not positive that will show all the dependencies. If you have SQL Compare[/url] (from Red GAte) or a similar tool, they usually do a better job of searching out...

This work:

http://www.sqlservercentral.com/scripts/scripting/69282/

I can understand that. Not sure how much development this would be. I'd like to expand the testing engine, and we have ideas and things on the dev list.

I'm not...

Interesting idea. Is this any different than just picking a random answer?