Ahh! It doesn't seem to like .txt files but thank goodness for good old definitely safe as houses .zip files!

That would be interesting if you could.

What I meant by "90% of the triggers are autogenerated" is that 90% of the triggers are fully autogenerated and 10% have to be...

Oh I see. 90% of the triggers are autogenerated so it's not really a problem.

However, I will see if I can resurrect the idea of moving all the textual data...

My pleasure entirely.

As it happens, we did consider moving all the data out to a new table (imaginatively called TAudit_Data) just earlier this year. Then TAudit_History would have had columns...

Jeff,

The TAudit_History table is used to record changes to data in much of the rest of the database. So if I change the value in the Surname field of a...

With PrimaryKeyID and Date included on the index, it's far faster and 0.23% of in the index is loaded but none of the primary key, as expected:

<b></b><i></i><u></u>

But...

Thanks Phil. Yes, the engine will have done what the optimiser told it to do but I'm surprised, given there is an index on the very two columns I'm searching...

Declare @DBID Int Set @DBID = DB_ID ()
Checkpoint
DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS
DBCC FLUSHPROCINDB (@DBID) WITH NO_INFOMSGS

That will clear execution plans and data from memory, which would be one...

For "may be" read "very often is".

Would you go further to say that if a query does run far more quickly the second time it runs, one of many reasons...

Thanks very much Sue. I wasn't aware of that feature of SQL. I'll investigate.

Unfortunately, the way we've designed much of the code means that SP1, SP2 ... SPn are all quite complex so can't be converted to UDFs - they're not just generating...

Apologies - I completely forgot to say that table X has a SPID column that's used to isolate the data between processes. The column has a nonclustered index on it....