Just to endorse Alzdba's comments....

1) No, the placement of the ID column at the end of the row will have no significant impact on your performance. Admittedly, it can...

Gloria - you cannot really calculate a perfect % fillfactor. The only real way to do it is by trial and error. The exact value depends on which...

If your transfer rate is good (and yours seems to be), then I wouldn't worry unduly. I tend to monitor the CurrentDiskQueue, rather than the AverageDiskQueue, since it gives...

This is one of the few things (in my opinion) that I actually find the index tuning wizard genuinely useful for.

Build up a full profiler trace of your application, recording...

If there is a WHERE clause, this will be executed first. The whole raison d'etre for the query optimizer is to reduce the amount of work that the database...

Try using "sp_executesql" instead of "exec"

e.g.

sp_executesql N'SELECT * INTO @fgoc_i FROM @fchitet WHERE ltrim(rtrim(calling)) = @calling AND ltrim(rtrim(called)) = @called order by calling, called, date, start_time asc',

...

Hmm. Biggest database I can test this on using SQL2000 is only 42Gb, but it works there with no problems.

All my really big databases (600Gb +) are on SQL2005,...

I'm a bit confused.

When you say "proc", do you mean "process" or "stored procedure"?

You say "only my proc is very slow ..." , but then say that this proc can...

Can you post the code, and also the table definition (including any indexes and an idea of how many rows the table holds)?

From what you've told us so far, I...

A word of warning - on SP3, parallel queries can be very unpredictable in the consistency of the results they return. I have seen a single query, run repeatedly,...

If the TextData column data is blank, then SQL2000 profiler will always display them I'm afraid. There's no way of avoiding this (at least, none that I've ever found,...

I presume, since you're using clustering, that you're using Enterprise Edition of SQLServer? (If you aren't, you can't use AWE on Standard Edition)

Assuming that you are using Enterprise, then...

Yes, you can use this quite safely. It won't restart the server. I suggest you create a scheduled task to execute this command as frequently as you feel...

The error is described here on the MS knowledgebase:

http://support.microsoft.com/?kbid=830366

Do you still have the data files (the .mdf and .ldf files) for your user databases? If so, can you attach...

There are a number of things I'd recommend, many of which have already been touched on here, but I don't think the ideal combination has been suggested yet:

1. The Command

==============

First...