ah ... triggers and performance .. now there's an oxymoron !

a dbcc dbreindex by tablename will also update all stats on the table. sp_recompile is for procs not tables.

I always run dbcc updateusage as part of my maint tasks.

you should...

The order of the columns is less critical than it used to be, I figure this has changed during service packs of sql2k, it also seems less important in sql...

the data is held in the extended properties meta data - there's a set of procs which handle this data, sorry forget which and I don't have a sql server...

I sometimes wonder about some of the posts! I suggest you start with basics in o/s etc. etc. You don't have enough physical memory to satisfy the requirements of your...

I was never impressed with Erwin, I did use Popkin system architect for many years, but these tools are far too expensive for most companies. I have Visio included with...

As in all things "it just depends", joining against table variables which hold , say, several thousand rows can give some strange results.

Best is always to test and test...

put it through profiler with varying sizes of data - that way you get to understand and learn the impact rather than just getting someone else to do your thinking....

The answer to your problem is data partitioning, possibly vertical and horizontal, you're talking of adding about 30 million rows a month - that needs partitioning

You also need indexes to...

yeah I did think I didn't really mean to say that after posting  < grin > !!!  quite often in joins however where it's not a singleton join they tend...

never see it as a war - that indicates conflict which is a negative. However, that said I have a xmas mailing list to recieve  The Muppets Wizard of Oz...

you may find the index is not required if you're then going to select * from the temp table. Table and table variables work just the same in loops.

generally adding...

Yup sounds like a poor plan to me, however, you mention table variable - these are good for small datasets - you say loading a table into one and looping...

The main reason to use table variables is to skip object creation and recompiles. Quite rightly table variables do not maintain stats and although you can add a PK the...

It works all ways around, there are Managers, Developers, DBAs, Directors etc. all of whom may be "challenged" in one way or another.

If you care about your work it's sometimes...