RBarryYoung (3/25/2010)

---

No, that's not quite how I would put it. I would say however, that there are some people who clearly create the vast majority of their own problems...

sys.objects would be insufficient. You also need to compare sys.columns and sys.indexes. Then their are the Primary Keys and foreign keys that also need to be compared.

You could...

Check out SQL Compare by RedGate.

In one environment, we ran update stats hourly and rebuilt indexes nightly.

Others we rebuilt indexes weekly and updated stats nightly.

It will depend on your environment.

You're welcome.

Nice read. Burnout is a serious issue and needs to be handled properly.

Thanks for outlining the symptoms and a good solution. If management is apathetic towards the employee,...

Yup - time to unsubscribe.

BlackHawk-17 (3/25/2010)

---

Based on this article from the CSS SQL Server Engineers team I think you are on the wrong path.

Compact is not defragment. It goes back to the Paul Randall...

For giggles, I just checked sp_who2 which also shows the DBCCFilesCompact.

Paul White NZ (3/25/2010)

---

It's not the title so much - I don't recall ever having DBA...

You're welcome.

The script where I was first able to trap this info was designed for SQL 2000, thus needs some updating. I have seen it capture this the FilesCompact in...

The term is fine with me. Why do you dislike it?

Paul White NZ (3/25/2010)

---

I am still trying to catch the DBCC commands in a trace - I get the shrink events and a blank DBCC event, but not the thing...

Database Associate

Database Admin

Database Architect

Database Aura

Database Alumni

In which sense?