hold on maybe i have the .xdl 🙂 learning all the time!

hi Gail, i dont have a profile of it, this any use?

hi Gila, do you mean this?

i cant change the code Des (its core ERP) 

and i wish Thomas 🙂 - it will be going at the end of next year, but thats a bit...

Sorry thom obviously didnt read your request very well! Will try your suggestion when back in the office

Drew, i am basing purely off execution plan, i think 80% cost...

Hi Thom

full query is

select distinct s.Customer
,(cASE when OrderType <> 'E' then OrderType else ProductGroup end),d.MWarehouse
,OrderDate
,left(datename(dw,s.OrderDate),3)
,left (TrnTime, len...

all worked fine ! thanks for help Sue

hi Sue

thanks for this, cant remeber the server ever being 004, must have been done by the hardware guys and then changes later, i guess if i find...

thanks Mark great job! perfect for what i was after

hi Jasona 
yea PAE was already configured as we had 8gb ram

now we haev 32 gb and sql is setup for max 25

ok thanks sue

going to keep a close eye over next few days

hi Sue

thanks, i will have a look, but is it not strange that these have suddenly started appearing just after we add memory?

mal

closed the open transactions, which in reality are down to poor application design, and i could sort out the log file as expected

thanks

mal

all is working perfect now

thanks everyone that helped me

mal

ah yes my db is full of what seems dead end connections, i knew i was forgetting something!!

thanks guys - again