yes I have this

set @strbig ='db=' + @db + ' and (' + @word + '' + ')' which produces the following

...

you need to setup a page file! SQL uses it.

example. you have a large qry many big table lots of memory, sql will need to do a hash match...

if you do not have the pagefile.sys ...this is telling me that you do not have a Page file set up. but you are saying that you are getting readings...little...

link is for setting memory on a 32 bit: http://msdn.microsoft.com/en-us/library/ms175581(SQL.90).aspx

if you don't set this you wont be using your 16 gig of memory.

yes, check page life expectancy....

here is another ..probaably the best you are going to find, Slava use to work on the SQL engine TEAM.

http://blogs.msdn.com/slavao/archive/2006/11/13/q-a-does-sql-server-always-respond-to-memory-pressure.aspx

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/01/06/configuring-windows-2003-x64-for-sql-server.aspx

after you get it set monitor page...

I have had that problem before, I had reinstall SQL not all of sql just the components pieces I believe. if i remeber correctly the compenent pieces hold the info...

so good news is your pages are staying cache for 600 seconds or 10 min. I would bump th memory up to 10-12 gig from the current 8 although if...

Thanks got to work,

there was no clustered index on the table.....soon as I added that they col were grabbed by clustered index seek.

my only other suggestion is google

TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)

you will see many issues related, some are close some are not.....I finnaly gave up on one my servers, but all the...

try restarting sql server agent.....if that does not work get rid of the profile and account restart AGENT and then re add everything. I have had the same problem in...

try this first, is this a cluster environment if so this can be little more tricky then normal?

http://social.msdn.microsoft.com/Forums/en/sqlnotificationservices/thread/0f2fe589-65fb-4462-812e-a7fddcfcc017

I am little lost, the other server is not on the network?

so how are going to copy and move the data, the script part just go to SSMS, your table...

well a couple of things, the SAN has lots of cache...and SQL uses that by using read ahead, this helps a bunch, the engine will go out an start grabing...

We need to know what the current status of the indexes are?

Maybe the rebuilds hung during the process therefore you could be worse off then when you started. post...

create a lun for temp DB ,make sure you create on file per core and set the size of each of them to the same at startup, 2005+ uses...