I'd actually change it to not have to shrink the log file - have you checked your virtual log device numbers or how much ntfs fragmentation you have caused?

Failing that...

yet another post which talks about raid 5 - unless your database is read only don't use raid 5 , and to consider placing a transaction log on a raid...

your one plan is parameterised, the other is using literals. This is why.

You'll need to work on the parameterisation to get optimal execution.

a proc isn't an option , no I tested with similar spreads to avoid that scenario, it's just I'd prefer not to have hundreds of ad-hoc queries clogging the cache!...

agreed we're talking too different topics - no idea what Oracle RAC is. Clusters's protect the tin and hopefully give a minimum of down time - don't always think of...

assuming your timestamp is a timestamp data type then it doesn't record time but a binary value which is sequential(ish ) if you want to do datetime calcs the column...

yeah as far as I can see the plan guide doesn't work correctly. It's only a simple query too e.g. select xxx where col=value.

I'm not actually sure licensing actually does anything - I think it's more an auditing thing. In sql2000 you had to do a registry hack - if figure it would...

active active probably provides the best ROI for the tin - you just have to make sure each node is powerful enough to run both nodes sql server(s)

You can load...

ps. I could recommend Andrex < grin >

send them on a sql training course; I'm constantly surprised that many companies do not feel a need to train their dot net developers in T-SQL / SQL Server -...

you should be able to see what is using the pagefile - or have you done this already? I find some windows services use the page file constantly regardless of...

you have to understand the two elements which relate to what you're asking - well actually three I suppose.

Ist is if the data is in cache or has to be...

I have hundreds of queries in cache against temporary tables that look as if they should be parameterised.

That said I have hundreds within the user databases but my best efforts...

with awe the memory is allocated to sql server so what you're asking is how can you see memory usage? Tricky.  A tool such as diagnostic manager , from Idera,...