You're welcome.

try and rebuild indexs on all dbs at least once a week, daily if you have teh maintenance window.

As much as I dislike it, the DB maint plan wizard...

DBCC DBERINDEX is rebuilding an index anyway, hence my post and questions about index.

I prefer my own backup, index and statistic maintenance to that of the wizard, which does only...

Standard will use no more than 2GB, regardless of OS

Enterprise can use upto 64GB, limited by OS

KB316749  http://support.microsoft.com/default.aspx?scid=kb;EN-US;316749

states that when a server has 2+GB RAM then it...

Why RAID 5 over RAID 1+0?

Why Intel over AMD?

In which case, it should have shrunk...

Does the table have a clustered index? rebuilt it recently if so?

If not, create one (permanently or drop it afterwards)

Try DBCC SHOWCONTIG on the...

There are sizing tools on the net but it can be worked out.

Without delving into MSDN, I don't know the overheads per column, row, datatype etc off-hand.

With 240ish columns, it'd...

Ok, no probs.

A row must fit on a single page (8K) and has a maximum row length of 8060 bytes.

If, with 250 columns you had a row size of 3000 bytes...

If you really need your "missing" objects", as I said, and have you tried it:

If you mean the "dt_%" rubbish, these are created when you right click a table, "Open Table",  "Return...

A dedicated SQL box will help.

Off-hand I'd say your CPU usage may be a consequence of paging, which is generating IO, causing normal db IO to stall etc.

Without seeing the...

Great, SQL Enterpise and 8Gb RAM with AWE for starters then.

SAN, hhmm, not really worked with one yet.

I did research at my last job for a SAN and it all...

It should only do this after the first SP4 install.

After that, in-use system dlls have been upgraded and will not be upgraded again.

Hopefully

The...

Yes get a dedicated SQL box.

Assuming you have Windows 2k advanced or 2k3 enterprise, and can run Enterprise edition of SQL, get more RAM (8Gb total, use AWE)

This is next...

Check out DBCC CLEANTABLE

This reclaims space from dropped text columns.

It can be set to run in batches as well so you can break it into chunks.

See what happens...

Lots of RAM (8GB)

CPUs (watch me get flamed) - AMD Opterons. Point to point bus, not shared like Intel.

That's why Intel have huge L2 and L3 caches to compensate for...

There are NO system stored procs in user databases.

<SARCASM> Repeat NONE. That is, less than ONE </SARCASM>

That said, there may be in a replicated database.

I can't remember and I have...