I believe the guidance that I saw from Paul Randal this week (Again, subject to testing), is 10% < fragmentation < 30% - Reorganize. > 30%, rebuild.

You know your system...

Thanks for the update. Hope it works out.

So 250 is a WAG, and you are monitoring, is that right? Are you also monitoring page splits?

I wouldn't. I'd pull it from a file/config area/registry, probably encrypted. That way you can change it if need be.

An enterprise scheduler should run across multiple machines. SQL Agent can do a lot of what is being done here, but that's what you use, a SQL Agent job.

SSIS...

you also need to check security. There should be a trust issue between domains, or make sure you qualify accounts.

Or is this SQL authentication?

If you post the exact error, we...

Hasn't the doctor told you to "stop doing that" yet?

I'd also save a link to the PM form for Grant. He would be the person I could call for this stuff, though I'd actually post something in the forums...

Late to the party, but I think everyone has been to the ER in the last 10 years except for my oldest.

- My wife leads the way with a broken...

I voted, and good luck.

I say get a book on the exam. They're all similar and the help focus you on the tasks you need to learn and the knowledge required to answer questions....

Congrats!

Do you have the log set to not grow beyond a certain point? I think this wizard has to actually bulk move all data, so that's a lot of log...

I'm curious how you determine that 1000 pages is too high. Paul Randal mentioned this week that he made up that number, as an educated guess when talking with various...

Travel safe, and enjoy the conference.

david_wendelken (11/3/2010)

---

Steve, your analogy about the Mission Impossible vs the Mystery Men teams was a good attempt, but it fails in one seriously important aspect.

Even the Mystery Men team...