First a comment, generic procedures that do everything, everywhere, automatically, are notorioiusly problematic. TSQL just isn't conducive to that approach.

The problem you're hitting is that you can't refer to tables...

Not sure about the first one, I suspect there's a different index name in there that is messing it up.

The second question, no update on the stats was needed because...

Most of this is available in system tables. What have you tried so far?

If you are placing a single quote within a string like this : 'O'Sullivan'. It actually has to be marked up like this: 'O''Sullivan' Note, that is two single quotes,...

The only one Gail didn't address is Update Stats. You'd be best to make that a part of the index updates. Frequency really depends on your system, but I'd say,...

You'd have to tell me how often it's called before I could tell you if it's a problem or not. I'm not crazy about setting up View SErver state for...

You have three options, all of them require you to run something on the production server.

You can set up a server side trace, which works just fine and as...

I agree. No way to know without discussing the details. A maintenance plan can just backup logs. I'd suggest that should be run many times a day, let alone X*7...

Laura Schmalzbauer (4/15/2011)

---

I'm trying to use sys.dm_db_index_physical_stats to find which indexes are fragmented enough to either be rebuilt or just reorganized. However, I am running into an issue where...

Kenneth Wymore (4/15/2011)

---

Doctor Who 2 (4/15/2011)

---

You brought up an interesting point, Jack, and that's the number of recruiters contacting you, trying to fill jobs. A few years ago...

Kenneth Wymore (4/15/2011)

---

I know exactly what you mean. Money isn't everything (although it does account for a lot)! I actually make a little less than I did before but everything...

Although, now that I'm thinking on it, you might want to take a look at Red Gate SQL Multi-Script[/url]. It might provide you with a bit more flexibility and power...

I don't completely understand the situation, but if you need to run custom queries and respond to those results, yes, you probably need to build that yourself. But it won't...

If you're doing the detach/attach, you might (might) be able to get away with it. Test it before-hand. You should test everything anyway.

The database structure is not published. You can get some of it from the SDK documentation. I'd start there.