files attached thanks!! didn't know I could attach files sorry

Sorry about the delay here are the two plans first one good second one bad, the strange thing is that a few times when running this query in the SP4...

Just tested it in a SP2 enviroment and its much quicker

many thanks

Yes I presume so, it is a very strange database, it is not normilized at all

I have been instructed to turn in on

Its a poorly designed database years and years old which uses 2 tables to store most things. Short term thats not going to change. So in the short term...

I am worried becuase the index size is over 100GB, do I not need to alter the index first to do it online?

ALZDBA (4/20/2011)

---

AWE is not needed on x64 OS with a x64 SQLinstance. ( it already has the ability to address all your ram )

Did you perform full db maintenance after...

Thanks for the reply but again the article was about new tables not exisisting tables.

But I did find a great article

http://www.databasejournal.com/features/mssql/article.php/3647561/Data-partitioning-in-SQL-Server-2005---Part-V.htm

Many thanks

Many thanks all working

I only want to remove all tlogs once a full backup is obtained, rather than deleting t-logs older than a day.

" log backups to recover to a point in time...

HI thanks I will run another profile and see if I can find the SP's in temp. Many thanks

sorry a missed out a #

the textdata of the SQL profile trace shows

"exec #jtds232232 'parm1'"

#jtds id not alwasy followed by the same numbers. this is not a stored procedure,...

Thanks online indexing was about the only thing I could think of. Many thanks