Just my 2ct.

Split the table !

My guess is the must be more info appart from the relation that you can document in your relation table. e.g. startdate/enddate of the relation...

if you are only selecting objects in the current database, you can use object_name(object_id) in your select list

0) keep your head cool. Know what you do !

1) disable automatic backup jobs !

2) make a new incremental log backup !

3) if you have the place or another server,...

- a (serverlevel) login trigger may server you very well

- a simple change of password may also do the trick if your applications support extrenalised credentials/passwords.

- and if I'm...

-ACID (A Atomicity, a TXN is performed in its entirety or not at all) (C Consistency, a correct TXN takes the db from one consistant state to another) (I Isolation,...

Indeed :ermm: I should have doublechecked (it) myself :blush:

back to the pile of perfmon/profiler files ...

have a look at the KB @ http://support.microsoft.com/kb/916287

Maybe the fix list rings a bell.

If you cannot find another reason why it slowed down, maybe it's worth to investigate .....

fixlist:http://support.microsoft.com/kb/894905/

I don't know if it is the case, but some things to keep in mind with an in-place upgrade :

http://sqlblog.com/blogs/allen_white/archive/2007/10/08/pay-attention-to-cluster-setup.aspx

- Maybe I've overread ... but did you apply Cumulative HofFix for sp4(build 2187)-KB916287 ?

It might be that due to increase of load or data, engine issues arrise ....

- also keep in mind with an in-place upgrade, all your databases (including the system databases) are still at db_level 80 (sql2000) !

- If you want to use the new...

it's the physical processors that count, not the number of cores.

So in your case 2 will be the number of processors to license if you want to enjoy your 4...

post upgrade steps:

-rebuild all indexes !

-sp_updatestats;

-dbcc updateusage (0) with count_rows;

-dbcc freeproccache

And offcourse then make full backups !

this may be hard to find out, depending on the traces you are running.

Maybe even a log-analyser kind of application can dig into your msdb-logfiles to find out, if possible,...

Peter Gadsby (10/29/2007)

---

Thanks ALZDBA Not sure what the benefits of sorting the data by the fields in the clustered index, because if the clustered index is not dropped the data...

just my 2ct.

Don't remove the clustered index ! drop all nci and then truncate the table.

Load the data sorted according to the clustered index definition. This way , your data...